I have a form that users fill out in Power Apps. There are around 90 questions and I want to export those 90ish answers to an excel file that can be used by another group to run further analysis of the data. The process I am considering is below. I am asking the below process be critiqued to see if there is a better method.
1. Place all answers into a collection
2. Transfer that collection to Power Automate using the JSON function
3. Parse the JSON function in Power Automate
4. Use the Excel "Update a row" to modify the master excel document. ( I have multiple tables in my excel file needing updating so figure I will run the "Update a row" node multiple times.)
5. Copy the master excel file that is stored on sharepoint to the location where the excel file will be stored.
6. Use the Sharepoint "Get file metadata" node to get the metadata from the master excel file and feed it into Sharepoint "Get file content" node.
7. Use the Sharepoint "Create file" node and load the file content from step 6.
