Unanswered

Changing true to Yes, false to No in Flow

(0) Share

Report

Posted on by EdwardC

Hi, I have a flow (see image) which pulls data from SharePoint Online site. On the SharePoint site, the toggle value is "Yes" or "No" but somehow on Flow it converts those values to "true" and "false" when I copy the data to onto a Word doc. Values below contains either "Yes" or "No":

Flow Word Screenshot

Is there a way to convert the values back to "Yes" and "No" instead of true and false?

Also, can I change the font size and color of these values?

To give you more idea of how what I'm doing:

1) I created a PowerApps Form for users to enter data and toggle "Yes" or "No" questions

2) SharePoint Online stores these datas

3) Flow takes these datas and insert it into a Document Library on SharePoint

4) On Document Library, there's a Word template that uses Quick Parts to display these data and that's where it shows "true" and "false" instead of Yes and No

Any help is much appreciated!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

PieterVeenstra 13 on at

Like (1)

Report

Hi @EdwardC,

this isn't really a flow issue. If you have a document library with yes/no fields and add these Quick Parts to a document you will see true false in your document. If you want Yes/No then you coudl go for a choice field with Yes and No instead.

Was this reply helpful? Yes No
EdwardC 69 on at

Like (0)

Report

Hi Pieter,

It is a Yes and No field. However, after being pushed from Flow to Word doc using quick parts, it ended up as true/false.

Anyways, I found a workaround this. Thanks tho.

Was this reply helpful? Yes No
GrischkePro 287 on at

Like (9)

Report
I found a workaround too, so I, unlike others :P, should share (SharePoint list):

if(equals(triggerBody()?['InternalColumnName'],True),'Yes','No')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,

Where would this formula go?

Was this reply helpful? Yes No
GrischkePro 287 on at

Like (0)

Report

For example, it can go into an email body to display Yes or No instead of True or False. Or it can go to HTML file, which you can then convert to PDF and so on.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @GrischkePro

I used your solution but flow doesnt show the column, can you see what i did wrong?
The name of the internal yes/no checkbox is 'testcolumn'

@{triggerBody()?['testcolumn']}
if(equals{(triggerBody()?['testcolumn']},True),'Yes','No')
if(equals@(triggerBody()?['testcolumn'],True),'Yes','No')
if@(equals@(triggerBody()?['testcolumn'],True),'Yes','No')
if(@equals@(triggerBody()?['testcolumn'],True),'Yes','No')

Only the first one works but in the mail i see true/false, i need to show Yes/No.

Regards

Was this reply helpful? Yes No
lras120265 on at

Like (0)

Report

Hi @Pieter_Veenstra ,

I know your answer was a couple of years ago. I had the same issue and your suggestion solved the problem! Thank you so much!

Was this reply helpful? Yes No