Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 255 Super User 2025 Season 2
Romain The Low-Code... 205 Super User 2025 Season 2
S-Venkadesh 101 Moderator
