Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

How to update correct SharePoint list item based on ID

(0) ShareShare
ReportReport
Posted on by 6

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 

nvpc1_0-1661112279775.png

Table 2 is updated from table 1

nvpc1_1-1661112302790.png

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.

 

nvpc1_2-1661112340243.png

 

 

nvpc1_3-1661112357870.png

 

 

nvpc1_4-1661112375408.pngHow 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

  • Pstork1 Profile Picture
    66,966 Most Valuable Professional on at
    Re: How to update correct SharePoint list item based on ID

    Please try posting your screenshots again.  None of them are showing.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492