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:
Solved! Go to 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.
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.
Amazing thank you! It works! I knew it would be something obvious.
Thank you so much for this. I was having the same issue as StewG and could not figure it out.
User | Count |
---|---|
94 | |
39 | |
24 | |
22 | |
16 |
User | Count |
---|---|
128 | |
49 | |
48 | |
32 | |
24 |