PowerApps Single Form App to Save Data in SharePoint List

Подписаться 10 тыс.

Просмотров 102 тыс.

50% 1

In this video you will learn how to create PowerApps single form app to save data in SharePoint List. You can quickly create an app from SharePoint list which will automatically provision the display, edit and detail forms for you. But what if you just need to collect for example employee feedback. In this case you only need one form which can capture the feedback and save to SharePoint list. Or What if the SharePoint data entry form is a part of a larger Power app application, in these cases the fully functional SharePoint PowerApps application will not be an appropriate approach. Hence, we need to create the data entry form in PowerApps from stretch and link it to SharePoint lists data source to create new records.
Support me with your Amazon purchases, click here: amzn.to/3e6ZrSM
🔴 ** BE OUR FRIEND - SUBSCRIBE & FOLLOW **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerappsForm
#PowerAppsSharePointList
#PowerPlatform

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 124

@kaylamiller3748 2 года назад

I spent way to long today trying to find exactly what you did. I knew it was easy! Thank you

@KeaPointTechTips 2 года назад

Glad I could help!

@j.p.nelson5589 2 года назад

You are my hero!!!! Straight to the point with essential answers!!! Thank you!

@KeaPointTechTips 2 года назад

Thank you very much :)

@terrycuevaa.9895 3 года назад

It is simple and straight to the point.

@KeaPointTechTips 3 года назад

Thank you.

@anistala 3 года назад

Very crisp instructions. Thank you!

@KeaPointTechTips 3 года назад

Glad it was helpful!

@blackhairnet 3 года назад

Your instructions are very clear and concise.

@KeaPointTechTips 3 года назад

Thank you.

@UncraftedLIVE 2 года назад

This is a perfect tutorial. THANK YOU!

@KeaPointTechTips 2 года назад

You're very welcome Benifi :)

@tommyduncan9582 2 года назад

Thanks so much. Nice and simple but just what I needed to get some confidence to discover more

@KeaPointTechTips 2 года назад

Glad it was helpful!

@nancmadi Год назад

Hi Thank you so much, baby steps, now I have to do big things to make more stuff work.

@KeaPointTechTips Год назад

You are welcome

@anushakhatri1 2 года назад

Very useful, exactly what I was looking for

@KeaPointTechTips 2 года назад

Glad it was helpful!

@sarfarazshaikh6133 3 года назад

Thank you you teach very quick and easily

@KeaPointTechTips 3 года назад

You are welcome!

@dinakarareddy1126 3 года назад

Its really simple and excellent to the content.. Appreciate it

@KeaPointTechTips 3 года назад

Glad you liked it!

@craigleadley2472 Год назад

This was a very clear video and helped me enormously. Thank you.

@KeaPointTechTips Год назад

Thank you.!

@roafamily09 2 года назад

thank you for your video. i learned so much and your explanations are great!

@KeaPointTechTips 2 года назад

Happy to hear that!

@niteshgoswami1445 3 года назад

this is actually helpful. Thanks a lot

@KeaPointTechTips 3 года назад

Glad it helped!

@dmitriyivanov1309 2 года назад

Very useful! Thank you!!!

@KeaPointTechTips 2 года назад

Glad it was helpful!

@nanettequevedo5625 3 года назад

Thanks. It quite simple and easy to follow

@KeaPointTechTips 3 года назад

Glad it helped!

@maskabhaji Год назад

Thank you, this was very useful.

@KeaPointTechTips Год назад

You are welcome!

@zerobars3 2 года назад

Great Tutorial, simple and informative. Thank you,

@KeaPointTechTips 2 года назад

Glad it was helpful!

@dean7275 3 года назад

Great video very helpful thank you so much! Please keep making more tutorial videos on how to do specific tasks that come up in a workplace like this :)

@KeaPointTechTips 3 года назад

Thank you for the encouraging comment Dean. I will continue adding more videos.

@johnnybarideaux1079 2 года назад

Thank you!!

@KeaPointTechTips 2 года назад

