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

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Update row: Row ID not found in excel when key value is present - Please help! 🙏

(0) ShareShare
ReportReport
Posted on by
I've been having problems with update row not being able to find row ID even though the value was present in the Excel file. 

I have two forms. The first form generates an application ID which is added to the table and is sent to the person entering the second form, which they enter into the form. This helps match up to separate forms with new information. 
 
On my automation I set up a dynamic key value that populates from the second form entry. But no matter what I try it can't find the row ID. I've tried debugging this with AI for about a year, and it still doesn't work. Even when I manually enter in the value rather than have a dynamic value it still won't find it. 
 
I've tried creating new tables in case the formatting was wrong, I've tried generating application codes that contain letter not just numbers, get row, delete row. Nothing works

Please help I am getting desperate.... But I just can't give up! It will save me so much time if I can get this to work. 
 
 
I have the same question (0)
  • Suggested answer
    chiaraalina Profile Picture
    443 on at
    Update row: Row ID not found in excel when key value is present - Please help! 🙏
     
    Your Update a row action is trying to change the key column while also using it to find the row:

     
    When the key column (ItemID) is included in the body, Excel Online (Business) can’t match the row and returns 404 – No row was found.
     
    In “Update a row” remove the ItemID field from the body entirely.
     
    Let me know if it worked!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 533 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 368 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 290 Most Valuable Professional

Last 30 days Overall leaderboard