Copy Dynamic Microsoft Excel Content from One File to Another using Power Automate

Step by step instructions on how to copy dynamic Microsoft Excel content from one file to another using Power Automate.

Things you'll need to follow along for this video:
Microsoft Business 365 account Business Basic

Visit the link below to see the instructions at my website:

Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos.

--------------------------------------------------------
CONNECT WITH ME:
___________________________________

[Steve-fsze]

This is amazing in its simplicity! Other instructional videos will have you running 2 scripts and importing them via Power Automate but this circumvents it and gave me a solution in 5 mins. Thankyou so much

[michaellange]

This couldn't have been more helpful - thank you!

[VijayRoy-gj]

what needs to be done if i have multiple worksheets in an excel file ??

[sofiaibarra]

Hi! Do you know if it's possible to select a range like from A2 to C6 in your example, and then paste it to the other workbook? Thanks for the video:)

[hempiden]

Hello my attachment is csv file, I get attachment content and save the csv file to sharepoint already but we get error at create table stage, what is your advise on that?

[leilamottacunha]

Hi! thanks for this video. Do you know how to copy data from a SharePoint library to an excel template, and save this template as a new document in another library?

[grantwylie]

Hello, I want to move more than one table from master excel file, to a new excel file, however get a 'cannot overlap tables' error. What am I doing wrong?

[nanduvadakkedath]

Hey do you know how can we copy a whole excel sheet content along with the formatting and paste it below the existing content of an excel sheet using PA?
I've been trying many ways. but could only do this without the formatting.

[brooketaylor]

For some reason the information is not spitting out into the final table. The flow is working, creating a table in step 1, however nothing is being copied into my "master" spreadsheet

[arahabigailbalgos]

Thanks for the video. Its very helpful. do you also happen to know what if i just want to update data in a row referencing from Excel 1 to Excel 2. Like if there are submissions with the same ID or unique row, it will trigger for it to update the existing row and not to just add data in a row? Hope you can read this! thanks again!

[KabayanParesan]

Hi, Just a question. Why is there no x-ms-file-id on my options? :( how can i find it?

[raversmash]

I have a spreadsheet that i want to extract data for each individual employee into a separate spreadsheet. Is that possible? The names of employees tend to change so i would need PA to be able to recognize new names and extract them into their own separate spreadsheet when it shows up. Is something like that possible?

[prudhvithoran]

That's Actually Very Great. But What if I have More Spread sheets in My excel File

[SofiaRoemplerDellien]

Hi, what can i do if the column names don't appear on the "Add row to table" function step?

[tarshmidha]

is there a way we can let Power Automate to determine the number of rows in a new file which is needed to create the table?

[shuchenlu]

I followed your video and created a very successful flow. However, why this flow is only able to copy the first 256 rows from one Excel to another. My file actually had over 10, 000 rows? Can you suggest why? Thank you!

[charisseaustria]

hello, great video. Sorry noob question, but i do not see the x-ms-file-id from the dynamic content, what should I do? or can I use full path instead? thanks so much in advanced!

[sewaerla]

I tried to build the flow nearly as same as yours (Change Onedrive in stead of Sharepoint). It allway crushes at "Create Table": Error Message:
BadRequest. Http request failed: the content was not a valid JSON. Error while parsing JSON: 'Bad JSON escape sequence: \U. Path 'message', line 1, position 73.'
Any Idea what caused this problem?