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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No