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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,518)