Unanswered

Contains Filter Case Sensitivity

(1) Share

Report

Posted on by FIVESIGN

Dear community, I am stuck and need your expertise! I have a SharePoint list with suppliers. The title column is the name of the supplier and now I want my Flow to search the name based on an input from the user. But the contains filter is not working as I imagine.

If I filter directly in the SharePoint list, then it doesn't matter if I enter uppercase, lowercase only the second word in the name or only a part of the name, it lists me everything what my input contains.

In the flow it is like this:

Let's take the example name "Beautiful Day".

If I search for "Beautiful", there will be one match.

If I search for "beautiful" it finds nothing or "day" or only parts of it like "be". What I found out, is that there is some kind of case sensitivity. I've searched the net but couldn't find the right solution to my problem - so here I am, crying for help!

I wish the "contains" filtering worked exactly the same as it does in the SharePoint list .... what am I doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

MJain 2,450 on at

Like (3)

Report

Hi @FIVESIGN ,

In the flow where you are checking for Contains use toLower or toUpper on both sides

Thanks

Was this reply helpful? Yes No
Verified answer

fugixi 205 on at

Like (1)

Report
Adding some examples to @ManishJain reply.

If you are using expressions for the contains within your flow, then you could use something like below:
contains(toLower(body('Get_item')['Title']),toLower('TEXT TO FIND'))

If you are using the Condition action, you do the same with toLower(), but for each side of the condition.

_______________________________________________________________________________________________________________________
Did this post solve your problem? Please click Accept as Solution so that others may find it more quickly.
If you liked my response, please give it a Thumbs Up.
Do you want to hear more from me? Visit my blog Marble's Power Corner.

Was this reply helpful? Yes No
FIVESIGN 38 on at

Like (0)

Report

Awesome @fugixi! It worked! 👍

Was this reply helpful? Yes No
fugixi 205 on at

Like (0)

Report

Perfect!
Glad to hear it. 😊

Was this reply helpful? Yes No