Unanswered

Flow with a checking condition a yes/no value which always returns no

(0) Share

Report

Posted on by Preeti12345

Hii Members,

I have a SharePoint List named Access Registers. This list has some Yes/No fields. I would like to display all these yes/no field values in the Power Automate Email Alert.

In the Flow, in the Send an Email action, I have used the below formula to retrieve the Yes/No field value from the SharePoint List as:

if(equals(triggerBody()?['FeverOrChills'],true),'Yes','No')

Where, FeverOrChills = SharePoint Column Internal Name

But usually what happens is, the above formula always returns me as No value even if the SharePoint Yes/No field is having a Yes value. Below represents a screenshot for your reference:

Flow Yes to No.png

Can please anyone suggest or help me with this?

Thanks in Advance!

Categories:

General topics

All responses (7)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Preeti12345 Please use True not true.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Preeti12345 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hardesh15,
Thanks for your reply. Also, I tried by using True instead of true, it is showing me the same No value only.
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Preeti12345 do one thing. Add one compose action and pass your FeverOrChiles column value. Are you passing column value or just column name?

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Preeti12345 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hardesh15
I have added one Compose action and applied the below formula on its Inputs field as:
if(equals(triggerBody()?['WearingAppropriatePPE'],True),'Yes','No')

And next, I have applied this Compose Output in my Alert Email as shown below:

But still, it is showing me No even if the value is Yes in the SharePoint list. Please any more suggestions on this?
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Preeti12345 please do not put if condition expression in compose. I said just pass column name value and then check.

i think you need to pass this @{triggerBody()?['WearingAppropriatePPE']}

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
Preeti12345 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hardesh15 ,
When I passed this column value @{triggerBody()?['WearingAppropriatePPE']} in the Compose action, it is showing me the invalid expression error. Can you please suggest to me the appropriate formula?
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Preeti12345 Can you please pass this WearingAppropriatePPE column from dynamic content menu in compose action.?

its a very basic step.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in