You’re offline. This is a read only version of the page.
Announcements
7
Hi everyone,
I am trying to build a flow which will:
Trigger when a new Excel file is created in a sharepoint folder
List rows in the tables of the new file
List rows in a master table in a different Excel ďocument
Compare the key column ID
Copy row data from both tables into a 3rd table In the master document if key ID matches
This is for a training database and I want the "static" data such as name and department taken from the master document to prevent typo issues etc.
My main issue is how to reference the data in the future documents wich will be created from a template so all tables will have the same references.
I have seen different threads similar to this but none really answer my issue
Thank you
Hi @Owens ,
I'm not quite sure that I have understood the requirement of yours, but it's unnecessary to "List rows in a master table", all you need to do is list items in the table of the new file and for each item key ID to filter the master table, create new rows in this table with all values from the previous 2 tables.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Share
Report
All responses (
Answers (
