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] |
Solved! Go to Solution.
Hi @Prbhv ,
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,
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)
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
Hi @Prbhv ,
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,
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
189 | |
54 | |
41 | |
37 | |
32 |
User | Count |
---|---|
252 | |
75 | |
71 | |
69 | |
68 |