Answered

Merge added Excel files to main file using OneDrive

(0) Share

Report

Posted on by LAlthekair

Hello!

I am looking to create a flow to merge files that users upload to a certain OneDrive file into a Master File that I, as an admin, will create and manage. I have a general idea of what I want the flow to look like but because I'm a beginner I'm struggling to actually implement it. Steps:

1. When a file is uploaded to the OneDrive for Business folder

2. Check that it's a .xlsx file

3. Get the rows of the table in the file

4. Add the retrieved rows to the Master sheet and save

5. Delete the uploaded file

The columns for both tables are exactly the same. If anyone could provide screenshots that would be appreciated!
Many many many thanks!!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Gopala_Krishna 1,495 on at

Like (0)

Report

@LAlthekair

You can follow the below shared steps, which will give you an overview on how your flow should look like.

First we will have a trigger action called "When a file is created" this will help in identifying when a file gets created in a specified folder

After this we will add a condition which helps in identifying whether the file is a xlsx file or not

If this is true, then a specific set actions will run which will extract the data from the file, add those to master list and delete the file from the folder

There are few actions that are highlighted in the flow, these are outputs of the OneDrive action that we have added as a trigger, We also have a field called table in List Rows present in a table action here you have to manually enter the table name

The Add a row into a table will help in adding the data to the master list, here you can select the outputs coming from the List Rows present in a table action

If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

Please follow my website PowerCards for more information related to Power Platform

Was this reply helpful? Yes No
Gopala_Krishna 1,495 on at

Like (1)

Report

@LAlthekair

You can follow the below shared steps, which will give you an overview on how your flow should look like.

First we will have a trigger action called "When a file is created" this will help in identifying when a file gets created in a specified folder

After this we will add a condition which helps in identifying whether the file is a xlsx file or not

If this is true, then a specific set actions will run which will extract the data from the file, add those to master list and delete the file from the folder

There are few actions that are highlighted in the flow, these are outputs of the One Drive action that we have added as a trigger, We also have a field called table in List Rows present in a table action here you have to manually enter the table name

The Add a row into a table will help in adding the data to the master list, here you can select the outputs coming from the List Rows present in a table action

If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

Please follow my website PowerCards for more information related to Power Platform

Was this reply helpful? Yes No
LAlthekair 23 on at

Like (0)

Report

First of all, thank you very much!

However, the flow is running (I know that because the file is being deleted in the end.) However, the rows are not added in the Master file. What am I doing wrong? I filled in my fields exactly like you did, replacing the crossed out blanks with my file and table name. Also, what am I supposed to put in the DateTime Format box?

Was this reply helpful? Yes No
LAlthekair 23 on at

Like (0)

Report

I've been reading and trying to work alongside this post seeing as they have a similar question but ... for some reason, I am not getting any dynamic content from the "List rows present in table" action. Help!

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @LAlthekair ,

Not getting any dynamic content from the 'List rows present in table' Action is expected behavior.

You could add an 'Apply to each' Action and use the expression to get the value from the table.

1. Here is the main file stored in OneDrive.

2. Here is the excel file that will be uploaded to OneDrive.

3. Here is the Flow.

items('Apply_to_each')?['ColumnName']

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
LAlthekair 23 on at

Like (0)

Report

Thank you very very very much!! Do you want a cake? Do you want a hug? Whatever it is, you got it. It works!

(Only one issue; after the flow runs, the file becomes locked for some reason and won't delete; I attached a screenshot of the error below. I ran the flow twice and it still runs into an error at the last step. If you can help me fix it I'll be grateful!)

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (1)

Report

Hi @LAlthekair ,

It‘s a common problem, maybe you could try setting a longer time in the Delay Action, then try it again.

In addition, here is a link for your reference.

An action failed. No dependent actions succeeded. - Power Platform Community (microsoft.com)

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
LAlthekair 23 on at

Like (0)

Report

Ah, I see. Makes perfect sense. Thank you once again! I really appreciate it!

Was this reply helpful? Yes No