Answered

ComboBox not showing Values

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey there,

I am pretty new to power apps and I try to setup my first app.

I got an app where the data comes from a few sharepoint lists and I try to fill them into Dropboxes and Comboboxes. It all works great so far until I tried to filter duplicates out of an Combobox.

The code looks as follow:

If(Checkbox1.Value = false, (Filter(Assistants, Department = DropdownDepartment.Selected.Result)), Distinct( Assistants,'Display Name'))

As soon as I check the checkbox1 it just shows empty rows. But I think the number of the rows could be the amount of Names I could expect.

When I am using following code, it works and show just the same name multiple times (what I am trying to prefent)

If(Checkbox1.Value = false, (Filter(Assistants, Department = DropdownDepartment.Selected.Result)), Assistants.'Display Name')

Thanks in advance and have a nice day

Daniel

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

If(Checkbox1.Value = false, Distinct(Filter(Assistants, Department = DropdownDepartment.Selected.Result)), 'Display Name')

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to display the 'Display Name' column value from Assistants List within the ComboBox?

Based on the formula that you mentioned, I think there is something wrong with it. I have made a test on my side, please consider modify your formula as below (set the Items property of ComboBox to following😞

Distinct( Filter( Assistants, If( Checkbox1.Value = false, Department = DropdownDepartment.Selected.Result, true ) ), 'Display Name' )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-xida-msft Thanks a lot your solution works perfectly! Thanks a lot for your effort.

@eka24 I get an error by your formula but the other solution works great.

Was this reply helpful? Yes No