Convert true/false to yes/no

[StewG]

Hi,

I've had a look through here and tried some of the suggestions but am having no luck.

I have a Yes/No column in SharePoint that is used as a toggle in PowerApps.

I'm trying to convert the true/false value it gives in Flow to Yes/No to be displayed in a table in an email.

In the column I am testing I have put the expression (and variations of it)

if(equals(triggerbody()?['PersonnelNumberRequested?'], true),'Yes','No')

However this returns as No regardless if it is true or false. 

See image with expression and actual value below.

What am I missing? I keep going round in circles with this.

This is my whole Flow so far for reference:

[ekarim2020 · Accepted solution]

Hi @StewG ,

Looking at the screen shots, I think the expression needs to be:

if(equals(item()?['PersonnelNumberRequested'], true),'Yes', 'No')

The expression needs to reference the data from the Get items - for table action:

 
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[StewG]

Amazing thank you! It works! I knew it would be something obvious.

[tbrooks]

Thank you so much for this. I was having the same issue as StewG and could not figure it out.