I am beginning to look into using Power Apps to automate a number of functions, at a top level, the user will complete a form, submit the form which will then populate a table in SQL, a stored procedure runs, before finally either a pass of fail message is sent to the user.
Currently, we have a number of Excel spreadsheets that are manually imported to SQL. If I understand correctly, I can combine those Excel spreadsheets to a single Excel document and for each type of request, set it up as a table within a sheet in Excel. Those tables then become my datasource for the Power App form. Assuming I am correct so far, is Power Apps able to dynamically change the form based upon the table selected? Is it possible even to have the form choose a table? Or, do I need to set it up in a way similar to a subform within MS Access? I have a table with all of my request types:
I create a form with the datasource as the "RequestType" table, the user, via dropdown on the form, picks one of those requests, then a secondary form populates with the fields required for that form?
Edit: OK, so watched a couple videos and I am not even sure that this is the best way to go around this. It seems that using Excel as the data source is for reading and writing to Excel. I simply want to use Excel to generate a form (the fields on that form determined by a selection), the user then completes the form, the data entered then does not go to Excel, but instead goes to an SQL table, the destination table also being determined by that first choice that generated the form fields.
Sorry for many questions, as I said, I am very much new to PowerApps and reading a lot of information.
I'll try to help with some of your questions:
Welcome, and hope that helps,
Thank you, would setting up my tables in SQL instead of Excel be a better option as well? Essentially the same thing, but the selection (and associated fields) come from my destination SQL tables instead.
Yes, SQL tables are a great choice for data sources.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.