Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Stuck with Contain fun...
Power Automate - Building Flows
Answered

Stuck with Contain function in Filter Query

(0) ShareShare
ReportReport
Posted on by AmeerKhan 15

I have a flow that's working as intended however I want to add an extra filter to the Filter Query. I've tried to create a 'collection' so it can identify which CV's in various sub folders are current and which are superseded. I made an additional column in my SharePoint for users to class as CV or SS. 

 

As seen below:

 

AmeerKhan_1-1643118335126.png

 

My filter query for Modified le works fine however the 'and contains(collection, value)' I'm struggling to get working. I made that Status column thinking it would act as a collection and I can read the value 'CV'.

AmeerKhan_0-1643118159811.png

 

However I get the error message return "Column 'False' does not exist."

 

Any ideas?

 

EDIT: I can also try and get people to rename their files so their current one contains 'CV' and others should be called 'SS' however I also couldn't use 'Name' as a collection!

  • AmeerKhan Profile Picture
    AmeerKhan 15 on at
    Re: Stuck with Contain function in Filter Query

    That's great, also worked. I tweaked it to CheckoutUser ne null but does exactly what I need. Thank you very much!

  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 32,131 Most Valuable Professional on at
    Re: Stuck with Contain function in Filter Query

    Hi @AmeerKhan,

     

    Curly braces/brackets and the OData filter query. I am not really sure if that works pretty well together.


    Instead you could try and check for another field instead, the CheckoutUser.

     

    Try this filter:

     

    Modified le '@{addDays(utcNow('yyyy-MM-dd'),1)}' and CheckoutUser eq null

     

  • AmeerKhan Profile Picture
    AmeerKhan 15 on at
    Re: Stuck with Contain function in Filter Query

    Hi @Expiscornovus that works perfectly! I'm thinking as a tweak however, to make it more streamlined. I can get users to just Check Out the file and I can somehow filter by that. I can see in my Output data there's a criteria that reads:

    {IsCheckedOut}": false,

     

    I tried to use substringof('false',IsCheckedOut) but no luck. Is this because the Check Out status isn't a column which is what the error being returned is also saying? Is there an alternative expression I can use to just check 'IsCheckedOut' true/false?

     

  • Expiscornovus Profile Picture
    Expiscornovus 32,131 Most Valuable Professional on at
    Re: Stuck with Contain function in Filter Query

    Hi @AmeerKhan,

     

    Can you try substringof in the OData filter query?

    substringof('CV',Status)

     

    substringof_getfilespropertiesonly.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans