I have already created a successful Flow that automatically downloads XLS and XLSX attachments from a shared mailbox into a SharePoint folder. There's also an additional Flow to create a log of emails with attachments on a spreadsheet.
What I need now, is to create a Flow that when a spreadsheet is created into a SharePoint folder, it gets the rows (plural) from the named tables (2 tables) and copy/paste the data into one master table on a separate spreadsheet.
This is table number one from the source spreadsheet:
And this is table number two also from the same source spreadsheet:
And this is how I want it to look like on the master spreadsheet where the above data gets copy/pasted:
I've tried several ways, read a few posts with similar issues, but can't seem to make this one work. Any help would be grealty appreciated.
Thanks,
Jon
Bump - probably should add that I could probably find a way to merge the two tables into one on the source spreadsheet. I get the feeling that it can be done, but I may just be using the wrong triggers.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
26 | |
25 | |
13 | |
12 |
User | Count |
---|---|
58 | |
50 | |
30 | |
29 | |
26 |