Power Platform Community Forum Thread Details

I have created a flow in power automate, it opens the excel document from the onedrive account through the excel(onedrive) package and do the update, add or whatever we make up. It works fine for two to three runs, then throwing the 401 error. Don't know why! Also, if i manually resubmit the flow, then its working fine again. For the reference, I attach the Snapshots here. Please check and do the needful and also feel free to ask for any additional info needed.

Screenshot_2024-12-31-23-04-33-36_40deb401b9ffe8e1df2f1cc5ba480b12.jpg

Categories:

Using flows

This could be occurring due to multiple reasons and I request you to try the following steps if these may help with a resolution to the problem

1. Re-authenticate the onedrive connection in Power Automate portal (Connections) tab

Go to Data > Connections in Power Automate.

Find the OneDrive for Business or Excel connection.

Re-authenticate by entering your credentials, and then test the flow to ensure it’s working properly

2. Try setting up a re-try policy on the flow

       Select the Excel action.
       Go to its Settings (ellipsis ... > Settings).
       Set retry to exponential interval (e.g., 3 retries at a 10-second interval PT1M (refers to a 1 minute time interval) like wise you can configure.

3. File locking

Minimize file edits to avoid unnecessary locking.

Alternatively, copy the file to a temporary location, update it, and move it back.