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.
Solved! Go to 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'
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:
the operator is 'substringof'
so the expression should be ........ substringof('Mitigated by Self-Heal Action',Title)
Kind regards
Serge Luca
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
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)
Hi,
That doesn't work - I get this when attempting to use substringof:
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'
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
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:
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
16 | |
14 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
18 | |
10 | |
8 | |
7 |