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:
Request 1
Request 2
Request 3
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.
Thanks.
