In my sharepoint library where "require check out" is enabled, I set up a flow to update item properties when one is created. The flow doesn't trigger as the file is invisible as checked out to the user who added that file. Checking in the file doesn't trigger it neither. What might be the problem and how to solve it?
Thank you for posting.
According to your description, you would like to update item properties when file is created. But due to SPO internal feature ‘checkin/checkout’ enabled, the trigger is not able to detect the new file creation directly.
Actually, it’s normal behavior as flow can’t detect file checkout/checkin shatus by design. There aren't any triggers available for this. But we do have workaround for this to use ‘send an http request to sharepoint’ instead.
"when file is created or modified"
"Send a HTTP Request to SharePoint"
is status == checked in, then do something, else terminate
HTTP URI is :
If you would like this feature to be added in Microsoft Flow, please go to this link and vote here:
Hope the content above may help you.
I have managed to solve the problem, but is there a way this can be triggered only when file is created? I only need the file to be updated once when created.
Thank you very much for update.
Yes, we do have 'When a file is created in a folder' trigger which only applies to file creation.
Hope it helps.
Please click Accept as Solution if my post is helpful to you. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up
Hello @v-duann-msft ,
Thank you for help.
However it seem like the flow is not triggered anyway. Let's say someone left the file checked out after adding and checked it in after few hours. It doesn't work anymore? Could you please advise?
In that case, maybe we could add a delay action to wait for few hours and then continue to next action. Because we can't control user behavior.
Hope it helps.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.