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.
Hmm yeah it looks like it is case insensitive. Not sure what I tested with earlier, but I guess I messed something up. Thanks!
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.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2