Search using Odata in flow

[AX-Imran]

I want to know what is the operator for contains in odata query..
 
Invalid options specified in OData query. or operator expected at position 88 in 'State eq 'Active' and (OwningServiceId eq xxxxxx or OwningServiceId eq xxxxx) and (Title contains 'Mitigated by Self-Heal Action')'.
 
My flow is failing with invalid options. Looks like it does not like the word contains.. I am trying to search by the words.. eq works fine but I a need contains as I am looking for keywords in my search.
 
Any one know what is the operator for contains.

[sergeluca]

the operator is 'substringof'

so the expression should be ........ substringof('Mitigated by Self-Heal Action',Title)

Kind regards

Serge Luca

[v-yuazh-msft]

Hi @AX-Imran,

Have your issue be solved? 

As @sergeluca said, you could take a try to fill in the "Filter Array" column use expression below to achieve your needs:

substringof('Mitigated by Self-Heal Action',Title)

I have made a test on my side and have created a flow as below:

The flow would run successfully to filter out the items which's title contains "Mitigated by Self-Heal Action" as screenshot below:

Regards,
Alice Zhang

[anhthuch4ng]

Great suggestion @sergeluca!

Hi @AX-Imran,

Have you had a chance to apply @sergeluca and @v-yuazh-msft's suggestions to your Flow above?

If yes and you found that solution to be satisfactory, please go ahead and mark the relevant replies as the "Accepted Solution". 🙂


Happy Flowing,
-AT (Flow Community Admin)

[Hugsville1e6]

Hi,

That doesn't work - I get this when attempting to use substringof:

{

status: 400,

message: The function operator 'substringof' is not supported or its usage is invalid

}

[sergeluca · Accepted solution]

I've just retested it ad it works as a charm, here is my code

Would you mind sharing your code ?

Cheers

Serge Luca aka 'Doctor Flow'

[Hugsville1e6]

Hi,

If the data you want to find is in a variable that will not work when applied to substringof - only an explicit search string entered will work. Try this.

Assign Toky to a variable called say strSearchString

Use that variable instead of Toky thus:

substringof(variables('strSearchString'),Title)

Whilst it will save the attempt to run that will fail with badrequest

Cheers

G

[Hugsville1e6 · Accepted solution]

Hi,

After a bit of scrabbling, found out whats going on.

To construct substringof the variable must be entered from the dynamic pane, rather than typed as an expression and the variable selected be surrounded by quote characters thus: