How to Create a Data Entry Form in Microsoft Power Apps

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

Рет қаралды 158,789

Күн бұрын

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
www.myexcelonline.com/blog/ho...
⌚ 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...
Join Now ► www.myexcelonline.com/107-42....
📚 Download Our Free 101 Excel Tips & Tricks E-Book: www.myexcelonline.com/101-exc...
💻 [Free Excel Masterclass] Advance Your Excel Level Within 30 Days: www.myexcelonline.com/107-125...
🔥 OUR BEST EXCEL RESOURCES 🔥
Get All Our Excel E-Books: go.myexcelonline.com/101-exce...
101 Most Popular Formulas Paperback on Amazon: www.amazon.com/dp/1700300911
101 Ready To Use Macros Paperback on Amazon: www.amazon.com/dp/1700729675
101 Best Excel Tips & Tricks Paperback on Amazon: www.amazon.com/Best-Excel-Tip...
👷 Excel Consulting Services: www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel tutorials for beginner videos? Check out this playlist: / @myexcelonline
------------
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
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MicrosoftPowerApps #Office365 #createapp #MyExcelOnline

Пікірлер: 114

@pmo4325 Жыл бұрын

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

@MyExcelOnline Жыл бұрын

You are more than welcome! Thanks for letting us know!

@davoc5140 Жыл бұрын

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

@MyExcelOnline Жыл бұрын

Awww, thank you! So glad you liked it!

@AdalbertoGarza-iw3qd Ай бұрын

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

@MyExcelOnline Ай бұрын

So glad it helped!

@solomondavidson2607 Ай бұрын

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

@MyExcelOnline 28 күн бұрын

Thank you very much!

@laszlogyor6628 Жыл бұрын

Excellent video. Thank you.

@MyExcelOnline Жыл бұрын

You're welcome. Glad you liked it!

@user-gh4zy8gu6q 9 ай бұрын

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

@MyExcelOnline 9 ай бұрын

You are SO welcome! Thank you for letting us know!

@Kim-tr1fy 24 күн бұрын

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

@MyExcelOnline 20 күн бұрын

So glad we were able to help!

@joef.matthew 9 ай бұрын

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

@MyExcelOnline 9 ай бұрын

Glad it was helpful and glad you learned something new!

@kswind 2 ай бұрын

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

@MyExcelOnline 2 ай бұрын

So glad it was clear for you. Thanks for letting us know!

@adwinstead Жыл бұрын

Thanks!

@MyExcelOnline Жыл бұрын

Thanks for your support Anthony 🙏

@Amritasthegreatindiantaste 20 күн бұрын

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

@MyExcelOnline 19 күн бұрын

That's great! Thanks for watching!

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

@MyExcelOnline Жыл бұрын

So glad you liked it! Thanks for letting us know!

@manishshrivastava7961 10 ай бұрын

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

@MyExcelOnline 10 ай бұрын

That is so great to hear! Thanks for taking the time to tel us!

@MyExcelOnline 10 ай бұрын

That is so great to hear! Thanks for taking the time to tel us!

@maheshgupte1495 7 ай бұрын

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

@MyExcelOnline 7 ай бұрын

You are most welcome! I will add your idea to our ideas list.

@wilkdawg1 Жыл бұрын

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!

@MyExcelOnline Жыл бұрын

Sure, we will keep that in mind. In the meantime, we do have consulting services that can help. Please check out www.myexcelonline.com/microsoft-excel-consulting-services/

@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

@MyExcelOnline Жыл бұрын

We can add that to our list. Thanks for the request! In the meantime, if you go to 2:38 in the video, you can make a SQL connector instead of an Excel one. Change the connection at 3:09. Instead of selecting Excel, there should be one for SQL.

@lecuae 5 ай бұрын

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?

@MyExcelOnline 5 ай бұрын

You are welcome! You should be able to have a number textbox.

@stlaurent26 10 ай бұрын

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

@MyExcelOnline 10 ай бұрын

Yes, you can prepopulate it with the data from the source. This question is a little more involved than I can answer in a YT comment, but we do have a site where you can ask more technical things like this here: www.myexcelonline.com/microsoft-excel-consulting-services/#

@thenowbasket 8 ай бұрын

awesome!

@MyExcelOnline 8 ай бұрын

Thank you! Cheers!

@jpmd2001 10 ай бұрын

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

@MyExcelOnline 10 ай бұрын

Yes, you should be able to set that up on the dropdown data source.

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

@MyExcelOnline Жыл бұрын

You can choose to not add the gallery and just have data entry fields on the screen. Check out 10:33 in the video.

@stevensmall5279 Жыл бұрын

Great video! Is there a way to get the data cards to populate blank for new data entries?

@MyExcelOnline Жыл бұрын

Yes, probably with the add new function.

@mirrrvelll5164 11 ай бұрын

Great, does it work with SQL source also? I mean these steps and options for Add/Remove/Update?

@MyExcelOnline 11 ай бұрын

Yes it does! Just use SQL as a data source instead of Excel.

