web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Update a Row, Updating...
Power Automate
Answered

Update a Row, Updating the Wrong Row after Creating Item on SharePoint List

(0) ShareShare
ReportReport
Posted on by 15

Hello, Desperately seeking advice for this flow that I have been working on for the last couple of weeks. I finally have it updating the SharePoint list correctly and filtering correctly, however, when I go to have the Excel row updated after an item is created in the SharePoint list, it is updating the rows sequentially and not updating the row that was filtered and added to the SharePoint list. Am I missing something between Create Item and Update a Row? If so, please, somebody, anybody, help me figure out what it is I'm missing.

 

The flow starts with a manual trigger and lists the rows in my table.

Dir4Jobs Issues 0.jpg

I then have it filter for the jobs that have been 'awarded' based on the status column. I then have a control that says if it is awarded and listed as no for being imported (hoping this will avoid repeated items in the list getting created so that this list can be automated in the future) it is determined if the criteria is met, an item will be created in a SharePoint list.

Dir4Jobs Issues 1.jpg

Dir4Jobs Issues 2.jpg

The items are getting created on the list, as you can see, however in the screen grab below it, you will see that the List ID and Job Number do not match the rows that were updated with 'Yes, ID' in the Excel sheet. My goal is for 23052 (ID 1837) to be updated in the Excel as 'Yes, ID'.

 

Dir4Jobs Issues 3.jpg

 

 

Dir4Jobs Issues 4.jpg

 

Huge thank you in advance!!

Categories:
I have the same question (0)
  • Verified answer
    grantjenkins Profile Picture
    11,063 Moderator on at

    When using Update a row, the Key Column would need to contain unique values. If you use Imported as the Key Column and have the Value of No, then it will find the first row in your Excel Table that has the value No in the Imported column, and update that item.

     

    I would suggest using Master Job Number as the Key Column and adding the actual Master Job Number as the Value as this looks to be unique in your Excel Table.


    ----------------------------------------------------------------------
    If I've answered your question, please mark the post as Solved.
    If you like my response, please consider giving it a Thumbs Up.

  • cjp18 Profile Picture
    15 on at

    THANK YOU, THANK YOU, THANK YOU! This worked perfectly!! Thank you for the education on Update a Row and the solution.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard