Update rows in copied file, then send to email

[Anonymous]

Hi all,

I'm new to Power Automate and I'm working on a flow. 

A bit of context:
I made a model in Excel which is updated based on the response of a forms ID. 
This updated model is send to the email provided by the respondent. 

All files are located on sharepoint.

I got the following Flow working:
1. Get the responses from Forms
2. Update the rows
3. Create a copy of this file

4. Send the copy to the respondent

However, I want to change the order because updating the rows of the "original" file and then copying this might lead to problems when multiple people take the Forms 'survey simultaneously. 

What I desire is:
1. Get responses from Forms

2. Copy the file

3. Update rows in copied file

4. Send copy to responder.

I have tried multiple things but can't seem to get this flow working. I even tried looking at the code and adding the items in .JSON but this does not seem to be working.

Can someone please explain how to get this flow to work?

[rzaneti · Accepted solution]

Hi @Anonymous ,

You will need to identify the tables existing in your new file and populate it dynamically. 

Take this table as example: 

You first need to extract the file content and create a new file (I believe that your problem is not in this part of the flow):

Then include a 'Get tables' action to identify all of the existent tables in the Spreadsheet that you created. In 'File' input, set the 'Path' dynamic content from your 'Create file' action. 

If you have only one table in the file, just add an 'Add new record into a table' action and populate the 'File' with the 'Path' dynamic content from your 'Create file' action and the 'Table' with the 'Id' dynamic content from your 'Get tables' action. It will automatically generate an 'Apply to each', as the 'Get tables' returns an array (even if you have only one table in your file). 

As Power Automate does not know your table structure, you will need to provide an object into 'row' input containing the column names as keys and the data that you want to insert as values. For my example table, I have the columns 'id' and 'name', so I used this object: {"id": "1", "name": "test"}.

If you have any trouble to build this object, please share the column names from your table.

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/ 

[Anonymous]

Thanks, this fixed it!