Answered

Locked files during "Update file properties"

(0) Share

Report

Posted on by CJ-14031156-0

Each week, I want uptade the properties of one Sharepoint libery: Frst steps: "Recurrence", than "Get files (properties only)". After it I had my conditions for my update. My flow take excel tables value of each excel file and this should updated in the properties: See picture

Only the Uptade file properties did'nt work. There is all time a error of looked file.

The input of "update file prperties should be fine:

But the output has the error 400:

And all time the massage:

The file \"https://armacell.sharepoint.com/sites/R-and-D-Gateway/Innovation  PET/test file\" is locked for shared use by rudgateway.admin@armacell.com.\r\nclientRequestId: addd20fa-797d-4593-aa87-d0cdbf53fcb6\r\nserviceRequestId: 47fc96a1-60f7-c000-af1d-6b85b8406c9b"
 
 
I don't know why It's all time looked by the User. I allready test an other "User", I even test a short flow: g´Fet files properties only, for each and Update file properties. There I had the same message. 
I don't know how to solve this problem. Did you have an idea?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

MS.Ragavendar 7,160 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CJ-14031156-0,

Follow the below blog it worked for me .

https://www.matthewdevaney.com/4-solutions-for-excel-file-is-locked-error-in-power-automate/

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
Verified answer

Pstork1 69,456 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you trying to update the file properties of the Excel file that you are doing the list rows on? If so, then that is the problem. You need to do the list Rows and store your calculations in an array. Then after you close the file (outside the loop) you can update the file properties using the array as a source.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No