@perezselem 7 ай бұрын

Amazing video! Can we add user security to this? Like user having to log in before adding any data, and not able to update other users data?

@MyExcelOnline 7 ай бұрын

Yes! It is very flexible and you could create a login screen and code to check for the correct password.

@kamaleshvasudeva6288 4 ай бұрын

Good one

@MyExcelOnline 4 ай бұрын

Thank you! Cheers!

@markusb3218 2 ай бұрын

This is very helpful tutorial. May I ask how to add a sort button to the galary?

@MyExcelOnline 2 ай бұрын

Hi and thanks for the question. If you are using a SQL statement to connect to data, you could use an order by clause at the end of it. If not, we do offer consulting services and could help you more specifically based on your connection. Here's the link: www.myexcelonline.com/microsoft-excel-consulting-services/

@nindyasofiana 5 ай бұрын

Hi thank you, it's really help, can anyone tell me how the list can show then empty value? so we can add with empty form as well

@MyExcelOnline 5 ай бұрын

Hi. Thanks for the question. Yes, you should be able to do that. It would be a lot to type here, so I would recommend contacting our consulting services here: www.myexcelonline.com/microsoft-excel-consulting-services/

@rohitkarnatakapu4760 11 ай бұрын

Great video. Helped me learn with details. I am trying to delete the row using Remove function, but i get an error "Selected isnt recognised". Can you help me on it

@MyExcelOnline 11 ай бұрын

That's great! We would love to help you. Please check out our consulting services at www.myexcelonline.com/microsoft-excel-consulting-services/#

@shafiqikram2995 Жыл бұрын

amazing videos! May I know how many forms can be created in Power Apps per user plan?

@MyExcelOnline Жыл бұрын

Thanks! Glad you liked it. Maybe this will help you decide? powerapps.microsoft.com/en-us/pricing/

@CMA418 Жыл бұрын

Can I use this method to search and find entries in my database/excel spreadsheet?

@MyExcelOnline Жыл бұрын

Yes, you should be able to do that. Just send a parameter from PowerApps to your datasource or build the SQL on the fly. If you need more help once you get into that, please feel free to contact our consulting services here: www.myexcelonline.com/microsoft-excel-consulting-services/

@bakalogatos7 8 ай бұрын

Hello :) Great and simple explanation for a beginner. How can i automatically add the Date, the username and the email of the end user who is filling this form?

@MyExcelOnline 8 ай бұрын

You might need a macro for this, to enhance the functionality.

@user-kb9pk8bh7j Жыл бұрын

Hello, Awesome Video! I stumbled upon a problem and I'm hoping for help. Upon entering the second button which is the add button in my current app , even though I have no errors in the code whatsoever ( it even recognized the tables and the text field and underlined them with different colors just like in the video) , It doesn't seem to add any additional rows while using the COLLECT function. It works perfectly fine with the update function (when having blank table rows in the list) , but I would like to update my primary data source which is an Excel Table. I've tried multiple solutions but none of them seem to work. Is it a data source issue since mine is using SharePoint? Looking forward to your response. :)

@MyExcelOnline Жыл бұрын

Hi. So glad you liked the video! Yes, we can help. Please see our consulting services page here: www.myexcelonline.com/microsoft-excel-consulting-services/#

@DavidiiDoron 20 күн бұрын

It's really helpful, i have 2 more columns for Date and time. Could you tell me how do I edit that formula for add button. When I do ,date:date.text, there comes an error

@MyExcelOnline 20 күн бұрын

Thanks for the question! Without seeing your project, it'd be hard to troubleshoot, but good news: we have consulting services to help with specific issues like this. Please visit www.myexcelonline.com/microsoft-excel-consulting-services/

@teo11300 2 ай бұрын

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.

@MyExcelOnline 2 ай бұрын

You most likely can do this by setting the values of the boxes to nothing. If you have a specific app you are working on, we offer consulting services to help if you would like: www.myexcelonline.com/microsoft-excel-consulting-services/

@supriyochatterjee4095 Жыл бұрын

Sir can you please kindly make videos related to how to create Company Interactive Dashboard using Power Apps

@MyExcelOnline Жыл бұрын

Sure, we will add that to our list!

@rajkumaravvs7794 9 күн бұрын

Hi it is a great video. But can we create a app shared with different users with unique data populated for each of them.

@MyExcelOnline 7 күн бұрын

Yes you can! If you would like some specific help, we offer taht here: www.myexcelonline.com/microsoft-excel-consulting-services/

@kdavis5450 5 ай бұрын

Is it possible to use power apps to create a form with multiple tabs that sends the data entered on each tab to a specific spreadsheet tab in a single Excel workbook? I have data I want to collect in one workbook but on different tabs. For example, individual tabs in a spreadsheet might be Payables, Receivables, Cash Donations, In-Kind Donations, etc. I'm wondering if power apps can be used to create a tabbed interface (even if it is just buttons across the top of the page that display certain entry fields from each category when clicked). As long as when the form fields that are displayed are updated, the data saves to the specific tab associated with that spreadsheet in the single workbook. Also, can the powerapp be sent to anyone with an internet connection to complete?

