cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ichinova
New Member

Do case insensitive ODATA filter for List Rows

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

Ichinova
New Member

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

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,185)