Answered

Filtering data in a gallery using a dropdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I need to filter data in a gallery using a dropdown. The problem is I need to use data from one excel sheet(table that has only some records) to filter data in the other excell sheet(table that contains all records). In gallery I need to show data from table that has all the records but filtered based on other table. For example, in main table i have all of the E-numbers (food additives) and in other table I have only E-numbers that are allowed. I need to somehow compare table that contains allowed E-numbers to main table that has all E-numbers and based on that populate the gallery upon selecting "Allowed" in dropdown. Anyone has an idea please?

Thank you

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming you have some dropdown in your gallery that has something like ["Allowed","Not allowed"] for the items property, you can set the Default property to:

If(IsBlank(LookUp('Allowed List', Title = ThisItem.Title)),"Not allowed", "Allowed")

Basically it checks if the item has a match in the list of allowed E-numbers and if there's no match, it will set de dropdown value to "Not allowed", etc.
Verified answer

Abhilash_Swain 901 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,
let's say, in Gallery you are connecting to Excel1 and in the dropdown, you are connecting to Excel2.
1st Method:-

In DropDown-> Go to Items -> Excel2.ColumnName (It will list all the items from that column.

In Gallery-> Go to Items -> Filter(Excel1, If(isblank(Dropdown.Selected.Value),true,excel1.column = Dropdown.Selected.Value))

2nd Method:-
In gallery-> Goto Items - > Filter(Excel1 as Tgt, Tgt.E-numbers In Distinct(Excel2.E-numbers))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, that did it!