Two Options Field returns Yes, No and blank in advance finds

(0) Share

Report

Posted on by Community Member Microsoft Employee

We have a Two Option field on our Opportunity forms. When that field is included in advanced finds, it returns three results: yes, no, blank. How can I get it to return just yes/no?

*This post is locked for comments

All responses (3)

Answers (2)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Two Options Field returns Yes, No and blank in advance finds

that explains it! thanks...
Verified answer

gdas 50,085 on at

Like (0)

Report

RE: Two Options Field returns Yes, No and blank in advance finds

Hello Robert,

Seems this is data issue , As you are in on premise just go to the table and update all null to some default value.

Also I am not sure what kind of customization you have for the entity , it's not expected value. Two options always contains 0 or 1.

Hope this helps.
Verified answer

a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Two Options Field returns Yes, No and blank in advance finds

Hello,

Create on-demand workflow that will set that field to "No" value.

Create advanced find where that Two Option field "Doesn't contain value", on results retrieved run on-demand workflow.

That's it.

Explanation is pretty simple - it seems that you created that "Two Option" field after some data was created. So for those records data was not populated and when you added field - for existing records value for a field was null (even you set 'default' value for it).