[Solved] File is in locked state SharePoint while working with power Automate

When you are working with File operation in SharePoint using Power Automate, you might get the FILE LOCK ERRORS. here I explained how to resolve.

The below error you may get while moving file, deleting file etc.

Resolution

The resolution for this is to implement loop to check if the lock on the file is removed. If removed do the step. In the below screenshot you can see the Move File step executed successfully on 59 iteration. All other iteration throws error as it was locked and after 6 minute the lock was removed automatically by SharePoint and our step run successfully. Watch the video below to learn more details on this.

STEP 1 – Use Trigger and Get records.

STEP 2 – Initialize variable and add Do Until loop

STEP 3 – Add move file step, Parse json and set variable conditionally.

Watch the full video how it is done here.

Hope this works.

Follow my blog for more trending topics on Dynamics 365, Azure, C#, Power Portals and Power Platform. For training, Courses and consulting, call to us at +91 832 886 5778 I am working more for community to share skills in Dynamics 365 and Power Platform. Please support me by subscribing my YouTube Channel. My YouTube Channel link is this : https://www.youtube.com/user/sppmaestro