logic app : SharePoint trigger: filter only check in files on modification

Question

Hi

We are creating a logic app ,

The logic is , Whenever the file getting modified in sharePoint location (we enabled the Check out/ Check in option), we are moving the modified file to Physical location.

the issue is ,

the trigger is firing two times. once during the file "check out" , and then once during the file "check in".

how to filter only "Check-in" event?

Answer 1

@Anonymous

Thanks for reaching here! If understanding right, you have created a logic app using SharePoint connector and using trigger- When an item an file is modified.

And whenever modifying respective SharePoint doc the trigger is firing twice. Once during the file "check out", and then once during the file "check in" but you want to filter only "Check-in" event.

If so this is expected, you need to set trigger condition if you want to filter only for check-in.

So, you have two options for setting trigger conditions: using the logic app designer or manually through the code view.

For detailed information on trigger condition schemas, you can refer to the following link: Schema reference for trigger and action types - Azure Logic Apps | Microsoft Docs.

To set trigger conditions using the logic app designer, follow these steps:

1. Open your logic app.
2. Click on the three dots (...) located at the top right corner of the trigger.
3. Choose Settings from the options.
4. Scroll down to find the Trigger Conditions section.
5. Enter your desired conditional expression.
6. Click on Done to save your changes.

trigger conditions- @equals(triggerBody()?['{IsCheckedOut}'], false)

See below-

Please let us know if further query or issue remains.