Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Convert True/False to Yes/No

(0) ShareShare
ReportReport
Posted on by 1,597 Super User 2024 Season 1

Hello!


I am trying to convert True/False to Yes/No where the values have come from a 'Get_item' action.

 

I've tried using this expression however "True" responses are coming back as "No".

 

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

 

For reference, I am populating an MS Word template:

sudosaurus_0-1676656168124.png

 

  • VictorIvanidze Profile Picture
    12,484 on at
    Re: Convert True/False to Yes/No

    Wow, finally! Glad to help. 😎

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on at
    Re: Convert True/False to Yes/No

    @VictorIvanidze that was the winner!! 🙂

     

    Thank you for helping me overcome this issue.

  • Verified answer
    VictorIvanidze Profile Picture
    12,484 on at
    Re: Convert True/False to Yes/No

    OK. Try this

    if(outputs('Get_item')?['body/OData__x0051_1'],'Yes', 'No')
  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on at
    Re: Convert True/False to Yes/No

    @VictorIvanidze 

    sudosaurus_0-1676896238745.png

     

  • VictorIvanidze Profile Picture
    12,484 on at
    Re: Convert True/False to Yes/No

    Please show "Compose Q1" in edit mode. Are you sure there is 

    if(equals(outputs('Get_item')?['body/OData__x0051_1'],'true'),'Yes', 'No')

    ?

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on at
    Re: Convert True/False to Yes/No

    @VictorIvanidze 

    sudosaurus_0-1676894664472.png

     

  • VictorIvanidze Profile Picture
    12,484 on at
    Re: Convert True/False to Yes/No

    Sorry I don't care about 'Populate a Microsoft Word template' action.

    Could you please answer my question - what do you see if you place the expression above to a new Compose action?

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on at
    Re: Convert True/False to Yes/No

    @VictorIvanidze 

     

    In the 'Populate a Microsoft Word template' action it is still resulting in 'True':

    sudosaurus_0-1676894418039.png

     

  • VictorIvanidze Profile Picture
    12,484 on at
    Re: Convert True/False to Yes/No

    Aha. Try this:

     

     

    if(equals(outputs('Get_item')?['body/OData__x0051_1'],'true'),'Yes', 'No')

     

     

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on at
    Re: Convert True/False to Yes/No

    @VictorIvanidze 

     

    I tried using your above expression and the results came back as True.

    sudosaurus_0-1676893872773.png

     

     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492