How to Create a Data Entry Form in Microsoft Power Apps - A Tutorial
HTML-код
- Опубликовано: 13 май 2024
- 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
Using this in May 2024, so informative and clear! Thank you!
So glad it helped!
This is clearer than any other video on the topic. Thank you!
You are more than welcome! Thanks for letting us know!
Amazing video. Really clear and useful. Will be great start foe myself to start using Power Apps. Thank you!
You are SO welcome! Thank you for letting us know!
This lady has a gift for teaching - what a breath of fresh air!
Awww, thank you! So glad you liked it!
Yup, it is the best video! without any confusion! thank you
So glad it was clear for you. Thanks for letting us know!
Excellent video. Thank you.
You're welcome. Glad you liked it!
Great video....column head's name with space....new one I learned.....
Glad it was helpful and glad you learned something new!
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
You are most welcome! I will add your idea to our ideas list.
Hii, great explanation . I am new to PowerApps have seen multiple videos but come to know detail by watching this only. Very clear Explanation
That is so great to hear! Thanks for taking the time to tel us!
That is so great to hear! Thanks for taking the time to tel us!
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)
So glad you liked it! Thanks for letting us know!
Thanks!
Thanks for your support Anthony 🙏
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!
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/
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!
You can choose to not add the gallery and just have data entry fields on the screen. Check out 10:33 in the video.
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
Yes, you should be able to set that up on the dropdown data source.
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
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/#
This is very helpful tutorial. May I ask how to add a sort button to the galary?
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/
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
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.
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?
You are welcome! You should be able to have a number textbox.
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
That's great! We would love to help you. Please check out our consulting services at www.myexcelonline.com/microsoft-excel-consulting-services/#
Great video! Is there a way to get the data cards to populate blank for new data entries?
Yes, probably with the add new function.
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?
Yes! It is very flexible and you could create a login screen and code to check for the correct password.
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
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/
Great, does it work with SQL source also? I mean these steps and options for Add/Remove/Update?
Yes it does! Just use SQL as a data source instead of Excel.
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. :)
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/#
Can I use this method to search and find entries in my database/excel spreadsheet?
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/
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?
You might need a macro for this, to enhance the functionality.
awesome!
Thank you! Cheers!
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.
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/
Good one
Thank you! Cheers!
amazing videos! May I know how many forms can be created in Power Apps per user plan?
Thanks! Glad you liked it. Maybe this will help you decide? powerapps.microsoft.com/en-us/pricing/
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?
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/
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.
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
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?
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/#
Sir can you please kindly make videos related to how to create Company Interactive Dashboard using Power Apps
Sure, we will add that to our list!
How do I share the app once its created so other users with link can use it?
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!
It is possible to create Data Entry Form with log in credentials for each person?
Yes if you have Office for Business and use it in your organization.
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?
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/#
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?
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/
How does this change when u have drop downs in your form?
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/
Why do we use "Collect" & not only the SubmitForm function?
Hi. Thanks for the question. It's just one example. You can use others depending on what you are wanting to accomplish.
The code for the add button doesn't work (it shows an error). Could anybody tell me how to fix it?
What's the error you are getting?
ı just want to bring last entered data to the next form as a defoult but ı just cant that
Hi. Thanks for the question. We offer consulting services if you think that might help: www.myexcelonline.com/microsoft-excel-consulting-services/#
Hey, actually when i am linking my table to the table..it is not showing anything
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/
👍❤🌹
Thanks for watching!
something missing on new data, to make sure the text box empty
Hi. I am not sure what you are asking. Are you asking to ensure a value has been entered?
@@MyExcelOnline to make sure the form is empty when trying to input another data
You may want to make sure you are going to a new record when opening the form.
Thanks!
How can you use a search button to point to the certain record?
You bet!
If you use one of the templates to make a sample app, the code will be made for you and you can tweak it from there. Hope that helps!