Check if SharePoint document is checked in

(0) Share

Report

Posted on by jklevela

Hi,

I have an approval flow that a user may trigger from a doc.library.

Is it possible to only make that Flow menu item to start the approval flow visible when the selected item is checked in, and not visible otherwise?

Or/and..

How to check if a SP document is checked in in the Flow?

And how to check it in?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

HI jklevela,

I am sorry but I couldn't understant the first part of your question. For the second one, yes there is a way via HTTP cal to your sharepoint site collection to check if the document is checked out or not:

Make a simple get HTTP call to:
https://{base url}.sharepoint.com/sites/{site name}/_api/web/GetFolderByServerRelativePath(decodedurl='/sites/{site name}/{folder name}')/Files

Then will list you all the documents and if you don't know the id or you want to make it more dynamic, filter directly by name or for eah one, check which one your are interested.

The property "d:CheckOutType " eq to 0 indicates this is checked out. For more information (who, when?) extend your call (once you have the reference of the file) with:

Web/GetFileByServerRelativePath(decodedurl='decodedurl='/sites/{site name}/{folder name}')/{file name.extension}')/CheckedOutByUser

Hope it helps 🙂

Was this reply helpful? Yes No
Verified answer

v-bacao-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!
Hi @jklevela,

Currently there is no direct action in Flow to be able to check in the files in the SharePoint library.

Please vote for similar idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Allow-to-check-in-check-out-and-publish-files-in-a-SharePoint/idi-p/11256

Here are some users who seem to use Send http request to SharePoint action to implement the check-in file operation, you could use as a reference:

Please refer to the link below, which mentions how to check in the file in the SharePoint library:

https://support.office.com/en-us/article/check-out-check-in-or-discard-changes-to-files-in-a-library-7e2c12a9-a874-4393-9511-1378a700f6de

As to checking if the file has been checked in, you could try to use Send http request to SharePoint action to see if the file has been checked out.

Use the following Expression to get the CheckoutUserId. If it is empty, the file has been checked in. No one has checked out this file yet.

body('Send_an_HTTP_request_to_SharePoint')['d']['CheckoutUserId']

Image reference:

Please take a try.

Best Regards,

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

Like (0)

Report
Copy link

Link copied!

Use 'No' container in the case where you are checking if the document is checked in for the example below.
You could also use 'Yes' container if you change the Condition to validate that 'Checked Out' is false.
Check in and Check out function
Check if SharePoint document is checked in

Was this reply helpful? Yes No