Convert True/False to Yes/No

Like (0) Share

Report

Posted on 17 Feb 2023 17:50:19 by sudosaurus

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:

All responses (19)

Answers (1)

VictorIvanidze 12,538 on 20 Feb 2023 at 14:09:29

Like (0)

Report

Re: Convert True/False to Yes/No

Wow, finally! Glad to help. 😎
sudosaurus 1,597 Super User 2024 Season 1 on 20 Feb 2023 at 14:05:08

Like (0)

Report

Re: Convert True/False to Yes/No

@VictorIvanidze that was the winner!! 🙂

Thank you for helping me overcome this issue.
Verified answer

VictorIvanidze 12,538 on 20 Feb 2023 at 13:44:43

Like (0)

Report
Re: Convert True/False to Yes/No

OK. Try this
if(outputs('Get_item')?['body/OData__x0051_1'],'Yes', 'No')
sudosaurus 1,597 Super User 2024 Season 1 on 20 Feb 2023 at 12:30:50

Like (0)

Report

Re: Convert True/False to Yes/No

@VictorIvanidze
VictorIvanidze 12,538 on 20 Feb 2023 at 12:07:10

Like (0)

Report
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 1,597 Super User 2024 Season 1 on 20 Feb 2023 at 12:04:35

Like (0)

Report

Re: Convert True/False to Yes/No

@VictorIvanidze
VictorIvanidze 12,538 on 20 Feb 2023 at 12:02:33

Like (0)

Report

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 1,597 Super User 2024 Season 1 on 20 Feb 2023 at 12:00:35

Like (0)

Report

Re: Convert True/False to Yes/No

@VictorIvanidze

In the 'Populate a Microsoft Word template' action it is still resulting in 'True':
VictorIvanidze 12,538 on 20 Feb 2023 at 11:56:02

Like (0)

Report
Re: Convert True/False to Yes/No

Aha. Try this:

if(equals(outputs('Get_item')?['body/OData__x0051_1'],'true'),'Yes', 'No')
sudosaurus 1,597 Super User 2024 Season 1 on 20 Feb 2023 at 11:51:28

Like (0)

Report

Re: Convert True/False to Yes/No

@VictorIvanidze

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