Unanswered

If(Equals forumla returning second option

(0) Share

Report

Posted on by Kiara93

Hello,

I am using Power Automate flow to to populate a word document but i am having an issue with my If(equals where is is always returning the second option, even when the value matches.

i am using :

if(equals(outputs('Get_CBHRF')?['body/kflynn_ihavethoughtabouttheimpactonmyothersuppo'],'823600000'),'Yes','No')

The value on the forms are (Choice Column)

Yes = 823600000

No = 823600001

can anyone see what i am doing wrong and why this is always returning no evern when marked yes?

Appreciate any help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Kiara93

Your expression is right. I did not see any issue in that,

Could you confirm whether the choice column looks like this ?

Also to confirm, use trim around the the variable to trim any whitespaces like below

if(equals(trim(outputs('Get_CBHRF')?['body/kflynn_ihavethoughtabouttheimpactonmyothersuppo']),'823600000'),'Yes','No')

Was this reply helpful? Yes No
Kiara93 61 on at

Like (0)

Report

Hi Nived,

i recieved an email saying you had commented and what was in the email was correct and solved my solution but i cant find that comment so i have attached. thank you for your help

Solved method.PNG

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Kiara93

Sorry This was the earlier solution which i posted, but i have edited it later as i thought it may not work

But when i experimented in my own system, form results were coming as string, so thought integer/number comparision may not work

This was the solution i have provided earlier
if(equals(trim(outputs('Get_CBHRF')?['body/kflynn_ihavethoughtabouttheimpactonmyothersuppo']),823600000),'Yes','No')

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Kiara93

Also could you share screenshot of form choice field, just to have a look ?

Was this reply helpful? Yes No