Answered

Filter gallery based on dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello I am starting on Powerapps,

What I would like is with the dropdown list, select a number (title element TE4492) and that in my gallery, I have the list of numbers with the same title (TE4492) and not just 1 unique element.

Thanks!! 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

If I understood correctly, you want to filter the items in gallery based on the dropdown on the top of your screen. If this is correct, then you can use the below expression:

Filter(DataSourceName, ColumnName = DropdownName.Selected.ColumnName2)

Here, you have to replace DataSourceName with your list, ColumnName with the name of column in your list and DropdownName with the control Name on the screen, and columnName2 with the name of column you want to pick from the dropdown.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
JayMagness 1,663 on at

Like (1)

Report
Copy link

Link copied!

Hi,

What I do is add another gallery in the first Gallery Element and should give you what you want.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Items property of dropdown

Sort(Distinct(SPlist, title), Result)

Items property of gallery

Filter(SPlist, Dropdown1.Selected.Result)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello , thank you for your answer I have an error

Can you tell me if I have written correctly?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

The value that you highlighted in blue needs to be replaced with the column name as per your data source. If this does not resolve the issue, can you please share the error details?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

I got two errors :

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You actually use “Result” since distinct creates a single column table and that column is renamed “Result”.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks to @ all it's solved !

Very fast thanks for all community and those who contacted me by private message.

Have good day !

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

If your issue is resolved, can you please mark the thread as solved, so that it is helpful for others as well.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No