Hoping someone can assist with this one.
I've tried all kinds of things to no avail. Any ideas?
Hi @ericonline ,
Whether there is a column in Table A and Table B can establish a relationship. Preferably, the values of the two fields are equal and non-null have unique values. For example, a specified field in Table A can be used to filter out the specified rows in Table B.
If there is such a field, then you can use Filter Query to filter out whether there is a corresponding field in another table. If there is, you can choose to update or delete the corresponding row; if not, create a new row.
Hope it makes sense.
Whew! Finally figured a method out. I don't think it will scale beyond a few thousand records but...
Its pretty tough to explain. I'd like to attach a sample Flow that shows the process in action, but I don't see a way to attach a file here. I spent some time reviewing Set Theory to break things down to the basics (sometimes I make things too complicated!) before approaching this again.
In a nutshell:
- Create common keys that can be used to compare records in the database and the Sharepoint list
- Use intersection to find the records in common between the two tables
- Use union to get all records from the intersection and the database ("source of truth")
- Use two loops:
- For each "source of truth" record, if the sharepoint record is not present, append to "Add to Sharepoint" array
- For each sharepoint record, if the "source of truth" is not present, append to "Remove from Sharepoint" array
- From there, it'll be up to you to determine how to create and delete records in the sharepoint list.
Hope to hear from some of you on how you would/could handle this as well.
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!