Power Platform Community Forum Thread Details

Hello everyone!

I need to do this in a power automate flow:

1. A Microsoft Forms response is submitted with an excel file attached.

2. This excel goes to a Sharepoint folder.

3. From this excel, that is a template with 1 table, 1 column and 50 rows to be filled by the responder, the values in that column have to be copied into a new column in a Sharepoint excel used as database (it has a empty table with same amount of rows)

How could it be done?

Thanks

Categories:

Building flows

Hi @MasterG98

For this i have created a demo flow. for this purposes, I have created excel files

1. File attached to form

2. Master excel file

form is like below

Flow is designed like below

1. use trigger when response is submitted & get response details

2. form attachments are saved in onedrive normally by default. So we need to get details of excel file from onedrive

use get tables to get list of tables present in form attachment

Expression -

first(json(outputs('Get_response_details')?['body/r9ba3d12c24464b029d2b7b481d7da9e0']))?['id']

Note- expression may change as the r9ba3d12c24464b029d2b7b481d7da9e0 value may change in your case.

Use list rows in table to get list of rows present in form attachment.

Expression - first(json(outputs('Get_response_details')?['body/r9ba3d12c24464b029d2b7b481d7da9e0']))?['id']

Expression -

first(outputs('Get_tables')?['body/value'])?['id']

Next loop through each row in form attachment and add the row to master excel file present in sharepoint

In add row to table, following things may change- column name- I have used column name as A in your case, it may change in your's case , so update accordingly.