When new item is created in SharePoint (spreadsheet) copy tables contents into a master spreadsheet

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (1)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: When new item is created in SharePoint (spreadsheet) copy tables contents into a master spreadsh

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.

Was this reply helpful? Yes No