Get a row function only working when workbook is open.

(0) Share

Report

Posted on by CU12091723-0

I have built a flow which starts from the completion of a form, the entries in the form are populated into an excel table (Pending Tab) automatically when the form is submitted. An approval request is then created and sent to an approver, if they approve the row is transferred to a new tab on the workbook called "Approved" and deleted from the "Pending" tab, if they reject the row is transferred to a new tab on the workbook called "Rejected", and again the row is deleted from the "Pending" tab, in both cases the requestor receives a notification of the decision.

The flow only appears to work when I have the workbook open, otherwise it fails saying the entry id cannot be found, is there a workaround for this? I put a delay in before the "Get a Row" action to allow for the sync but it only syncs when I'm in it.

Please help!

Categories:

Business Process Flows

Screenshot 2024-1...

I have the same question (0)

All responses (1)

Answers (0)

SaiRT14 1,988 Super User 2025 Season 2 on at

Like (0)

Report

Get a row function only working when workbook is open.

Hi CU12091723-0,

The issue arises because Excel files stored in cloud services like OneDrive or SharePoint Online often require that the file be open to reflect changes, particularly when Power Automate interacts with the file. This happens because the file syncs changes only when it is actively opened. Here's how you can address this

Add a Delay action before the "Get a Row" step to ensure that the file syncs properly.

Use the Get File Metadata action to ensure the file is accessible before proceeding Condition: File metadata contains "Sync" status.

Instead of directly deleting rows from the Pending tab, you can: Move approved/rejected rows to their respective tabs first. Add a condition to check if the row exists before deleting it.

pls try out.

Was this reply helpful? Yes No