@MyExcelOnline 5 ай бұрын

Yes, you should be able to make multiple connections to the same spreadsheet. If you would like some assistance with your project, we do offer consulting services here: www.myexcelonline.com/microsoft-excel-consulting-services/

@michaelbrandmaier2336 Ай бұрын

Nice video. At 14:00 what if i want to collect numeric values? Which data type i would use? with txt it is not working.

@MyExcelOnline Ай бұрын

There should be a number format for you to select for that box instead of text.

@haidoan6993 Жыл бұрын

If first question is about the code employee, if the employee input their code then the second question can be auto show the name? (Can be link with source excel file?

@MyExcelOnline Жыл бұрын

Yes, you should be able to do a lookup after entering a code. If you have a specific project you would like help with, we do offer consulting services here: www.myexcelonline.com/microsoft-excel-consulting-services/#

@nkululekotshabalala4913 Жыл бұрын

It is possible to create Data Entry Form with log in credentials for each person?

@MyExcelOnline Жыл бұрын

Yes if you have Office for Business and use it in your organization.

@piotrrybka318 17 күн бұрын

Shouldn't there be a New button with NewForm(VideoDetails) in OnSelect to clean everything from the form and EditForm(VideoDetail) in OnSelect property of VideoGallery to bring the form back to edit mode after selecting a row in the gallery? And I guess the SubmitForm function would also work on a new record, provided the form is in the new mode.

@MyExcelOnline 14 күн бұрын

Yes, you could do that if you would like.

@moustafaal-tawaijary5034 9 ай бұрын

Is there a way to make an app for grades records,? where parents have to enter their national ID to show their child progress in the class. I'd be grateful if u could guide me.

@MyExcelOnline 9 ай бұрын

Yes, you should be able to do that. Maybe have a login page with the ID and the last name and then proceed with that student's info? If you would like further assistance, we offer consulting services to help you get specifically what you need. Please check out www.myexcelonline.com/microsoft-excel-consulting-services

@nenaborinkena 10 ай бұрын

How do I share the app once its created so other users with link can use it?

@MyExcelOnline 10 ай бұрын

Hi. Thanks for the question! You should be able to go to the Command Bar and click Share and share it from there. Hope that helps!

@SceptileSlash Ай бұрын

Having issues when connecting my form to the gallery. When I try to edit the fields, the button is greyed out even though I've connected it to my data source. Any suggestions?

@MyExcelOnline Ай бұрын

Teh first question I would have is do you have a Microsoft business account or a personal one? It may work better with a business one. If that doesn't help, please feel free to contact our consulting services here for additional help: www.myexcelonline.com/microsoft-excel-consulting-services/

@Kalinigneri 4 ай бұрын

How does this change when u have drop downs in your form?

@MyExcelOnline 4 ай бұрын

It should just be a different control type with a data source attached to it. We have consulting services if you would like help creating it: www.myexcelonline.com/microsoft-excel-consulting-services/

@athanasiosnestoras9096 5 ай бұрын

Why do we use "Collect" & not only the SubmitForm function?

@MyExcelOnline 5 ай бұрын

Hi. Thanks for the question. It's just one example. You can use others depending on what you are wanting to accomplish.

@user-ki9qz5ix4s Жыл бұрын

In the step where you are updating the form using update button, I'm following the same process but once I click on Update the data of that field is gone. Why so?

@MyExcelOnline Жыл бұрын

Oh that's interesting! I am not sure. Perhaps there's additional code on your end? If you would like someone else to take a look, we have consulting services you are welcome to use. Check out the link here: www.myexcelonline.com/microsoft-excel-consulting-services/#

@kebincui 4 ай бұрын

👍❤🌹

@MyExcelOnline 4 ай бұрын

Thanks for watching!

@mydolphin9833 Жыл бұрын

ı just want to bring last entered data to the next form as a defoult but ı just cant that

@MyExcelOnline Жыл бұрын

Hi. Thanks for the question. We offer consulting services if you think that might help: www.myexcelonline.com/microsoft-excel-consulting-services/#

@nicolasvincent1318 3 ай бұрын

The code for the add button doesn't work (it shows an error). Could anybody tell me how to fix it?

@MyExcelOnline 3 ай бұрын

What's the error you are getting?

@soumyasingh8500 Жыл бұрын

Hey, actually when i am linking my table to the table..it is not showing anything

@MyExcelOnline Жыл бұрын

Hi. Thanks for the question. Is there data in your datasource? We also offer consulting services if you would like help with a specific issue: www.myexcelonline.com/microsoft-excel-consulting-services/

@collindow2492 20 күн бұрын

weird, I did everything step by step but it isnt working. its not pulling anything from my table.

@MyExcelOnline 19 күн бұрын

So sorry to hear that. Sometimes it is a settings issue specifically with your account or maybe a setting within the app. We can help troubleshoot if you would like to contact our consulting services at www.myexcelonline.com/microsoft-excel-consulting-services/