First I create a SharePoint file and an excel table:
Then I am checking to see if the items were already created, a false means that there's no new items to add rows. True would add the rows, then switch a column stating that the row has already been added to a file before.
While false, I now need to delete the SharePoint excel file that was created above cause it had no values to add. With that, I get the properties of the files in the entire folder, adding a condition looking for the ID from this property is equal to the itemID from the created file.
This runs properly and targets the file I want to delete. But then I get a 423 "locked" error. By going to SharePoint, I can see its still being "edited" by the flow when I try to delete the file manually. I have no clue why that is or where to go to fix this.
*And just for reference, even when it creates the new rows and the flow succeeds, the file is still staying open from the flow. And it will stay open even as days pass.

Report
All responses (
Answers (