cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OrcaDeWils
Helper II
Helper II

File is created- not recognised by flow

Hi,

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? 

8 REPLIES 8
v-duann-msft
Community Support
Community Support

Hi @OrcaDeWils 

 

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.

 

Steps are:

 

"when file is created or modified"

"Send a HTTP Request to SharePoint"

Parse JSON

Check Condition

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

 

v-duann-msft_0-1616132048093.png

 

v-duann-msft_1-1616132048104.png

 

v-duann-msft_2-1616132048107.png

 

https://powerusers.microsoft.com/t5/Building-Flows/Invoke-a-trigger-on-check-in-of-document/td-p/960...

 

If you would like this feature to be added in Microsoft Flow, please go to this link and vote here:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/SharePoint-trigger-for-File-Checked-Out/idi...

 

Hope the content above may help you.

 

Thanks

Anna

Hi @v-duann-msft, thank you for this. I will give it a try in just a moment and will let you know about the result.

Anna, Does the condition mean that if checkouttype equal to 0 file is not or is checked out? 

@v-duann-msft I am getting error for serverRelativeUrl, parameter name is not supported for the serverRelativeUrl parameter 

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. 

Hi @OrcaDeWils 

 

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.

v-duann-msft_0-1616574117014.png

https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/sharepoint-connector-ac...

 

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

 

Best regards,

Anna

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? 

Hi @OrcaDeWils 

 

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.

v-duann-msft_0-1617266805460.png

 

Hope it helps.

 

Best regards,

Anna

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,214)