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.
4
Share
Report
All responses (
Answers (
