Within "Delay" action, Unit field set to Minute, Count field set to a proper integer value. You could consider take a try to add a "Delay" action before your "Update row 7" action within "If/no" branch of Condition 2, the flow's configuration as below: "message": " Cannot write file to filesource. The error message would show up as below: "status": 423, When your second flow run is going to execute the "Update row" action and the "Update row" action of your first flow run is not completed, your second flow run would fail. I think this issue is related to the multiple requests.įor example, your first flow run which is trigger by your first request is executing the "Update row" action and is not completed, your second request is submitted. My only solution is to open as read only and save changes as a different file name. When I go back and try to open the file it says its 'locked for editing' by me, even though I obviously know I do not have the file open.
"source" : ".azur error message told that you have no access to write file to filesource which is being locked. Occasionally my computer has shutdown while Ive had an excel file open (power failure, etc). Check if Upload Center has locked this document. The exact text of the error is " "status" : 423 , Open the document in the Online app and rename the file from there. 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.
#Unlock excel file locked for editing online 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.