Answered

Filtering from sharepoint WITH case sensitivity

(0) Share

Report

Posted on by CarlosDParra

I need to filter a sharepoint list to display in a gallery, and for it i got many criteria, three of which involve using combo boxes. When choosing the items for the boxes, I usually use the function Distinct(dataOrigin.correspondingColumn) to display all the different options, and it shows all the different values, including the same strings but with different cases. In other words, distinct uses case sensitivity. But when selecting any of those options it shows all the other case sensitive variations, because filter is NOT case sensitive with sharepoint if I recall correctly. That's why I'd like to find a way of being able to filter using case sensitivity, since I have yet to find any solution to this problem.

P.S: It's my first time posting here, so please do tell me if there's guidelines for posting or recommendations for the future

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@CarlosDParra

Filter is case sensitive depending on what your criteria is.

For example:

Filter(yourList, someColumn = "Something") is case sensitive. It will ONLY return results with that case.

Filter(yourList, "Something" in someColumn) is case insensitive because the in operator ignores case.

Filter(yourList, "Something" exactin someColumn) is case sensitive!

So, not sure what your formula is or what the concern is over - if you can post more details on what you are doing and seeing that you feel is incorrect, perhaps some more light can be shown on the topic.

I hope this is helpful for you.

Was this reply helpful? Yes No
CarlosDParra 7 on at

Like
a
(0)

Report
Copy link

Link copied!

I see, what I'm doing right now is the second case you mention

something in ComboBoxItems

Still, I don't think I can use logic formulas for that since it's a list of items what I need Power Apps to filter by, so logic formulas would limit my purpose. But I have never heard of exactin, so I'll try it out.

It worked, it's exactly what I needed. So exactin is an operator for more precision than in I see. Thank you a lot!!!!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@CarlosDParra

No problem!

Not sure what you mean by "I don't think I can use logic formulas"

Was this reply helpful? Yes No
CarlosDParra 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh, I just meant things like = > < % etc, those statements are often used in programming for comparing values against other values, but since this time it's against a list I don't think those can be used except when comparing two lists.

Was this reply helpful? Yes No
CU28111532-0 on at

Like
a
(0)

Report
Copy link

Link copied!

I just need to chime in here.

Filtering and Lookup are always case INsensitive unless you use exactin (which in turn is not delegable).

Was this reply helpful? Yes No