You're welcome!

@Shinupp 3 года назад

Thanks for uploading this video. I was looking for a canvas app creation

@KeaPointTechTips 3 года назад

Welcome 😊

@darkspeed62 2 года назад

This was a really good tutorial, Simple and too the point, one of the bells and whistles. Sometimes you just need the basics to get started. Thanks!

@KeaPointTechTips 2 года назад

Thank you. I try to make videos tailored for the business users with basic IT skills.

@adaholotu3981 Год назад

Thanks for making it simple 💌

@KeaPointTechTips Год назад

You’re welcome 😊

@That_Wojak_Show 2 месяца назад

Thank you , you really helped me

@KeaPointTechTips 2 месяца назад

Glad I could help!

@pngtrips6846 Год назад

Great thanks

@KeaPointTechTips Год назад

You are welcome

@hme1959 2 года назад

Thanks for the good tutorial

@KeaPointTechTips 2 года назад

You're welcome *Halil !*

@kanchanabharath9261 2 года назад

Thank you so much

@KeaPointTechTips 2 года назад

No problem

@grundit1 2 года назад

Excellent!

@KeaPointTechTips 2 года назад

Many thanks!

@dileepsyed7402 3 года назад

very useful information thank you

@KeaPointTechTips 3 года назад

Glad it was helpful!

@CandaceMillerPhD 2 года назад

Really well done video. Thanks

@KeaPointTechTips 2 года назад

Glad you liked it!

@ravip9807 2 года назад

Simple explanation :)

@KeaPointTechTips 2 года назад

Glad you liked it

@businessreadinessprotectio3867 Год назад

This was really useful. Thanks. Once I submit the first lot of data how could i get the form to reset so that I could enter the next lot instead of going to the success screen?

@anatolijkovalenko9696 Год назад

Hello! I really enjoyed your tutorials on Power apps. Maybe you can upload a video on how to create a power apps visitor registration form where you can see the time, when they arrived, when they left, who came and to whom. How to enable search and edit data. Thank you very much.

@KeaPointTechTips Год назад

Thanks for the idea!

@stefanender9832 3 года назад

Hi - Thanks for the very detailled step-by-step explanation, I cant believe how simple you make this look (as opposed to other examples on the topic that I have seen). Did you already make a video on how to edit previously submitted data? Lets say you have quarterly data collection, but want to provide the user with the option to update the input from last Q, instead of entering everything all over again... Thanks!

@KeaPointTechTips 3 года назад

Glad it was helpful! I will add the desired topic to my list and may create a video on it in near future.

@blancitaloca 2 года назад

@@KeaPointTechTips Hello, wonderful video. I was able to follow it with no problems. Also interested in pulling up and editing an existing record. Have you created that video yet?

@markone6861 3 года назад

You are a Boss

@KeaPointTechTips 3 года назад

I hope it helped you.

@markone6861 3 года назад

@@KeaPointTechTips yes you did sir

@markone6861 3 года назад

@@KeaPointTechTips yes you did sir

@windsorhunk Год назад

I was your 1000th like. One of the best tutorials I've seen. Do you know any way to manipulate the Title field? I tried hiding it, view text only, etc., but nothing works. It's that I don't need a single line of text in my form at all, hence no need for title.

@basheerpt Год назад

Good knowledge. Thank you. How we can add a field for attachment?

@KeaPointTechTips Год назад

There is a default attachment field. You can not add more attachment fields to the list

@moisesaardaya 2 года назад

This is exactly what I need to do for a project. Is it possible to share this form to externals (not members of the Sharepoint/Domain)?

@KeaPointTechTips 2 года назад

PowerApps license will be required for external users.

@hmihe5420 3 года назад

Thanks - this is a really helpful and concise video. Would you be be able to help me with a couple of questions - Is it possible to link the form to a sharepoint library rather than a list? Can a form which is feeding into a sharepoint list / library also have a cascading dropdown where data is being fetched from another sharepoint list? (So part of the list is pre-populated and the rest is for completion). Thanks

