Тёмный

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

MyExcelOnline.com
Подписаться 141 тыс.
Просмотров 181 тыс.
50% 1

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

 

19 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 120   
@solomondavidson2607
@solomondavidson2607 3 месяца назад
This lady is a proper teacher,everything is super clear and well explained.
@MyExcelOnline
@MyExcelOnline 3 месяца назад
Thank you very much!
@davoc5140
@davoc5140 Год назад
This lady has a gift for teaching - what a breath of fresh air!
@MyExcelOnline
@MyExcelOnline Год назад
Awww, thank you! So glad you liked it!
@pmo4325
@pmo4325 Год назад
This is clearer than any other video on the topic. Thank you!
@MyExcelOnline
@MyExcelOnline Год назад
You are more than welcome! Thanks for letting us know!
@AdalbertoGarza-iw3qd
@AdalbertoGarza-iw3qd 4 месяца назад
Using this in May 2024, so informative and clear! Thank you!
@MyExcelOnline
@MyExcelOnline 4 месяца назад
So glad it helped!
@franciscoorozco2625
@franciscoorozco2625 22 дня назад
finally a video that explains clearly, thanks a lot!
@MyExcelOnline
@MyExcelOnline 21 день назад
Glad it helped! You're welcome!
@Becaye-gi5sb
@Becaye-gi5sb 11 дней назад
Amazing video! Props to you!
@MyExcelOnline
@MyExcelOnline 10 дней назад
Thanks! Glad you liked it!
@Kim-tr1fy
@Kim-tr1fy 3 месяца назад
Thank you! You have completely demystified PowerApps for me! Game changer!
@MyExcelOnline
@MyExcelOnline 3 месяца назад
So glad we were able to help!
@maheshgupte1495
@maheshgupte1495 10 месяцев назад
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
@MyExcelOnline 10 месяцев назад
You are most welcome! I will add your idea to our ideas list.
@Amritasthegreatindiantaste
@Amritasthegreatindiantaste 3 месяца назад
Thanks , Easy to understand as a beginner i learned my first app from you . 💃💃
@MyExcelOnline
@MyExcelOnline 3 месяца назад
That's great! Thanks for watching!
@ПавелСтафеев-м4р
Amazing video. Really clear and useful. Will be great start foe myself to start using Power Apps. Thank you!
@MyExcelOnline
@MyExcelOnline Год назад
You are SO welcome! Thank you for letting us know!
@manishshrivastava7961
@manishshrivastava7961 Год назад
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
@MyExcelOnline Год назад
That is so great to hear! Thanks for taking the time to tel us!
@MyExcelOnline
@MyExcelOnline Год назад
That is so great to hear! Thanks for taking the time to tel us!
@joef.matthew
@joef.matthew Год назад
Great video....column head's name with space....new one I learned.....
@MyExcelOnline
@MyExcelOnline Год назад
Glad it was helpful and glad you learned something new!
@testingaccount-x9b
@testingaccount-x9b 2 месяца назад
Thank you for the video. Nice work Ma shaa allah.
@MyExcelOnline
@MyExcelOnline 2 месяца назад
Always welcome!
@kswind
@kswind 5 месяцев назад
Yup, it is the best video! without any confusion! thank you
@MyExcelOnline
@MyExcelOnline 5 месяцев назад
So glad it was clear for you. Thanks for letting us know!
@user-blackwoodscider
@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
@MyExcelOnline Год назад
So glad you liked it! Thanks for letting us know!
@stlaurent26
@stlaurent26 Год назад
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
@MyExcelOnline Год назад
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/#
@lecuae
@lecuae 7 месяцев назад
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
@MyExcelOnline 7 месяцев назад
You are welcome! You should be able to have a number textbox.
@laszlogyor6628
@laszlogyor6628 Год назад
Excellent video. Thank you.
@MyExcelOnline
@MyExcelOnline Год назад
You're welcome. Glad you liked it!
@MrHackmed
@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
@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.
@wilkdawg1
@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
@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/
@markusb3218
@markusb3218 5 месяцев назад
This is very helpful tutorial. May I ask how to add a sort button to the galary?
@MyExcelOnline
@MyExcelOnline 5 месяцев назад
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/
@stevensmall5279
@stevensmall5279 Год назад
Great video! Is there a way to get the data cards to populate blank for new data entries?
@MyExcelOnline
@MyExcelOnline Год назад
Yes, probably with the add new function.
@perezselem
@perezselem 10 месяцев назад
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
@MyExcelOnline 10 месяцев назад
Yes! It is very flexible and you could create a login screen and code to check for the correct password.
@adwinstead
@adwinstead Год назад
Thanks!
@MyExcelOnline
@MyExcelOnline Год назад
Thanks for your support Anthony 🙏
@teo11300
@teo11300 5 месяцев назад
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
@MyExcelOnline 5 месяцев назад
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/
@nindyasofiana
@nindyasofiana 8 месяцев назад
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
@MyExcelOnline 8 месяцев назад
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/
@rajkumaravvs7794
@rajkumaravvs7794 2 месяца назад
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
@MyExcelOnline 2 месяца назад
Yes you can! If you would like some specific help, we offer taht here: www.myexcelonline.com/microsoft-excel-consulting-services/
@DavidiiDoron
@DavidiiDoron 3 месяца назад
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
@MyExcelOnline 3 месяца назад
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/
@bakalogatos7
@bakalogatos7 11 месяцев назад
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
@MyExcelOnline 10 месяцев назад
You might need a macro for this, to enhance the functionality.
@jpmd2001
@jpmd2001 Год назад
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
@MyExcelOnline Год назад
Yes, you should be able to set that up on the dropdown data source.
@michaelbrandmaier2336
@michaelbrandmaier2336 4 месяца назад
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
@MyExcelOnline 4 месяца назад
There should be a number format for you to select for that box instead of text.
@rohitkarnatakapu4760
@rohitkarnatakapu4760 Год назад
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
@MyExcelOnline Год назад
That's great! We would love to help you. Please check out our consulting services at www.myexcelonline.com/microsoft-excel-consulting-services/#
@kamaleshvasudeva6288
@kamaleshvasudeva6288 6 месяцев назад
Good one
@MyExcelOnline
@MyExcelOnline 6 месяцев назад
Thank you! Cheers!
@shafiqikram2995
@shafiqikram2995 Год назад
amazing videos! May I know how many forms can be created in Power Apps per user plan?
@MyExcelOnline
@MyExcelOnline Год назад
Thanks! Glad you liked it. Maybe this will help you decide? powerapps.microsoft.com/en-us/pricing/
@lilliththequeen
@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
@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.
@mirrrvelll5164
@mirrrvelll5164 Год назад
Great, does it work with SQL source also? I mean these steps and options for Add/Remove/Update?
@MyExcelOnline
@MyExcelOnline Год назад
Yes it does! Just use SQL as a data source instead of Excel.
@piotrrybka318
@piotrrybka318 3 месяца назад
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
@MyExcelOnline 3 месяца назад
Yes, you could do that if you would like.
@thenowbasket
@thenowbasket 11 месяцев назад
awesome!
@MyExcelOnline
@MyExcelOnline 11 месяцев назад
Thank you! Cheers!
@kdavis5450
@kdavis5450 7 месяцев назад
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
@MyExcelOnline 7 месяцев назад
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/
@haidoan6993
@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
@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/#
@SceptileSlash
@SceptileSlash 4 месяца назад
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
@MyExcelOnline 4 месяца назад
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
@Kalinigneri 7 месяцев назад
How does this change when u have drop downs in your form?
@MyExcelOnline
@MyExcelOnline 6 месяцев назад
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/
@supriyochatterjee4095
@supriyochatterjee4095 Год назад
Sir can you please kindly make videos related to how to create Company Interactive Dashboard using Power Apps
@MyExcelOnline
@MyExcelOnline Год назад
Sure, we will add that to our list!
@CMA418
@CMA418 Год назад
Can I use this method to search and find entries in my database/excel spreadsheet?
@MyExcelOnline
@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/
@APBITEMS
@APBITEMS Год назад
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
@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/#
@moustafaal-tawaijary5034
@moustafaal-tawaijary5034 11 месяцев назад
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
@MyExcelOnline 11 месяцев назад
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
@athanasiosnestoras9096
@athanasiosnestoras9096 8 месяцев назад
Why do we use "Collect" & not only the SubmitForm function?
@MyExcelOnline
@MyExcelOnline 8 месяцев назад
Hi. Thanks for the question. It's just one example. You can use others depending on what you are wanting to accomplish.
@nkululekotshabalala4913
@nkululekotshabalala4913 Год назад
It is possible to create Data Entry Form with log in credentials for each person?
@MyExcelOnline
@MyExcelOnline Год назад
Yes if you have Office for Business and use it in your organization.
@setupatel1267
@setupatel1267 Месяц назад
I'm unable to click on 'add field'. Please help!!!
@MyExcelOnline
@MyExcelOnline Месяц назад
Hi. do you have the whole version of Power Apps?
@nicolasvincent1318
@nicolasvincent1318 6 месяцев назад
The code for the add button doesn't work (it shows an error). Could anybody tell me how to fix it?
@MyExcelOnline
@MyExcelOnline 6 месяцев назад
What's the error you are getting?
@nenaborinkena
@nenaborinkena Год назад
How do I share the app once its created so other users with link can use it?
@MyExcelOnline
@MyExcelOnline Год назад
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!
@collindow2492
@collindow2492 3 месяца назад
weird, I did everything step by step but it isnt working. its not pulling anything from my table.
@MyExcelOnline
@MyExcelOnline 3 месяца назад
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/
@soumyasingh8500
@soumyasingh8500 Год назад
Hey, actually when i am linking my table to the table..it is not showing anything
@MyExcelOnline
@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/
@mydolphin9833
@mydolphin9833 Год назад
ı just want to bring last entered data to the next form as a defoult but ı just cant that
@MyExcelOnline
@MyExcelOnline Год назад
Hi. Thanks for the question. We offer consulting services if you think that might help: www.myexcelonline.com/microsoft-excel-consulting-services/#
@kebincui
@kebincui 6 месяцев назад
👍❤🌹
@MyExcelOnline
@MyExcelOnline 6 месяцев назад
Thanks for watching!
@ucup33
@ucup33 7 месяцев назад
something missing on new data, to make sure the text box empty
@MyExcelOnline
@MyExcelOnline 7 месяцев назад
Hi. I am not sure what you are asking. Are you asking to ensure a value has been entered?
@ucup33
@ucup33 7 месяцев назад
@@MyExcelOnline to make sure the form is empty when trying to input another data
@MyExcelOnline
@MyExcelOnline 7 месяцев назад
You may want to make sure you are going to a new record when opening the form.
@stevenlutz8943
@stevenlutz8943 Год назад
Thanks!
@stevenlutz8943
@stevenlutz8943 Год назад
How can you use a search button to point to the certain record?
@MyExcelOnline
@MyExcelOnline Год назад
You bet!
@MyExcelOnline
@MyExcelOnline Год назад
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!
Далее
How to Use a Collection in Microsoft Power Apps
9:26
У НАС ДОМА ЗАВЕЛАСЬ КРЫСА 🐀
01:00
EASILY Make an Automated Data Entry Form in Excel
14:52
Modern Excel Data Entry Work Form Tutorial
10:20
Просмотров 810 тыс.
Power Apps Model Driven Apps FULL COURSE for Beginners
3:23:34
Excel Formatting Tricks That Make You Look Like a Pro
12:15
У НАС ДОМА ЗАВЕЛАСЬ КРЫСА 🐀
01:00