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!