@KeaPointTechTips 3 года назад

Yes, absolutely. You can save files form PowerApps to SharePoint library. I have made another video which can help you create cascade lookup.

@hmihe5420 3 года назад

@@KeaPointTechTips Thank you so much for your quick response. When I follow the information in the cascading dropdown video adding 'edit form' isn't mentioned and so I can't click onto it to add the data source - please can you tell me how I connect to the library I want the cascading dropdowns to feed into. (With cascading dropdowns there is no 'form' and no 'data cards' listed for the screen, only the dropdowns). thank you

@knskabul6951 3 года назад

Very nice. One question ( I can not see my sharepoint connector under the connector when adding the Data?

@KeaPointTechTips 3 года назад

You can search for SharePoint in the collection menu and create a new connection.

@omtschand3432 3 года назад

Very nice simple to the point. A little too fast

@KeaPointTechTips 3 года назад

Thank you for your advice, much appreciated. I just need to keep the right balance between too fast and and too slow.

@sredzaredza1131 3 года назад

First I must say thank you for, really good input. But I have a small issue. Followed your guide and successfully make entry into a sharepoint list. But in 2nd attempt to make another entry during the same session, the form now blanks with msg "No item to display". Why I can't make another data entry?

@KeaPointTechTips 3 года назад

You can reset the form on submit. It should then work.

@jasonf2753 2 года назад

I don't use Sharepoint, is it possible to update the new records to a blank Excel file on OneDrive? Thanks for the helpful, concise videos.

@KeaPointTechTips 2 года назад

I would recommend not to use Excel as a data source, Use SharePoint or DataVerse . They are easy to set up and are much better solution than excel file. You can use excel sheet to create update and remove records using PowerApps.

@samolppp9976 2 года назад

thanks for the video. sir. i have a question- how to close the successscreen, after the insertion to splist was occured. am unable to close the successcreen after displaying that successscreen. pls help

@KeaPointTechTips 2 года назад

You can add link to home page in success me. You can also add a timer function to redirect after few seconds.

@samolppp9976 2 года назад

@@KeaPointTechTips thanks for your reply. can you pls show, how to add a timer function and what code , i need to write to redirect after few seconds.

@prabakaranmunusamy1685 2 года назад

Question: In the description (power app) could we have input on the second line. For example in description box you type "Hello, This is test", now i would like continue type but it should be on the second and same as in the sharepoint list. Any advise

@KeaPointTechTips 2 года назад

Yes you can, create a multiline text filed in SharePoint. In PowerApps form, change the textbox property to multiline.

@prabakaranmunusamy1685 2 года назад

@@KeaPointTechTips Dear Sir, to be more specific, yes, i changed already to multiline. Now when I fill the form in power app form, say example "Hello this is test 1", it will updated in share point list as "Hello this is test 1". However, when i want to edit "Hello this is test 1" again with additional wording with "23/7/2021 This is test 2", now in sharepoint list shows as "Hello this is test 1 23/7/2021 This is test 2"(continuously). What i need is "Hello this is test 1" and "23/7/2021 This is test 2" in separate "line" in same row of sharepoint list

@ashimishra23 Год назад

Thanks for the informative video!!! I am struggling with below use case. Looking for your help on how to achieve this. Developing a PowerApp form to capture location preference for employees. While filling the form -> Employees will be asked to select a country and state ( multichoice). State field (dependent on Country field) will be multiselect meaning each user can select one country and multiple states. Country & States will be fetched from a list called "Location" Form will be submitted to another list called "Employees Data" I also need to develop EDIT form for same use case. Where user can fetch previously submitted record and can view the selection and edit same. Form developed using List-1 whereas the Location is pulled data from list-2. Data Sources are sharepoint list. Thank you in advance!!!

@vernonlomax1721 3 года назад

Thanks. This video was just what I needed to create a form for my custom list. Unfortunately, I cannot resolve 2 Errors on the Button1 .OnSelect: 1. The function expects an editable form as its input. 2. The function 'SubmitForm' has some invalid arguments. Both my form and button point to the same custom list. Any suggestions on resolving these errors?

@KeaPointTechTips 3 года назад

Did you change the form mode to "Edit"? from the form property menu.

@vernonlomax1721 3 года назад

@@KeaPointTechTips Yes, the form mode is 'Edit' on the Button property menu. I get an error when I add 'SubmitForm' on the formular bar with the button selected. Adding the source doesn't fix the error.

@vernonlomax1721 3 года назад

@@KeaPointTechTips Anytime I enter 'SubmitForm' in the function field, I get an error. Is there another function to use on the submit button?

@prakashmangalwadeka 2 года назад

Short but Great Tutorial. I would like to know two more steps to add to this form. When we click on Submit Button, it takes us to the Success Screen. Here I want to have a step which will again go back to the New Form i.e. after we hit the Submit Button, it should say the Form is Submitted and than go back to the New Form. Secondly when the form is submitted, is there a way the SharePoint automatically gets refreshed ? Let me know how this can be achieved. Thanks in advance.

@KeaPointTechTips 2 года назад

You can reset form on successful submission and just show the success message on the the same screen. I did not get the second question.

@anishpatel5049 2 года назад

@@KeaPointTechTips Can you please show how it will be achieved? I want to do same thing once it click submit button it shows success screen form is submitted and goes back to new form. I also need help to create login page as well. Please need your help.

@kavyamuniswamappa 2 года назад

Hi..I have a question here... can we save the powerapp New form as a file in SharePoint? Like we save InfoPath form as file..

@KeaPointTechTips 2 года назад

Nope, but you can use power automate to extract PowerApps form data and generate a form or pdf file.

@tonychiramal6210 2 года назад

Hi, how can we create a hyperlink of this form to share with users to add new feedback without seeing the whole list or any other details about the list. In other words can we create a hyperlink button on sharepoint page for users to click and add item to list.

@KeaPointTechTips 2 года назад

Yes you can create a button and set the source to a success page url so they don't end up on the list page after creating the item

@silviagualdron15 2 года назад

Hi! Thank you very much for the video, I am able to capture all the information and pictures and they are sent to the sharepoint site. However, when I go in the app and try it, it gets stuck after I click on Submit and says they are getting my data, the data is however exported to sharepoint but I am unable to go back an capture another entry. My app should be able to record a lof of entries per day, could you please help?

@KeaPointTechTips 2 года назад

I think you need to update the form property and set it as new form instead of edit form.

@silviagualdron15 2 года назад

@@KeaPointTechTips I did, but later on on your video (6:21) you change again the form to be set up as "OnSucess" and then "Navigate" to success screen. So the "new" part dissapeared.

@learningsessions4584 3 года назад

Hi, can you please help - following all steps as shown in video. When I hit play button on PowerApps it says no items to display. Can not understand what is the issue.

@KeaPointTechTips 3 года назад

Can you make sure that the power app form mode is New instead of Edit?

@LORD_ORiGiNALz 2 года назад

Hi I got a problem where I have two text fields that I set up that require input from the user however I have a third text field and when the user enters the information into the two required text fields and leaves the third textfield empty it comes up with an error saying - ""An entry is required or has an invalid value. Please correct and try again." any suggestions please

@KeaPointTechTips 2 года назад

Change the third field property "Is Required" to false. Also check that teh field in SharePoint list is also not set to as required field.

@jjordan2005 3 года назад

Help! I used onsuccess and when I test it, it's taking me to the sharepoint list rather than the success popup

@KeaPointTechTips 3 года назад

Have you added NavigateTo method on form success ? It should work

@kunalpardhi496 2 года назад

hello dear, i need your help , my problem is , m unable to save the form , i have three checkboxes in my form, unless i check all of the checkboxes and fill their respective enabled fields despite the checkboxes are not required . what should i do to successfully save my form

@KeaPointTechTips 2 года назад

Sorry but it will be hard to suggest what's wrong with the form without looking at the app.