Combo box filtering

[neill_long]

Hi

I have 2 combo boxs, the first combo box has the formula:

Sort(Distinct(Exams,Course),Value ,SortOrder.Ascending)

The 2nd Combo box has the formula:

Sort(Distinct(Filter(Exams,Course = ComboBox3.Selected.Value),Title),Value,SortOrder.Ascending)

This is working, as it filters the results based on what has been selected in combo box1.  However, There is an entry called 'Mop Ups' that i would like to be displayed in the 2nd combo box which is to be displayed regardless of what is selected in the first combo box.

Can this be done?

Any help will be appreciated

thanks

[Amik]

@neill_long - you mean if nothing is selected in the first combo box, then the default value in the 2nd combo box should be "Mop Ups" ?

[mmbr1606]

The updated formula for the second combo box might look something like this:

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[neill_long]

If nothing is selected then Mop Ups does display, but I want it to also display when an option is selected. 

I know i could add a record in the SP List with the course and have mop ups against each course, but was wondering if there was an easier way to only have the one record for mop ups, not have the course field completed but this record would always display regardless if combo box 1 is empty or something has been selected

[Amik]

@neill_long - I will leave you with @mmbr1606 who has also responded.

[neill_long]

@mmbr1606 I have tried your formula but i am getting errors. saying Union is an unknown or unsupported function and also Name is not valide 'Value' is not recognised.

Any ideas what i have done wrong?

[mmbr1606]

sorry for confusion:

try this in the onchange of combo box

ClearCollect(
    TempCollection,
    Filter(Exams, Course = ComboBox1.Selected.Value),
    {Title: "Mop Ups"}
)

 and this in the items property of combobox2:

Sort(
    Distinct(TempCollection, Title),
    Result,
    Ascending
)

[neill_long]

@mmbr1606 I think we are almost there.  when option is selected it now shows mop ups, but i would also like it to display all the other records that match what has been selected in combo box 1?

[mmbr1606]

what else should be shown or displayed, can u provide screenshots or explanation so i can understand better

[neill_long]

this is what is displayed with the formula that you have provided:

But what it should display is this:

But the list should also display Mop Ups.