Yes/No field string value returns True/False, want it to be Yes/No ... is there a way to fix this?

Question

_{Tuesday, May 10, 2016 4:22 PM}

We are using SP Foundation 2010 for our Intranet.  We are creating electronic forms using custom lists and wrapping lots of workflow around them.  Our Hire/Separation Notice form has a field named Screening Done that we wanted a checkbox for on the form, so we created a Yes/No field for it.  One of the workflow steps is sending an e-mail with all the values filled in on the form.  When we add a Lookup to the e-mail on the Screening Done field it gives us only one option for display "string" which ends up giving you back a "True" or a "False" string value.  Having the e-mail display Screening Done: False makes you have to think about the value, where "Yes" or "No" is very clear.  Is there not a way for the Yes/No field to return a "Yes" or "No"?  Can't find anything on this in the forums or on the web.  Appreciate any assistance here ... thanks!

Alan-Seattle

All replies (4)

_{Tuesday, May 10, 2016 4:59 PM ✅Answered}

I don't think there is straight way to make the field return Yes/No. In your workflow, you need to create a workflow variable, check whether the field is true or false and assign variable with Yes or No. Use the variable in your e-mail activity.

Rajesh
rjesh.com| @rjesh
You don't need to buy me a beer, if helpful just smile, vote, and mark it as answer.

_{Tuesday, May 10, 2016 7:22 PM ✅Answered}

I think your only solutions are what Rajesh suggested, or simply changing the checkbox to a Choice field that contains Yes and No, defaulting to No.

_{Thursday, May 12, 2016 6:43 AM ✅Answered | 1 vote}

Hi Alan,

When you use a Checkbox column, the internal Type of the column is Boolean, and its TypeDisplayName is Yes/No. You can check its property using SharePoint Manager 2010:

For your issue, I suggest you do as Rajesh's suggestion or John's suggestion.

Thanks,

Wendy

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Tuesday, May 10, 2016 5:52 PM}

Rajesh ... yes, of course I could do that.  Just trying to keep the code simple and see if there is a reason why a Yes/No column would return a True/False string instead of Yes/No when internally it is a 1/0 boolean value.

Alan-Seattle