How to Create a Data Entry Form in Microsoft Power Apps - A Tutorial

Watch How to Create a Data Entry Form in Microsoft Power Apps - A Tutorial to learn all about data entry forms. We will go over how to access Power Apps. Then we will talk about what a data source is and how to connect to one through Power Apps. We will review what a form and a gallery are. Then finally, we will show you how to modify data by editing, adding, and deleting records in the existing data set. This is a great video to learn how to create a data entry form in Microsoft Power Apps.

📥 Visit our blog for many samples of Office files at

⌚ Time Stamps:
00:00 - Introduction to How to Create a Data Entry Form in Microsoft Power Apps - A Tutorial
00:26 - How to Access Microsoft Power Apps
01:09 - Reviewing the Microsoft Excel Data Source
02:23 - Creating a Data Connection in Microsoft Power Apps
07:29 - Connecting a Form and a Gallery in Microsoft Power Apps
08:28 - Editing a Record in a Data Form in Microsoft Power Apps
10:32 - Adding a Record in a Data Form in Microsoft Power Apps
16:15 - Deleting a Record in a Data Form in Microsoft Power Apps
17:49 - Conclusion for How to Create a Data Entry Form in Microsoft Power Apps - A Tutorial
------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MicrosoftPowerApps #Office365 #createapp #MyExcelOnline

[pmo]

This is clearer than any other video on the topic. Thank you!

[davoc]

This lady has a gift for teaching - what a breath of fresh air!

[AdalbertoGarza-iwqd]

Using this in May 2024, so informative and clear! Thank you!

[solomondavidson]

This lady is a proper teacher, everything is super clear and well explained.

[ghzyguq]

Amazing video. Really clear and useful. Will be great start foe myself to start using Power Apps. Thank you!

[kswind]

Yup, it is the best video! without any confusion! thank you

[Kim-trfy]

Thank you! You have completely demystified PowerApps for me! Game changer!

[joef.matthew]

Great video....column head's name with space....new one I

[Amritasthegreatindiantaste]

Thanks, Easy to understand as a beginner i learned my first app from you . 💃💃

[blackwoodscider]

amazing video - many thanks!
for some reason the collect formula from 13:10 gave an error in file types, but I found a quicker solution without referencing each field individually Collect(collection, form.Updates) - maybe you can tell about this in the next video)

[manishshrivastava]

Hii, great explanation . I am new to PowerApps have seen multiple videos but come to know detail by watching this only. Very clear Explanation

[maheshgupte]

Thank you very much for making this video. Can you please make a video for input as drop down instead of manual entry also provide an option to select the add record in database for editing

[wilkdawg]

This is great! Thanks so much. I am having issues pulling a date from my form into the excle data source. Could you help? Perhaps you have another tutorial that covers this? Thanks again!

[teo]

This is great. However, to add a new record, you need to manually remove all text present in the form. Would be nice if there was an option to clear all visible text in the form, ready for you to start entering new data.

[hbgbznn]

Thank you for the video. Nice work Ma shaa allah.

[lecuae]

Thank you very much for very clear and concise video. what if we collect numbers? We write.Text against the input column what do we write if we have number values?

[stlaurent]

good video, question for adding a new record: instead of typing it in, is there a way to populate it from another source?
Say, 2 data sources (d1, d2) -> search / filter d1 > select a record > populate selection to a form > edit then submit form as a new record for d2. This applies to many business scenarios, thanks

[lilliththequeen]

Thanks for the great video! I'd like to create a data entry table where users input, let's say, their requested articles, and I'd like these requests to be automatically entered into my Excel file. Your showcase is similar to that but I don't want my users to see the list on the left hand side on your video. How can I do that? Thanks!

[MrHackmed]

Great job, this is awesome, this is so apt, and straightforward. Can you please do a video on using SQL as a data source from scratch instead of Excel?

Thanks

[jpmd]

Great, thanks! I could replicate this perfectly. Is there a way to pick data from a dropdown picking data from a separate data source? For example, Category could be taken from a dropdown list to avoid errors. Thank you so much