"source" : ".azur error message told that you have no access to write file to filesource which is being locked. The exact text of the error is " "status" : 423 ,
Anyways, here are screenshots of the overall flow, and the error.
We have no need to have the spreadsheet open, since Flow should be doing all of the editing. I am aware that the error will often come up when a user has the spreadsheet open somewhere. It seems to happen when multiple requests are submitted within a few minutes of each other, and/or approval emails are responded to promptly, which would result in the excel row being modified quite quickly, after its initial creation. However, when attempting to write new data or modify existing data on the excel spreadsheet that we would use to track requests, the Flow will sometimes fail due to the errow below.
Excel file locked for editing but not open series#
The Flow uses a series of approval emails to roommates and administrative staff, to approve overnight guests. Recently, we've had some issues with one of our Flows that don't seem to stem from the logic. I work for an institution of Higher Education, and my team and I have been attempting to transition several of our business processes that are used with our residential population to Microsoft Flow.