cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ilu989
Level: Powered On

Checkout/Checkin use flow connector for over 20 document, but usually display error

Hi Everyone,

 

I encounter the issue that the Check out or Check out appear the error when Flow connector action, I already do the "discard check out" action to avoid any checkout's document, but still appear the error unaccountable, is there has other action I can run to avoid the strange issue when checkout/checkin action run?

Because I have over 20 Excel documents, I use "Apply to each" to checkout them respectively, also run "add a row into a table" and  "checkin connector" use "Apply to each", all documents have placed in SharePoint library and the setting of library is checkout requirement while it open, when my flow running, those document were not editing or open by another user!! 

And my flow design is before Excel "add a row into a table" run checkout action, and checkin it after Excel connector finished.

I was trying to way a long time(24hr) to see the system release the lock on the file, restart my PC as well, but no improvement.

The issue display:

{
"error": {
"code": "EditModeCannotAcquireLock",
"message": "{0} has the workbook locked. Ask them to close the file or check it in.",
"innerError": {
"request-id": "45c95ead-12ff-49a6-9ab2-53419b27f02e",
"date": "2019-10-18T00:15:30"
}
}
}

checkout2.JPG

 

{
"error": {
"code": "accessDenied",
"message": "The file is currently checked out or locked for editing by another user.",
"innerError": {
"request-id": "880c8488-bec9-4423-93be-e3205c2722c4",
"date": "2019-10-18T00:15:16"
}
}
}

 

checkout1JPG_LI.jpg

{
"error": {
"code": "resourceModified",
"message": "The resource being updated has changed since the caller last read it, usually an eTag mismatch.",
"innerError": {
"request-id": "30572cd1-ff6e-4394-9d54-4c3ccad8c35e",
"date": "2019-10-18T00:20:34"
}
}
}

checkin_LI (2).jpg

 

Regards,

ilu989

3 REPLIES 3
Dual Super User
Dual Super User

Re: Checkout/Checkin use flow connector for over 20 document, but usually display error

Do you have multiple Flows running against the same documents?  If you do then I expect the Cancel Checkouts are stepping on other Flows and that is why you are getting the errors.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
ilu989
Level: Powered On

Re: Checkout/Checkin use flow connector for over 20 document, but usually display error

Hi @Pstork1 ,

 

Thanks for your response.

I didn't run multiple Flows at the same documents, I just check out each document one by one, and those documents were in the same library, when one document checkout, run "add a row in a table" action, after that run checkin action, then checkout another document, so the checkout process is dependent and no overlap in the same time.

The issue is very weird! Is any solution can cancel all remain connect between user and document, before running the Flow.

 

Regards,

ilu989

Dual Super User
Dual Super User

Re: Checkout/Checkin use flow connector for over 20 document, but usually display error

If there is only one Flow and that Flow is only checking out one document at a time, then I'm not sure why you are having issues.  But at that point your only real solution is to turn off Require Checkout in the document library.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (9,955)