Create an excel worbook and copy rows into table- question about triggers

(2) Share

Report

Posted on by rutledgeam

I have been following these steps to copy data from one spreadsheet into another spreadsheet.

https://community.powerplatform.com/forums/thread/details/?threadid=1a011bc6-7a4f-ef11-a317-6045bdec9b0a

The automation I am trying to create is when someone uploads a file into a specific Share point folder two things happen: a new workbook is created with a table using a template, and then the data is copied from the uploaded file to the new workbook.

I can get both actions to happen separately but I can't figure out how to connect them. Right now both are triggered manually in two separate automations, but I want the whole action to complete automatically.

I tried to run the copy data steps in the post above after creating a new workbook but it was unable to find the uploaded file.

I have been staring at this thing for days and I am stuck! Suggestions on how to make this happen?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

AnthonyAmador 2,553 Moderator on at

Like (0)

Report

Hi,

You need to extract the information from the uploaded file and then paste it into a new workbook. For that, you need to use the Excel actions.

To extract the information, you have to use the “List rows present in a table” action. However, you need to know the name of the table inside the Excel file. So first, you have to use the “Get tables” action to get the name of the table you want to extract the information from. If the name of the table will always be the same, you can skip this step.

Then, in the “File” input for “List rows present in a table,” you have to use the dynamic content from the trigger, which I suppose will be “When a file is created,” to select the correct file.

Can you elaborate on where exactly you are having issues?

Best,
Anthony

Was this reply helpful? Yes No
rutledgeam 28 on at

Like (0)

Report

So I am probably doing this all wrong (especially since it is failing) but this is what I currently have set up.

So the input is the uploaded file and then having the data copied into a new excel workbook that is created using a template. I keep running into issues with the file ID- that the file can not be found due to a 404 status code.

The file being uploaded will have the same workbook and sheet name.

I tried to do the same automation in one flow- but ran into the same issues.

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report

Can you share more detail about what the uploaded file looks like and what the template looks like? Is it structured tabular data?

Was this reply helpful? Yes No
rutledgeam 28 on at

Like (0)

Report

They are both excel spreadsheets.

The uploaded file is 16 columns and the amount of rows will vary. It is basically an exported file that needs to be customized. The data is not in a table- so it needs to be created.

The template is an excel file with an image and then a table. The column headers are already done so I just need to move the rows after the header from the uploaded file.

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on at

Like (0)

Report

@rutledgeam you need to redesign your flow. Why do you have two branches?

Check this video, may can help you https://www.youtube.com/watch?v=un0Po1jxfn4

Anthony.

Was this reply helpful? Yes No