Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Jabs5GPNhCrCLJS7POgGzk
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 15 Mar 2022 03:40:04 by 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.

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

  • Kavish vaidya Profile Picture
    Microsoft Employee on 16 Mar 2022 at 04:31:40
    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 Profile Picture
    10,085 Most Valuable Professional on 15 Mar 2022 at 19:10:03
    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')

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 18 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 14

#3
Churchy Profile Picture

Churchy 12

Overall leaderboard
Loading started