Answered

Relational filtering for drop down list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am posting the data that i have and the final output that i would want but I am not able to figure out how can make dropdowns to achieve so. Any help would be appreciated.

This is the data that I have before

eq-id	op_1	op_2	op_3
t-80	mer = 50	Mer=30	mer=500
t-80	pi = 60		pi=90
t-80		xyz = 90	xyz=800
t-80			abc=80
t-90	mer = 60	Mer=30	mer=500
t-90	pi = 70		pi=90
t-90		xyz = 90	xyz=800
t-90			abc=80

The final output should be a dropdown for the columns (op_1,op_2,op_3) which when clicked give me unique values for their corresponding ids

eq-id	op_1	op_2	op_3
t-80	Dropdown[ mer = 50,pi=60]	Dropdown[ mer = 30,xyz=90]	Dropdown[ mer = 500,pi=90,xyz=800,abc=80]
t-90	Dropdown[ mer = 60,pi=70]	Dropdown[ mer = 30,xyz=90]	Dropdown[mer = 500,pi=90,xyz=800,abc=80]

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Joel CustomerEffective 3,224 on at

Like
a
(0)

Report
Copy link

Link copied!

so to make relationally filtered dropdowns, you will need to have some relation between the lists

so for example, if I have a company list and a conact list, and my contact list contains the company.
say dropdown 1 is company and dropdown2 is contact

If would set the items property of dropdown 2 to Filter(Contact, account=DropDown1.Selected)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I see but can you suggest what should be appropriate method to convert the table above to below
Can you suggest how should i go about the coding logic for it
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to transfer table1 to table2?

The point is:

1)use a gallery to display no-repeated eq-id value

2)insert 3 drop downs inside the gallery

3)make drop down1 display no-repeated op_1 value based on this item's eq-id value

4)make drop down2 display no-repeated op_2 value based on this item's eq-id value

5)make drop down3 display no-repeated op_3 value based on this item's eq-id value

Try to set like this:
1)insert a gallery, set its Items:

Distinct(datasorcename,eq_id)

2)set one label's Text inside the gallery:

ThisItem.Result

3)insert three drop downs inside the gallery

4)set drop down1's Items:

Distinct( Filter(datasourcename,eq_id=ThisItem.Result), op_1 )

set drop down2's Items:

Distinct( Filter(datasourcename,eq_id=ThisItem.Result), op_2 )

set drop down3's Items:

Distinct( Filter(datasourcename,eq_id=ThisItem.Result), op_3 )

If you also want to display the field name above your gallery, you just need to insert four labels above the gallery.

Set label1's text:

"eq_id"

Set label2's text:

"op_1"

Set label3's text:

"op_2"

Set label4's text:

"op_3"

Best regards,