I have a Flow that is triggered by the creation of an item in SharePoint. The Flow then uses the Excel "Update a Row" action to update an XLSX stored in OneDrive for Business. This usually works the first time I try, and maybe the second, but then I start getting 409, "Conflict" as if the previous run left the file open somehow. Even if I wait an hour it sometimes still has the error. Then, maybe if I wait three hours or so, everything works again, until I trigger another run. I cannot seam to figure out why the file is remaining open.
Any thoughts? Below you will find the detailed error output.
- Headers
{ "Pragma": "no-cache", "x-ms-request-id": "53abbe5f-cff2-4548-bfb4-43efd291dc3f", "Cache-Control": "no-cache", "Date": "Tue, 31 Jan 2017 23:48:06 GMT", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "123", "Content-Type": "application/json; charset=utf-8", "Expires": "-1" }
- Body
{ "status": 409, "message": "Cannot write file to filesource. Dataset:01KFWBLBBSWZWC27IFNVFJMGGEG3T7MKNA", "source": "127.0.0.1" }
