Convert True and False to Yes or No in Power Automate

(0) Share

Report

Posted on by oscarf

Hello Power Automate Community,

Wondering what I'm i missing? Using the following Expression. So when i run the flow is only returning "No".

SharePoint list column Type: Yes/No

if(equals(triggerBody()?['Does_x0020_this_x0020_project_x00'],True),'Yes','No')

Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

trad 152 on at

Like (0)

Report
Look at the values coming out from SharePoint. Yes/No columns actually store the value as "Yes" and "No" not True/False. E.g.
"AddedtoLibrary": { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": 0, "Value": "Yes" }

Was this reply helpful? Yes No
oscarf 8 on at

Like (0)

Report

Hi @trad Thank you for the quick response. Just a little confused. What will be the correct Expression? Still learning Power Automate. My apologies.

Thank you.

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Hi @oscarf

Can you try updating the expression as:

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

and if that does not work, try:

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

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report
Also try
if(equals(toLower(triggerBody()?['Does_x0020_this_x0020_project_x00']),'true'),'Yes','No')

Was this reply helpful? Yes No
oscarf 8 on at

Like (0)

Report

Thank you so much @yashag2255 Still getting back the same results. Very strange.

I try both expression.

Was this reply helpful? Yes No
oscarf 8 on at

Like (0)

Report
Thank you @VictorIvanidze Also, try your expression and got the following error.
The execution of template action 'Create_CSV_table' failed. The column values could not be evaluated: 'The template language function 'toLower' expects its parameter to be a string.

Was this reply helpful? Yes No