Distinct function for combo box is populating blanks

(0) Share

Report

Posted on by Sri

559

Hi All,

I have a combo box(dd ) and using filter and distinct to get unique values. And my code is

If(
SeniorSearchCombo.Selected.Result in varseniordd.sddname,
Distinct(
Filter(
vardd,
sddname = SeniorSearchCombo.Selected.Result
),
ddname
).Result ,
Sort(
Filter(
Distinct(
vardd,
ddname
),
Not(IsBlank(Result))
),
Result
)
)

The first condition works based on the another combo box (senior dd). When the SeniorDD is selected the respective DD under them would be populated in this Combo box (dd). The second condition would filter all the dd names by default in the SP list.

But my combo box is having blank values even though I have used Distinct function.

Any help would be greatly appreciated.

Categories:

General Questions

Screenshot (38).png

All responses (3)

Answers (1)

Sri 559 on at

Like (0)

Report

Re: Distinct function for combo box is populating blanks

Hi @RandyHayes ,
I have a continuation to this requirement. First condition is working fine. If Seniordd is selected in another combo box, the respective DD names under the Senior DD loads fine. But the other condition when none of the Senior DD is selected by default it must display all the DD names which are in the SharePoint list.
But in my case, It works only when Senior DD is selected the DD names are displayed whereby default it is listing only few names (For e.g. If I have 12 names as DD in SharePoint only 5 is getting listed.)

Any help/suggestion on this?
Thanks in advance.
Sri 559 on at

Like (0)

Report

Re: Distinct function for combo box is populating blanks

Hi @RandyHayes ,
Thank you so much. It worked perfectly.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (2)

Report
Re: Distinct function for combo box is populating blanks

@Uthhra

You're not checking for blank in both scenarios.

Please consider changing your Formula to the following:

Sort( Filter( Distinct( Filter(vardd, !(SeniorSearchCombo.Selected.Result in varseniordd.sddname) || sddname = SeniorSearchCombo.Selected.Result ), ddname ), !IsBlank(Result) ), Result )

I hope this is helpful for you.