Fetch Yes/No from checkbox field instead of true/false

Like (0) Share

Report

Posted on 15 Mar 2022 03:40:04 by Kavish vaidya Microsoft Employee

Hello folks,

I am currently stuck in some minute issue and i know the long way out but was figuring if there was anything else.

I have this checkbox on entity which gets me the value yes/no(as i checked in view), but if i fetch the same attribute in flow, it is giving me true/false. I was wondering if i could convert that into true false.

I tried using if => if(equals(@item()?['dcse_managergracecase'],true),'Yes','No'), but it is throwing me expression invalid. I have tried various combinations still cannot use the if. also i cannot use an variable to store the data as i am fetching multiple data and iterating over it, so i will have to store the data inside the table itself.

The approach that i am thinking is to save the data in some other entity in text format and then use that instead of the original attributes. If there is some solution please let me know

Thanks

All responses (2)

Answers (1)

Kavish vaidya Microsoft Employee on 16 Mar 2022 at 04:31:40

Like (0)

Report

Re: Fetch Yes/No from checkbox field instead of true/false

This feels such a dumb thing to ask. thanks a lot
Verified answer

tom_riha 10,093 Most Valuable Professional on 15 Mar 2022 at 19:10:03

Like (1)

Report
Re: Fetch Yes/No from checkbox field instead of true/false

Hello @Ez_Wiz ,

try to remove the @ from the expression, that should work:

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