cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ez_Wiz
Microsoft
Microsoft

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

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.

Ez_Wiz_0-1647315502855.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @Ez_Wiz ,

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

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


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

2 REPLIES 2
tom_riha
Super User
Super User

Hello @Ez_Wiz ,

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

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


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
Ez_Wiz
Microsoft
Microsoft

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (5,386)