cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LAlthekair
Regular Visitor

Merge added Excel files to main file using OneDrive

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_1-1659595110519.png

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

vyujincuimsft_2-1659595216099.png

3. Here is the Flow.

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

vyujincuimsft_7-1659596324287.png

vyujincuimsft_8-1659596359967.png

vyujincuimsft_5-1659595856171.png

vyujincuimsft_10-1659598446547.png

Result Screenshot:

vyujincuimsft_9-1659598383733.png

 

 

 

Best Regards,
Charlie Choi

View solution in original post

8 REPLIES 8
Gopala_Krishna
Solution Sage
Solution Sage

@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

 

Gopala_Krishna_0-1659273536394.png

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

Gopala_Krishna_1-1659273600326.png

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

Gopala_Krishna_3-1659273801986.png

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
Gopala_Krishna
Solution Sage
Solution Sage

@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

 

Gopala_Krishna_0-1659273536394.png

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

Gopala_Krishna_1-1659273600326.png

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

Gopala_Krishna_3-1659273801986.png

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

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?

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!

v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_1-1659595110519.png

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

vyujincuimsft_2-1659595216099.png

3. Here is the Flow.

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

vyujincuimsft_7-1659596324287.png

vyujincuimsft_8-1659596359967.png

vyujincuimsft_5-1659595856171.png

vyujincuimsft_10-1659598446547.png

Result Screenshot:

vyujincuimsft_9-1659598383733.png

 

 

 

Best Regards,
Charlie Choi

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!)

 

Screen Shot 2022-08-04 at 12.33.39 PM.png

v-yujincui-msft
Community Support
Community Support

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

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

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,679)