Answered

Invoke a trigger on check-in of document

(2) Share

Report

Posted on by BhanuChintha2

Hello Team,

Can you please let me know if there is any option to trigger a flow when a document is checked-in/checked-out/published/minor versio checked-in.

Thanks in advance.

Thanks & Regards,

Bhanu

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

vecerpa 786 on at

Like (0)

Report

I'm also interested for answer to this as from description about this trigger there is bigger detail what modified exactly means. But I'm pretty sure that the level you are asking @BhanuChintha2 will not be reached for checking of item.
P.

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

Like (0)

Report

Currently, there aren't any triggers available for this. If you want these as a trigger, make sure to add this to the ideas forum!

Was this reply helpful? Yes No
v-yuazh-msft on at

Like (0)

Report

Hi @ BhanuChintha2,

To trigger a flow when a document is “checked-in/checked-out/published/minor versio checked-in” in sharepoint document library is not supported in Microsoft flow currently.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,
Alice Zhang

Was this reply helpful? Yes No
deolgoria 11 on at

Like (0)

Report

@BhanuChintha2 I need this same functionality. Two weeks ago I created an idea for the Flow team here: https://powerusers.microsoft.com/t5/Flow-Ideas/Expose-SharePoint-Library-quot-Checked-Out-To-quot-column/idi-p/92908

At this point I'm going to have to use an old-style SharePoint workflow until this is implemented.

Was this reply helpful? Yes No
Verified answer

Steven12345 28 on at

Like (5)

Report

I managed to achieve this function. Although the process is a bit convoluted. It does work.

Steps are
1. "when file is created or modified"
2. "Send a HTTP Request to SharePoint"
3. Parse JSON
4. Check Condition
5. is status == checked in, then do something, else terminate

HTTP URI is:
_api/web/getFileByServerRelativeUrl('/sites/TestFileShare/@{body('Get_file_properties')['{Path}']}@{body('Get_file_properties')['{FilenameWithExtension}']}')/checkOutType

Was this reply helpful? Yes No
deolgoria 11 on at

Like (0)

Report

Thanks for this.

Was this reply helpful? Yes No
Steven12345 28 on at

Like (1)

Report

As a follow up - one problem I ran into was if I updated the file properties I ran into the recursion issue whereby the modified file trigger was called again so I was stuck in an infinite loop. I have resolved this by checking the approved status of my file. If the file was approved there was nothing for me to do. 1 is approved, so just terminate the flow. One could also check the checkout status or some other variable.

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

Like (3)

Report

Thanks for the clue...and if you want to get the Approval status (by leveraging the out-of-the box SharePoint content approval feature).. here's how I did it:

Was this reply helpful? Yes No
Joe3 44 on at

Like (0)

Report

you're amazing dude

Was this reply helpful? Yes No
spot28 15 on at

Like (2)

Report

Simpler Method. In the file properties is a property 'Checked Out'
I get this from the dynamic content and before performing the desired action, check if 'Checked Out' equals false. If it is then perform the action, otherwise cancel.o

Was this reply helpful? Yes No