So, I'm create a temporary file in sharepoint, to extract the rows and put them in a sharepoint list.
on new item in list
1. Grab the attachment from item
2. Save it to sharepoint
3. Get rows from Excel on the sharepoint file
4. Shove them in another list
5. Delete the temporary file
Issue is, I think the api calls to Excel Online lock the file (by me) but I've got no way to release that lock.
I've tried checking in the file, checking it out, nothing works, and I'm left with the temporary file being stored on there, until I go in and manually override the lock.
Is there a way to override/bypass a lock within powerautomate ?
An approach I saw was to put the delete in block in a while loop, wait 2 min, try, if fail try again, until it works, but that feels slow and kludgy.
The powerflow is the only instance of this file being used. It's where it's born, where it performs, and where it dies. Except it won't die 😞
