Unanswered

Help!

(1) Share

Report

Posted on by leeronileeroni

I currently have a flow set up using Power Automate which looks for incoming emails with a certain attachment and saves a copy of that file to my OneDrive for Business, this document is a Sales dashboard which is sent to me each morning, and has multiple worksheets within it, but they are not tables.

Now, I want to create a 2nd flow, or add to the existing one if possible, so that when I receive the email with the desired attachment and my first flow triggers, which saves a copy of that attachment to my OneDrive, I then want it to copy all the data from a worksheet within that excel file (reminder the data isn't in a table, I just want to copy the whole worksheet or all its data within it), and paste it into an existing Online Excel file that I already have.

Is this possible?

Thanks guys!

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

Sort by

abm abm 32,998 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @leeronileeroni

May I ask you that you need to all the worksheets data into another excel sheet? How many worksheets you have in your excel sheet? Is that worksheets have fixed names or it could be different names?

Thanks

Was this reply helpful? Yes No
leeronileeroni 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for getting back, so on the attachment the Excel file has several Worksheets for different time scales of sales data (e.g. Yesterday, This Week, This Month etc). but I only require the monthly data so not every worksheet, just the information from one of them.

So then once that data is copied into my other Excel document, this is a online live excel sheet which is displayed on screens around the store via Sway.

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @leeronileeroni

I will prepare a tutorial video for this soon.

Thanks

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @leeronileeroni

Apologies for the late reply. Mean time please have a look at my blog about how to create a table dynamically.

Power Automate – Excel – How to create Table and Read the Contents Dynamically? | @mydevexperience #Flownaut Super User III (@abm) (wordpress.com)

Will publish my video soon here.

Thanks

Was this reply helpful? Yes No
abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @leeronileeroni

Apologies for the late reply. Finally I have managed to find some time to create the video. If you like the video please click the like button and subscribe the channel.

Power Automate – Excel – How to create Table and Read the Contents Dynamically? - YouTube

Once you implemented the dynamic table creation and read the contents then extend the flow for inserting rows into your master excel sheet.

Thanks

Was this reply helpful? Yes No