web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Using a Dropdown list ...

Power Apps

Answered

Using a Dropdown list containing values from one list to filter items of another list's Browse Gallery

(0) Share

Report

Report

Posted on by DevadathanK

56

Hi Community!

I am stuck trying to implement this feature in PowerApps. Let me explain the issue,

I have two SharePoint Lists that are added as sources in PowerApps, the lists are as follows -

List 1

List 1.PNG

List 2
List 2.PNG

Now what i am trying to do is to implement a DropDown in the Browse Gallery page of List 2. The Drop down should shown values of Location from List 1 (here, Brooklyn and Queens). If Brooklyn is selected, then the Browse Gallery of List 2 should only display the Academic details of students from that location.Like Shown below -

Academic Details - List 2's Browse Gallery

I used this following code in the dropdown to list out the distinct locations but i do not know how to filter the browse gallery with the item selected from the drop down.

Distinct('Student Details','Location'.Value)

Is there anyway to accomplish this? I'm totally stuck.

Thanks for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

amitchandak 95 on at

Like
a
(0)

Report
Copy link

Link copied!

@DevadathanK, refer if this can help
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/dependent-drop-down-lists

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DevadathanK ,

What is the data type of Location column? It seems to be Choices type, right?

If so, I suggest you modify the Items property of dropdown to Choices('Student Details'.'Location')

Then, modify the Items property of gallery:

Filter(AddColumns('Academic Details',"SID", 'Student ID'.Id), SID in Filter('Student Details',Location.Value=Dropdown1.Selected.Value).ID)

Hope this helps

Sik

Was this reply helpful? Yes No

Join the conversation