Dropdown selection to filter Gallery

(0) Share

Report

Posted on by blur2teoh

Hi everyone,

Hope you are all having a pleasant weekend.

I am in the middle of designing an App.

I have a excel list where a country can appear multiple times.

My app has 2 screens.

I want the first screen to show 2 dropdown. The 1st dropdown shows all the country names (but for the country names to only appear once). Then 2nd dropdown will depend on the country and appear the customer's name.

Once they select customer's name from the dropdown, and click the button to navigate to screen 2, the gallery should display all the information related to the customers.

Any help appreciated!!

Thanks

#mobileapps

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @blur2teoh ,

Could you please tell me what your table looks like?
You can try:
The items property of Dropdown1:
Distinct (excel list, country)

The items attribute of Dropdown2:
Filter(excel list,country=Dropdown1.Selected.Result).customer

Button's OnSelect property:
Navigate (Screen2)

In Screen2, you can use Dropdown2.Selected.customer to query customer information.

Was this reply helpful? Yes No
blur2teoh 9 on at

Like
a
(0)

Report
Copy link

Link copied!

1st screen show in below:
2nd screen show in below:

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @blur2teoh ,

Could you please tell me where your customer information is stored?
You can use Filter() to query his information according to the customer selected in the Dropdown2.

Best Regards,
Dezhi

Was this reply helpful? Yes No
blur2teoh 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-dezhili-msft,
Customer information stored in the same excel file (table) i use for screen 1 meaning excel file contain all the information. May i know how to write the formula to link screen 2 to the customer selected in the Dropdown2?

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @blur2teoh ,

You can try to add a Display form and use it under its itme attribute:
LookUp(excel list, customer=Dropdown2.Selected.customer)

Best Regards,
Dezhi

Was this reply helpful? Yes No
blur2teoh 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-dezhili-msft ,

Thank you for your help. It is worked.
Lookup(excel list. customer=dropdown2.selected.result)

Was this reply helpful? Yes No