I have a flow that is working but not updating the next available record. Let me explain; I have two tables; table1 is acting as a lookup table
Table 2 is updated from table 1
The logic:
Table1 - get items from table 1 (filter on importedID > 1000)
Table2 – update item in table 2 (filter on available = true). I want to update the next available record which is ID = 116, instead the flow is updating the ID that is equal to table 1.
How do I point to the next available record in table 2? the "ID" is returning the ID value from table1 i.e. 4100, 4150.. NOT ID value 116, 117.... from table 2
Please try posting your screenshots again. None of them are showing.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492