Good morning,
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.
Recently, we've had some issues with one of our Flows that don't seem to stem from the logic. The Flow uses a series of approval emails to roommates and administrative staff, to approve overnight guests. 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. 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. I am aware that the error will often come up when a user has the spreadsheet open somewhere. That is not the case in this instance. We have no need to have the spreadsheet open, since Flow should be doing all of the editing. Anyways, here are screenshots of the overall flow, and the error. The exact text of the error is ""status": 423,
"message": "Cannot write file to filesource. File is being locked.\r\nclientRequestId: 8d4f41ba-4cf2-4137-86bf-5daf085a39bc",
"source": "excelconnectionprovider-westus.tip0-westus.p.azurewebsites.net"
