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".

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there,

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

Your approach, as described, should work...
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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".
Verified answer

sbncoco 14 on at

Like
a
(1)

Report
Copy link

Link copied!

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.