Unanswered

Error saving flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Only changed one email address in the flow. Error message:

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'Conflict'. This may indicate invalid input parameters. Error response: { "status": 409, "message": "Graph API is unable to acquire or refresh a lock on the file because it is already locked. Please close edit sessions and try again.\r\nclientRequestId: 6500e7df-be17-4151-8f8a-45e01089fd87\r\nserviceRequestId: fd669b73-099f-489d-bda4-fe2fce271eee", "error": { "message": "Graph API is unable to acquire or refresh a lock on the file because it is already locked. Please close edit sessions and try again." }, "source": "excelonline-ae.azconn-ae-001.p.azurewebsites.net" }'.

Which file could this be referring to?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

KarlNixon 164 on at

Like (0)

Report
Copy link

Link copied!

ChatGPT response

This error message is indicating that the flow failed because it was unable to acquire a lock on an Excel file. This means that the file is currently open and being edited by another user. To resolve this issue, the user should close any open edit sessions on the Excel file and try the flow again.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you. I discarded checkout on the Excel file on Sharepoint online, and now have the below error:

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'Forbidden'. This may indicate invalid input parameters. Error response: { "status": 403, "message": "The request is forbidden by Graph API. Error code is 'EditModeWorkbookCheckedOutRequired'. Error message is 'In order to edit workbooks in this Folder they must first be checked out. To edit this workbook, check out the workbook in the Folder to the server (not to your local drafts folder) and then try to edit it in Excel again.'.\r\nclientRequestId: b06a7507-28bd-47d3-a28f-d27d6edf4ef4\r\nserviceRequestId: 747fef1d-6af5-40e9-b55a-fb6568a888f0", "error": { "message": "The request is forbidden by Graph API. Error code is 'EditModeWorkbookCheckedOutRequired'. Error message is 'In order to edit workbooks in this Folder they must first be checked out. To edit this workbook, check out the workbook in the Folder to the server (not to your local drafts folder) and then try to edit it in Excel again.'." }, "source": "excelonline-ae.azconn-ae-001.p.azurewebsites.net" }'.

Was this reply helpful? Yes No
KarlNixon 164 on at

Like (0)

Report
Copy link

Link copied!

This error message suggests that the Excel Online API is returning a "Forbidden" status code, with a specific error message of "EditModeWorkbookCheckedOutRequired". The message goes on to explain that in order to edit the workbook, it must first be checked out from the folder on the server, and then edited in Excel again. It appears that there is a problem with checking out the workbook from the folder on the server.

Was this reply helpful? Yes No
KarlNixon 164 on at

Like (0)

Report
Copy link

Link copied!

Can you also post a screenshot of the flow?

Was this reply helpful? Yes No