Skip to main content
Community site session details

Community site session details

Session Id : L6/2yrHNKewMB1bGCW84ta
Power Automate - Building Flows
Answered

Convert True/False to Yes/No

Like (0) ShareShare
ReportReport
Posted on 17 Feb 2023 17:50:19 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,538 on 20 Feb 2023 at 14:09:29
    Re: Convert True/False to Yes/No

    Wow, finally! Glad to help. 😎

  • sudosaurus Profile Picture
    1,597 Super User 2024 Season 1 on 20 Feb 2023 at 14:05:08
    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,538 on 20 Feb 2023 at 13:44:43
    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 20 Feb 2023 at 12:30:50
    Re: Convert True/False to Yes/No

    @VictorIvanidze 

    sudosaurus_0-1676896238745.png

     

  • VictorIvanidze Profile Picture
    12,538 on 20 Feb 2023 at 12:07:10
    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 20 Feb 2023 at 12:04:35
    Re: Convert True/False to Yes/No

    @VictorIvanidze 

    sudosaurus_0-1676894664472.png

     

  • VictorIvanidze Profile Picture
    12,538 on 20 Feb 2023 at 12:02:33
    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 20 Feb 2023 at 12:00:35
    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,538 on 20 Feb 2023 at 11:56:02
    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 20 Feb 2023 at 11:51:28
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete