Fix Power Automate Error: No Row Was Found With ID Approve
Question details
The user needs to resolve an error in Power Automate where the 'Update a row' action fails to find a matching row in an Excel table.

- Product
- Power Automate & Excel
- Device & OS
- not provided
- Scenario
- Using a flow to update a specific row in an Excel table based on the outcome of an approval process.
- Observed behavior
- The flow fails with an error stating 'No row was found with Id Approve' because it attempts to use the approval outcome as the unique row identifier instead of an actual ID.
Ensure that the target data in your Excel workbook is formally formatted as a Table (Insert > Table) and contains a dedicated column for unique identifiers, such as a Submission ID or an email address.
Correct the Key Value Mapping in Power Automate
Map the 'Key Value' field to a unique identifier instead of the approval outcome to ensure Power Automate finds the correct row.
The 'Update a row' action requires a unique identifier to locate the exact row you want to change. If you map the approval outcome (like 'Approve' or 'Reject') to the Key Value field, the flow searches the Excel column for the word 'Approve'. Unless 'Approve' is the unique ID of that row, the flow will fail.
Navigate to your Power Automate account, open the failing flow in Edit mode, and expand the 'Update a row' action.
Check the 'Key Column' field to see which column in your Excel table is being targeted (e.g., 'TicketID' or 'EmployeeEmail').
In the 'Key Value' field, delete the dynamic content related to the approval outcome (e.g., 'Outcome' or 'Responses').
Replace it with the dynamic content that matches your Key Column, such as the unique ID generated when the item was first created or submitted.

Verify Excel Table Configuration
Confirm that the Excel file is correctly formatted as a Table and that the flow targets the right file and worksheet.
Manage Excel Tables Seamlessly with WPS Office
While troubleshooting automation workflows, ensuring your spreadsheets are perfectly formatted is critical. WPS Office is a free, lightweight suite that offers robust spreadsheet capabilities, making it incredibly easy to format tables, manage data, and prepare files for Power Automate workflows.
- 1. Install WPS Office: Download and install the free WPS Office suite on your device.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and open the .xlsx file used in your Power Automate flow.
- 3. Format as Table: Select your data range, go to the Insert tab, and choose Table to prepare it for automation.

Frequently Asked Questions
Why does the 'Update a row' action fail with 'No row was found'?
This error occurs when the value provided in the 'Key Value' field does not match any existing records in the selected 'Key Column' of your Excel table. Power Automate requires an exact match to identify which row to modify.
Can I use 'Approve' or 'Reject' as a Key Value?
You should generally avoid using approval outcomes as Key Values. This is only valid if your Excel table actually uses 'Approve' or 'Reject' as the unique identifier for a specific row, which is highly unlikely and bad practice for database management. Always use unique identifiers like ID numbers or email addresses.
Does my Excel data need to be formatted as a formal Table?
Yes. Power Automate's Excel Online connectors cannot interact with raw, unformatted data cells. You must select your data in Excel and format it as a Table (Insert > Table) so that Power Automate can recognize the headers and rows.




