Power Platform Community Forum Thread Details

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:

Using flows

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.