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
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/#
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?
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)
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/
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 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
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/
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
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/
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?
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.
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
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/
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!
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.
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/#
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/
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/
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/#
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/
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
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/
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/
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/
This is clearer than any other video on the topic. Thank you!
You are more than welcome! Thanks 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!
This lady is a proper teacher,everything is super clear and well explained.
Thank you very much!
Using this in May 2024, so informative and clear! Thank you!
So glad it helped!
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.
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/#
finally a video that explains clearly, thanks a lot!
Glad it helped! You're welcome!
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.
Yup, it is the best video! without any confusion! thank you
So glad it was clear for you. Thanks for letting us know!
Thanks , Easy to understand as a beginner i learned my first app from you . 💃💃
That's great! Thanks for watching!
Thank you! You have completely demystified PowerApps for me! Game changer!
So glad we were able to help!
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!
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! 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.
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!
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.
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/
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 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/#
Amazing video! Props to you!
Thanks! Glad you liked it!
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 video....column head's name with space....new one I learned.....
Glad it was helpful and glad you learned something new!
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
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/
Hi it is a great video. But can we create a app shared with different users with unique data populated for each of them.
Yes you can! If you would like some specific help, we offer taht 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.
Thank you for the video. Nice work Ma shaa allah.
Always welcome!
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.
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/
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.
There should be a number format for you to select for that box instead of text.
Excellent video. Thank you.
You're welcome. Glad you liked it!
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.
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.
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/
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.
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.
Yes, you could do that if you would like.
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/#
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/
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/
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/#
Thanks!
Thanks for your support Anthony 🙏
Good one
Thank you! Cheers!
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/
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
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.
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/
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!
weird, I did everything step by step but it isnt working. its not pulling anything from my table.
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/
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?
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.
I'm unable to click on 'add field'. Please help!!!
Hi. do you have the whole version of Power Apps?
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!
awesome!
Thank you! Cheers!
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/
ı 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/#
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 for watching!
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!