A very simple flow that uses "
Excel Online (OneDrive)" connector to edit an excel file fails frequently but not always with message that "
You do not have permissions to open this file in the browser". Resubmitting the flow as is, without making any change in the flow or the file almost always succeeds. The flow is triggered by an incoming email using "Outlook.com" connector. It gets triggered so that part is fine but later actions involving the Excel Online fail. Actions are "Get a row", "Add a row" and "Update a row". The file is rather small, less than 0.5MB. The number of rows are less than 2500 in each of the tabs. The trigger frequency is also very low, usually 10-15 times a day, typically hours apart, sometimes several minutes apart i.e. not a case of throttling. The error message is always about "missing permissions" which isn't the case as the OneDrive, Excel File, Power Flow all run under my own account, plus the same flow works unattended for some of the time. The flow was written and published about 3 months back and it worked consistently for 2+ months. Then it started failing few times a day, slowly increasing the failure count to now when "most" of the time is fails and only handful occurrence are successful. Resubmitted failed flows run successfully. The full sample error message is
{
"statusCode": 401,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-request-id": "5ff7xxxx-xxxx-xxxx-xxxx-xxxxxxxx2917",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"x-ms-tenant-id": "f8cdxxxx-xxxx-xxxx-xxxx-xxxxxxxx255a",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Fri, 11 Oct 2024 15:48:47 GMT",
"Content-Length": "324",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 401,
"message": "You do not have permissions to open this file in the browser.\r\nclientRequestId: 5ff7xxxx-xxxx-xxxx-xxxx-xxxxxxxx2917",
"error": {
"message": "You do not have permissions to open this file in the browser."
},
"source": "excelonline-eus.azconn-eus-003.p.azurewebsites.net"
}
}
