Answered

Condition with an expression to convert text to lower case

(0) Share

Report

Posted on by sbncoco

I have a flow in power automate which is triggered by a form response, it collects the responses, and then runs through a condition to check if an answer to a specific question matches certain criteria before performing an action.

I'm trying to have the condition pull a response to the question "who is submitting this" and then if it contains for example Company A or Company B then it proceeds down the yes path. The issue I'm having is that it is case sensitive. To account for this im using an expression to convert the response to lower case. However when i try to use the following expression:

toLower(outputs('Get_response_details')?['body/who_is_submitting_this'])

it doesn't proceed down the yes path regardless of the answer. How can i modify this to continue down the yes path as long as it matches either "Company A" or "company a".

I have the same question (0)

All responses (3)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Re: Condition with an expression to convert text to lower case

Hi there,

Are you able to post screenshots of what you have so far?

Your approach, as described, should work...

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on at

Like (0)

Report
Re: Condition with an expression to convert text to lower case

Can you put your expression into a Compose and run the flow to check what it's returning? It may just have some leading/trailing spaces, or perhaps new line / carriage return, etc.
toLower(outputs('Get_response_details')?['body/who_is_submitting_this'])

I would suggest trimming the data before or after using the expression just to be sure.
//Either of these expressions would trim the data trim(toLower(outputs('Get_response_details')?['body/who_is_submitting_this'])) toLower(trim(outputs('Get_response_details')?['body/who_is_submitting_this']))

And in your condition, you would be checking against a lowercase comparison such as: "company a".

Was this reply helpful? Yes No
Verified answer

sbncoco 14 on at

Like (1)

Report

Re: Condition with an expression to convert text to lower case

Thank you both for your replies. This ended up being quite simple... My expression was correct, I just had it in the wrong side of the condition block.

Was this reply helpful? Yes No