1. When a form is submitted
2. Get Response Details (changed from ID)
Create Array of Responses
2b. Copy the Template file you created, into a new location using Get File Content + Create File or the Copy Action to do it all at once
to either SharePoint or OneDrive
3. If you have a Column that allows them to Select menu, then you don't need to Create an Array its already an Array
--So instead
3a. Apply to Each
-Adding your MultiChoice option as the From
Inside the apply to each
Scenario 1: The Names for sure match Tables
3b. Add a list Rows in a Table
3c. Put a condition
Left side, put length('Your List Rows in a Table Name Action')
in the middle put is greater than
right side 0
in the YES side of the condition
put an Apply to each
Loop through the records
3c. Do an Add or Update, based on the KEY you have created for all tables (again I am assuming you create a nice "template" first,
or yes you have to do what you said, which is create a Table in Excel first
3d. If you have to create a Table, then use the Add a Row to a Table (not an update since you just created the table it wouldn't have rows)
AND DONE Scenario 1
The only reason the Table wouldn't match an existing table is if you plan on building all of these dynamically, totally do able, but then you would
3b. Create Table
3c. List rows in a Table
3d. Put a condition
Left side, put length('Your List Rows in a Table Name Action')
in the middle put is greater than
right side 0
in the YES side of the condition
put an Apply to each
Loop through the records
3e. Do an Add or Update, based on the KEY you have created for all tables (again I am assuming you create a nice "template" first,
or yes you have to do what you said, which is create a Table in Excel first
AND DONE scenario 2
