Showing results for 
Search instead for 
Did you mean: 
New Member

2 year ongoing issue still not solved - Update File Properties from Excel Table _ Locked by user error

I've seen posts for this with no solutions, although I'm a fairly new user. My flow takes the newly created Excel file, and updates the library columns from the Excel table (1st pic). I planned on using that data to guide my approval flow, so I need it to upload instantly to be able to review and begin the next flow.

It retrieves the data from the newly added excel table perfectly (2nd pic), but when I try to use that data, it says "Locked by user (Me).com" (3rd pic). FYI, I do not have it open in any way.  When running the test, I can see the data in the body of 'Get Row' (5th pic), so I know it's there, however, I'm locked out by myself from using the data. If I apply a 7 min delay (seen from another user), it works (4th pic), but unfortunately defeats the entire purpose of the flow to save me time and errors. Also, I'm not sure it's even working 100% of the time.

Is there a way to directly pull the data from the JSON body, or any other solutions? It bewilders me that I can see the flow has obtained the data prior to returning the "Status 400"  error in the following step, I just can't access it.


Please please please!!! help

Library Data.JPG


Flow Error.JPGFlow Working.JPGBody - Table row data.JPG

New Member


Sorry, it kicked out my second picture... here it is

FLow Details.JPG

Helper I
Helper I

Here's a solution I call whenever I create a flow that does something with file metadata. 

In short: call the api and check if it is locked.


Convert the output to a string: string(outputs('Send_an_HTTP_request_to_SharePoint')?['body'])

Create a compose that returns True/False: contains(outputs('Convert_HTTP_Response_to_String'),'LockedByUser')
If the output contains "LockedByUser" then find the user by creating a new compose:


Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,054)