I'm looking for ideas on how to solve an issue with my SharePoint document library.
In this library, users upload Excel files based on a specific template. The library has columns that correspond to rows in the Excel file. I need to extract information from cells C4 to C8 in the Excel file and use these values to populate the library's columns.
I attempted to create a Flow that triggers whenever a file is uploaded to the library. This Flow runs a script in the Excel file to retrieve the values from cells C4 to C8 and update the file properties in SharePoint. However, the "Update File Properties" action fails because it thinks the Excel file is locked when the script runs.
I've also tried using other Excel Online actions, but most of them require a table, and the way the cells are positioned, I can't make it a table. Additionally, I attempted to send a POST HTTP request, but I encountered an Unauthorized error.
This is typical with Excel files. Add a 10-minute delay to your flow before you update the item. I find 10 minutes is usually long enough for the lock to be released.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
