cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pmwhelan
Helper V
Helper V

SharePoint List Value "Yes/No" is coming in as "True / False" to my flow

Hi

 

I have a flow that starts when an item is added to a SharePoint List.

I then kick off an Approval.

One of the values I wish to approve is a Yes/No field.

But it is displaying as True/False in the Approval email.

 

Is it possible to get it to say Yes /No?

I try to set a variable in my flow but it is always No.

 

thanks

P

3 REPLIES 3
Redders
Continued Contributor
Continued Contributor

I created a push button with yes no, here is the outcome of no

Redders_0-1666194717671.png

As you can see, it produces the false output.

 

If I add the expression ( switch the dynamic content appropriately )

 

 

if(equals(triggerBody()['boolean'],false),'No','Yes')

 

 

The result is No instead

 

Redders_1-1666194847576.png

 

Start by typing the first part

Redders_2-1666195018249.png

Switch to dynamic content and select the appropriate Boolean field

Redders_3-1666195030441.png

 

Finish the remainder of the expression

Redders_4-1666195062249.png

 

I hope this helps

 

━━━━━━━━━━━━━━━━━━━━━━━━━

 

If I have answered your question, please mark your post as Solved.

 

Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.

 

If you liked my response, please consider giving it a thumbs up. Thank you!

 

Thanks for the help.

 

Do you mean like this?

flow.png

Redders
Continued Contributor
Continued Contributor

Hi @pmwhelan,

 

I mean that your yes / no option in your SharePoint list value shows as Yes / No however, the output is True / False.

 

I think seeing your flow helps me partially understand, hopefully I've grasped the right end of this

 

How to write a good forum post

 

If you want to produce the word yes/no then you can use the expression that I provided however, it appears that you types in Yes / No in your condition. e.g

 

Redders_0-1666197771174.png

 

Just change that to an expression either True / False instead of Yes / No

 

Redders_2-1666197821904.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,527)