web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : i5xhG/rVhJT9S69xkHAFM3
Power Automate - Building Flows
Answered

Do case insensitive ODATA filter for List Rows

Like (0) ShareShare
ReportReport
Posted on 5 Jan 2022 19:56:29 by 38

I'm using the Dataverse List Rows action and want to do a case insensitive compare of strings in the filter. If I have "The Company" in my table and want to compare it to the a value "THE COMPANY" how would I do that? 

 

If I do a regular comparison, it's false:

 

my_name eq 'THE COMPANY'

 

I could do a toLower or toUpper on the passed in value, but that doesn't do me any good since that still returns false as well. What I really need to do is something like this:

 

ToLower(my_name) eq ToLower('THE COMPANY')

 

but it doesn't look like that is possible. It seems like my only option is to do a bunch of string manipulation on the passed in value to put the string into various cases and see if any of those match, but this seems like such a hack. 

 

my_name eq 'the company' or my_name eq 'THE COMPANY' or my_name eq 'The Company'

 

Is there something better I can do?

 

Thanks.

  • kubalaml Profile Picture
    38 on 05 Jan 2022 at 23:43:54
    Re: Do case insensitive ODATA filter for List Rows

    Hmm yeah it looks like it is case insensitive. Not sure what I tested with earlier, but I guess I messed something up. Thanks!

  • Verified answer
    Pstork1 Profile Picture
    67,196 Most Valuable Professional on 05 Jan 2022 at 21:10:52
    Re: Do case insensitive ODATA filter for List Rows

    Is the target field a text field?  In my testing the OData query for the List Rows action is case insensitive.  I have a table with People data in it.  cr394_city eq 'Cleveland' and cr394_city eq 'cleveland' queries retrieve the same set of rows.

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.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete