cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Copy the excel content to a single file when modified

Hello guys,

I'm building an automated flow that simply get the content of the Excel file when it's modified and copy it into a single file.

Basically I want it to be dynamic, so when Any file has been modified the content will be copied.

 

The issue is I'm failing when I list the rows from the modified file. I couldn't make it dynamic.

Hope someone could guide me through this issue. 

 

Note: All files have the same columns names.

 

 

Here is my flow that has issues:

File1.PNGFile2.PNG

 

 

5 REPLIES 5
Highlighted
Super User
Super User

Re: Copy the excel content to a single file when modified

HI @Malamri 

 

Unfortunately, the Excel connector doesn't allow for dynamic paths to files. It's unfortunate, but I created a template that can help with this matter. Just send it the path and the table, and it will return the Excel rows. It's a workaround until the dynamic paths are fully supported, but it works fine for this case.

 

You can find it here:

https://manueltgomes.com/microsoft/flow/template-archive/#jump_excel

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Helper III
Helper III

Re: Copy the excel content to a single file when modified

Mr. @manuelstgomes,

 

I really appreciate your reply, it's like a hope that there is a way!

 

However, I've never used the http request and respond. So I don't know how to start the flow and how exactly it works and should be used to export rows and import it in another excel file.

 

Highlighted
Helper III
Helper III

Re: Copy the excel content to a single file when modified

Highlighted
Super User
Super User

Re: Copy the excel content to a single file when modified

Hi @Malamri 

 

Looks good.

 

To call I have another tutorial 🙂

https://manueltgomes.com/microsoft/flow/using-flow-as-a-web-service/

 

Let me know if you need more help..

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Community Support
Community Support

Re: Copy the excel content to a single file when modified

Hi @Malamri ,

 

It seems that your problem has been solved. If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (10,654)