Hi,
Some important details
1. Is everything single change going to every single of the 500 Tables, thats a huge thing to know because it significantly changes how to answer you.
2. Are these updates and new items, do you need both to act the same way because if its just Adds, its different also, than both.
3. Is it 1 or more items being updated in the 500??? based on this one change?
Create a SharePoint a SharePoint list.
In the List, put a single column called OtherTables or whatever
Add all 500 of them
In the Flow
1. Add the When an Item is Created or Modified for SharePoint Action
2. Add a Get Items
-In the Get Items, to get the list of 500
3. Add an Apply to Each
Inside
-Use a Get Items
Now in this Get Items, use the Current Item dynamic property to set the Table,
Now are you going to filter here??? And figure out if this change should even go to this list??
So yeah get the item you want update via only returning 1 row or whatever you need too
If you are doing it to multiple rows then use an Apply to each and put the stuff below in that
Then
add an Update Item action and use the Current Item for the Tab and use the Item ID from the Get items 2 I have
Hopefully you filtered it to get 1 and also did top count to 1
Now, since its Dynamic, you have to fill in the item column which is really a JSON you create
to update the columns, as its now a Dynamic update item pointing to 500 lists
it won't populate the possible Columns, you have to do it all in the Item by building a json structure
And done.
This is how you would do it dynamically.
