How to convert query entity condition into to lower or to upper?

Help Data Service
,
1

Hi Team,

I have to match the email address from entity with email address coming from data table. i can convert the data table value in to lower or upper format however not able to find a way to convert entity value in to lower or upper.

is there any way to convert entity value condition ?could any one please help ?

Email address exist in entity record " DEEPAK.CHAWLA@GMAIL.COM"
Email Address exist in data table “deepak.chawla@gmail.com”

This image shows a "Filter builder" window from UiPath for querying entity records based on the "EmailAddress" field, containing a condition with a "CurrentRow" value from a specified column. (Captioned by AI)
This image shows a "Filter builder" window from UiPath for querying entity records based on the "EmailAddress" field, containing a condition with a "CurrentRow" value from a specified column. (Captioned by AI)645×444 8.05 KB

Thanks in Advance

Regards,
Deepak

2

Hi @deepakchawla

You can just add toupper or tolower

InputStr.ToUpper or InputStr.ToLower

Regards,
Gowtham K

3

@deepakchawla

I dont think you have that option now…you need to get the records and then filter…directly in filter ai dont think it would be possible to convert casing

Cheers

4

currentRow[“Primary RM …”].ToString().ToLower(); // Convert to lowercase
currentRow[“Primary RM …”].ToString().ToUpper(); // Convert to Uppercase

OR ignore case differences
loop the datatable
if (string.Equals(entity.EmailAddress, currentRow[“Primary RM …”].ToString(), StringComparison.OrdinalIgnoreCase))
{
// Emails match
}

5

i have to convert entity value in to lower or to upper