using the replace and lower in the same Flow expression.

[Vstar19]

Hello,

I have the below formula which replaces a value of text.

replace(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02'],'olddomain','newdomain')

This works fine.

However, the issue is that I need the front of the email to be lower case. So if the user types in FIRSTNAME.LASTNAME@olddomain.com , the replace does not convert the front of the string to lower case.

Can someone suggest how I can use the tolower function in combination with the replace function to ensure all the text returned is lowercase?

Thanks.

[tom_riha · Accepted solution]

Hello @Vstar19 ,

just put the current expression inside toLower(..)

toLower(replace(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02'],'olddomain','newdomain'))

[Vstar19]

Hello. Thanks for your response. 

This works to an extent. I just tested it. 

THe problem I have now is that is a user enters there email as firstname.lastname@OLDDOMAIN.COM , the flow expression you gave is ignored, because it is looking for olddomain in lowercase.

Is there anyway we can specify in the flow to say if the olddomain is written as CAPS, then make it lowercase. 

OR is there a way to add multiple conditions to our query something like 

toLower(replace(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02'],'olddomain','newdomain', 'OLDDOMAIN,newdomain)) 

[Vstar19]

Essentially, what I am looking for is the ability to do something like this :

tolower(replace(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02'],'old','new')),
tolower(replace(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02'],'Old','new')),
tolower(replace(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02'],'OLD','new'))

So nowmatter how the user types in the old domain, it understands to always change it to lower

[tom_riha · Accepted solution]

Then a bit different order, make the whole response lowercase first, and then replace.

replace(toLower(body('Get_response_details')?['r82a060fd2a0d4f33abfca574c0159c02']),'olddomain','newdomain')