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
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)
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?
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.
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/
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/
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, 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
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
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.
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/
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/#
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/
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/
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, 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/#
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
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/