cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
EdwardC
Level: Powered On

Changing true to Yes, false to No in Flow

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

values.png                          values2.png

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Changing true to Yes, false to No in Flow

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.

 

6 REPLIES 6
Super User
Super User

Re: Changing true to Yes, false to No in Flow

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.

 

EdwardC
Level: Powered On

Re: Changing true to Yes, false to No in Flow

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.

GrischkePro
Level: Powered On

Re: Changing true to Yes, false to No in Flow

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

 

if(equals(triggerBody()?['InternalColumnName'],True),'Yes','No')
jbong1
Level: Powered On

Re: Changing true to Yes, false to No in Flow

Hello,

 

Where would this formula go?

GrischkePro
Level: Powered On

Re: Changing true to Yes, false to No in Flow

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.

Wackmack88
Level 8

Re: Changing true to Yes, false to No in Flow

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 44 members 4,545 guests
Please welcome our newest community members: