You’re offline. This is a read only version of the page.
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.
Share
Report
All responses (
Answers (
462
