Answered

Stuck with Contain function in Filter Query

(0) Share

Report

Posted on by AmeerKhan

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:

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'.

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!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @AmeerKhan,

Can you try substringof in the OData filter query?

substringof('CV',Status)

Was this reply helpful? Yes No
AmeerKhan 15 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,871 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
AmeerKhan 15 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No