Announcements
I am using two level filter as below. but i am facing issues with case sensitivity problem.
For Example: In my data present value as: "XYZ" and i search 'xyz' its show error because i search as small letter.
I am facing case sensitivity problem.
@Expiscornovus , Please help me
Hey there @Yallaling,
Case sensitivity cannot be turned off, as that's a fairly standard part of string comparisons. However, if you need to be able to handle any case, what you can do is use the toLower() or toUpper() functions in the Expression side of the Dynamic Content menu. If you are using a Filter Query like that, you'll have to make sure that all of the entries in the searched column in your Excel table are fully uppercase or fully lowercase, and then use those functions to alter the user input to match.
Hope that helps!
Thank you for using Microsoft Power Platform Communities!Bryn BakerSupport EngineerMicrosoft Power PlatformIf this post helps, then please consider accepting it as the solution to help other members find it more quickly! Have a great day!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Romain The Low-Code... 240 Super User 2026 Season 1
Valantis 226
Arild Aarnes 73 Super User 2026 Season 1
