Powerapps Dictinct function - How to indicate columns name from Combobox.SelectedText

(0) Share

Report

Posted on by corsair266

Hi every one, I have Table1 with several column names represented product types

Table 16.jpg

Combobox1: Dropdown list of job Product type. Example "450G"

Combobox2: I use Distinct function to list all related jobs from selected product type Combobox 1.SelectedText

But problem is, Distinct(Table1, Combobox1.SelectedText) doesn't return the list belong to "450G".

If i say Distinct(Table1,'Apple' ) - it work fine.

Does anyone can give idea how to indicate column name in Distinct function from Combobox2.SelectedText?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
HI @corsair266 ,

Distinct produces a single column table of unique values and renames that column "Result". BTW: .SelectedText is deprecated and may not be supported in the future. If 'Allow multiple selections is false in your combobox, and you wanted to filter on a column called "product" for example, then

Filter(Table1,product=Combobox1.Selected.Result)

if the combobox's Allow multiple selections is true, then it would be

Filter(Table1, Combobox1.SelectedItems in product)

to filter for several selections in the combobox. To see how it would work with several comboboxes allowing multiple selections:

Was this reply helpful? Yes No
corsair266 10 on at

Like (0)

Report

Dear Drrickryp, thank you for your explain however that is not the point I would expected.
I explain in the picture below. I want to have combobox 2 shows all jobs regarding product type that is selected from combobox 1.
Thank you in advance

Was this reply helpful? Yes No
corsair266 10 on at

Like (0)

Report

Anyone can help for this issue?
At the moment my Distinct function in combobox 2 doesnt work

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @corsair266 ,

You could try hard-coded.
You could try this formula on your combo box 2 control.

If(Combobox1.Selected.Value="450G",Distinct(Table1,450G),Combobox1.Selected.Value="475A",Distinct(Table1,475A),....,.....)

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No