PowerApps Single Form App to Save Data in SharePoint List

[@kavyamuniswamappa]

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]

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

[@moisesaardaya]

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]

PowerApps license will be required for external users.

[@tonychiramal6210]

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]

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

[@LORD_ORiGiNALz]

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]

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.

[@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

[@samolppp9976]

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]

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

[@samolppp9976]

@@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.

[@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!!!

[@j.p.nelson5589]

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

[@KeaPointTechTips]

Thank you very much :)

[@danielearp2518]

Only one question... how do I hire you?

[@KeaPointTechTips]

Hi Daniel, email me your requirements at [e-mail]

[@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.

[@sankarredy-o5c]

Hi Sir I have Create in PowerApps From But Data Was Not Save In SharePoint ,But Once Click On the Submit Button Success screen is opened. Please Tell Me Sir How To Resolved The Issue.

[@KeaPointTechTips]

Did the call the form submit method on the button click?

[@omtschand3432]

Very nice simple to the point. A little too fast

[@KeaPointTechTips]

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

[@dean7275]

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]

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

[@stefanender9832]

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]

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

[@blancitaloca]

@@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?

[@kanchanabharath9261]

Thank you so much

[@KeaPointTechTips]

No problem

[@pngtrips6846]

Great thanks

[@KeaPointTechTips]

You are welcome

[@johnnybarideaux1079]

Thank you!!

[@KeaPointTechTips]

You're welcome!

[@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!

[@grundit1]

Excellent!

[@KeaPointTechTips]

Many thanks!

[@knskabul6951]

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

[@KeaPointTechTips]

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

[@kunalpardhi496]

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]

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

[@nancmadi]

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

[@KeaPointTechTips]

You are welcome

[@tommyduncan9582]

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

[@KeaPointTechTips]

Glad it was helpful!

[@roafamily09]

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

[@KeaPointTechTips]

Happy to hear that!

[@silviagualdron15]

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]

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

[@silviagualdron15]

@@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.

[@zerobars3]

Great Tutorial, simple and informative. Thank you,

[@KeaPointTechTips]

Glad it was helpful!

[@kaylamiller3748]

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

[@KeaPointTechTips]

Glad I could help!

[@UncraftedLIVE]

This is a perfect tutorial. THANK YOU!

[@KeaPointTechTips]

You're very welcome Benifi :)

[@Shinupp]

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

[@KeaPointTechTips]

Welcome 😊

[@davidtall7508]

It's a pity you chose to play music during this video, I found it too distracting.

[@KeaPointTechTips]

Hi David, I try to play the music at very low volume in the background. It is just that the viewer don't get bored with talking only.

[@maskabhaji]

Thank you, this was very useful.

[@KeaPointTechTips]

You are welcome!

[@anushakhatri1]

Very useful, exactly what I was looking for

[@KeaPointTechTips]

Glad it was helpful!

[@nanettequevedo5625]

Thanks. It quite simple and easy to follow

[@KeaPointTechTips]

Glad it helped!

[@sarfarazshaikh6133]

Thank you you teach very quick and easily

[@KeaPointTechTips]

You are welcome!

[@dileepsyed7402]

very useful information thank you

[@KeaPointTechTips]

Glad it was helpful!

[@anistala]

Very crisp instructions. Thank you!

[@KeaPointTechTips]

Glad it was helpful!

[@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?

[@CandaceMillerPhD]

Really well done video. Thanks

[@KeaPointTechTips]

Glad you liked it!

[@hme1959]

Thanks for the good tutorial

[@KeaPointTechTips]

You're welcome *Halil !*

[@markone6861]

You are a Boss

[@KeaPointTechTips]

I hope it helped you.

[@markone6861]

@@KeaPointTechTips yes you did sir

[@markone6861]

@@KeaPointTechTips yes you did sir

[@safetysay2756]

5:16 New form

[@That_Wojak_Show]

Thank you , you really helped me

[@KeaPointTechTips]

Glad I could help!

[@niteshgoswami1445]

this is actually helpful. Thanks a lot

[@KeaPointTechTips]

Glad it helped!

[@terrycuevaa.9895]

It is simple and straight to the point.

[@KeaPointTechTips]

Thank you.

[@x-9ja]

Thanks for making it simple 💌

[@KeaPointTechTips]

You’re welcome 😊

[@dmitriyivanov1309]

Very useful! Thank you!!!

[@KeaPointTechTips]

Glad it was helpful!

[@ravip9807]

Simple explanation :)

[@KeaPointTechTips]

Glad you liked it

[@jasonf2753]

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]

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.

[@sredzaredza1131]

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]

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

[@learningsessions4584]

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]

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

[@craigleadley2472]

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

[@KeaPointTechTips]

Thank you.!

[@jjordan2005]

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

[@KeaPointTechTips]

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

[@prakashmangalwadeka]

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]

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]

@@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.

[@prabakaranmunusamy1685]

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]

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

[@prabakaranmunusamy1685]

@@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

[@dinakarareddy1126]

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

[@KeaPointTechTips]

Glad you liked it!

[@blackhairnet]

Your instructions are very clear and concise.

[@KeaPointTechTips]

Thank you.

[@vernonlomax1721]

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]

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

[@vernonlomax1721]

@@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]

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

[@hmihe5420]

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]

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

[@hmihe5420]

@@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

[@darkspeed62]

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]

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