Power Platform Community Forum Thread Details

I don't know if I'm posting it correctly but I found solution where I didn't find anywhere, so hopefully it will help someone.

Issue: In Power Automate Excel connector is very slow when adding a row or updating etc. Next action after add a row that should work with added row through Get a row did not work and always gave me an error 404 - The row was not found.

Solution:

Add the Excel action that updates the table (for example, "Add a row into a table" or "Update a row").
Add a "Do until" action with setting condition from within the Scope action you will set later in step 4.
Inside the "Do until" action, add a "Scope" action. The "Scope" action will contain the "Get a row" action and help manage error handling.
Inside the "Scope" action, add a "Get a row" Excel action. Configure this action to access the table and row you're working with. Set the "Key column" to the "xx" column and the "Key value" to the value you want to find.
Outside the "Scope" action (but still inside the "Do until" action), add a "Delay" action and set the duration to wait before retrying the "Get a row" action, such as 10 seconds.
Click on the ellipsis (...) in the top-right corner of the "Delay" action, and then select "Configure run after" from the dropdown menu.
In the "Configure run after" panel, uncheck the "is successful" option for the "Scope" action and check the "has failed" option. This will ensure the "Delay" action only runs if the "Scope" action encounters an error.
Configure the "Do until" action's settings to specify a maximum count of loop iterations or a timeout duration to prevent an infinite loop.
After the "Do until" action, add the next action that you want to execute after the table is updated and the value is found in the "xx" column.

Using this approach, the "Get a row" action is enclosed within a "Scope" action, which allows the flow to handle errors without stopping. If the "Get a row" action encounters an error, the "Delay" action will run and then the "Get a row" action will be retried. This process will continue until the value is found in the "xx" column or the "Do until" action's maximum count or duration is reached.