Distinct and Sort in Combo box

(0) Share

Report

Posted on by PhineasT

187

Finally got this almost working.

Below is a Comb Box that has the following ' DataCollection ' in the Items property, with the following in the ' DefaultSelectedItems ' property.

The return is 36 items, the majority repeats of the same four the formula is asking for. The default should only be the four (or more, based on the content of Label1_8), and the return and the content of the Combo Box list should be sorted Ascending.

How do I update the below to achieve the above?

Filter(DataCollection, field_1 in (Label1_8.Text), If(ProcurementProfessional = field_1, Label1_8.Text))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@PhineasT

The Items property of the combobox:

Sort( Distinct( DataCollection, ProcurementProfessional ),Ascending )

The DefaultSelectedItems:

If(Label1_8.Text="ProcurementProfessional", First( Filter( Sort( Distinct( DataCollection, ProcurementProfessional ),Ascending ), Result=Label1_8.Text ) ) )

Was this reply helpful? Yes No
PhineasT 187 on at

Like (1)

Report

That didn't work. I believe what you were trying to achieve I have already achieved with the below. What the below DOES NOT do is auto-populate the Combo Box based on the content of Label1_8.Text.

I can open the Combo Box and see and list of email addresses and pick from those available.

What I also need is for the email addresses associated with the content (member names) in Label1_8.Text to auto-populate in the Combo Box.

What I have now; It only needs updating to auto-populate the emails desired:

Items:
Sort(
Distinct(
DataCollection,
EmployeeEmail
),
Result)

DefaultSelectedItems:
Filter(DataCollection,field_3, field_1 in (Label1_8.Text),field_3,Ascending)

Was this reply helpful? Yes No