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.
User | Count |
---|---|
85 | |
71 | |
44 | |
26 | |
25 |
User | Count |
---|---|
42 | |
25 | |
23 | |
23 | |
17 |