Excel Update a row - really weird error message

[Apruzr]

I think this screenshot says it all.

The error message is "No row was found with Id 'Name'". But when I add a 'List rows in a table' action just before it, it shows there IS a row in the key column ("Field") with the value "Name".

Can anyone tell me what's wrong?No row found with Id 'Name'....but it's clearly there!

[v-litu-msft]

Hi @Apruzr,

Could you please share the screenshot of the Flow configuration?

You can have a try that update the Flow by inputting the value manually.

If you still couldn't get the value, please have a try that deletes the action then recreate it.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Apruzr · Accepted solution]

I figured it out. In the Design tab in Excel I had unchecked the box for row header - I didn’t want the row header on the table visible. I had to re-check the box and hide the sheet row instead and it works now.
It’s strange that the ‘list rows in a table’ action can see the table, but the updated a row’ action has problems when the row header is not visible.