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.
