Showing results for 
Search instead for 
Did you mean: 
New Member

Filter function for Different Galleries



I am fairly new to Powerapps and I have a lot of questions.


I am trying to create a price list based on an Excel spreadsheet of parts. I have different categories, which correspond to all the parts.

"Customer Type", then "Type of Part", then "The Part" and finally "Descriptions"

I am using Shane Young's video as a guideline


Basically, click on the first Customer Type, which is filtered based on the selection, which goes to the next gallery for "Type of Part" which is filtered based on my selection, and so on until i reach my last description.


I typed in Filter(Table1, TypeofPart=BrowseGallery1.Selected.CustomerType) but I'm not receiving data when I try it.

I'm confused on why in Shane's video it works so well but it can't work with mine.


Any advice on what to do or how to make it better?

Thank you!

Resolver I
Resolver I

Hi Menemene7,


I learn the video you mentioned and try to test it with excel Table too, and firstly it shows nothing and when use "=" in the formula it shows error,says there is the invalid argument.

Then use the button to save the data, there is no wrong but it displays not as perfect as I want,so what the information I give is not the solution just the one hint.Hope this also can be helpful.

I also use excel to create three tables:categories,customeroftype,typeofpart.(I delete the sapace of the columns of it.)





Gallery1.items: Categories;

Gallery2.items:Filter(customertype,Gallery1.Selected.categories = TestingData);

Gallery3.itmes:Filter(Typeofpart,TestingData1 = Gallery2.Selected.CustomerType);


If you find the perfect solution please share  with me. Many thanks.


test_filter different gallerys.gif



Resolver I
Resolver I

Sorry I don't know why it will always use one emoticon expression to instead of my word(Set).


Community Support
Community Support

Hi @Menemene7,

Do you want to filter your  "Type of Part" gallery based on the selected record within your "Customer Type" gallery?

Based on the formula that you provided, I think you have some misunderstanding with Filter function in PowerApps.

I think there is something wrong with the filter condition within your formula. The left part (TypeofPart) would retrieve values from the TypeofPart column of your Table1 data source, the right part (BrowseGallery1.Selected.CustomerType) would return a CustomerType column value of the selected record in "Customer Type" gallery. The two parts you want to compare are in different columns of your Table1 data source.

Note: In your scenario, the two parts you want to compare should be in same column of your data souce.

On your side, please modify the Items property of the "Type of Part" gallery to following:

Filter(Table1, CustomerType = BrowseGallery1.Selected.CustomerType)

More details about the Filter function in PowerApps, please check the following article:

Filter function


Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

Thanks for your help with this thread @xyzzyx666 and @v-xida-msft!


@Menemene7 if you're still experiencing this issue, can you review the information provided and reply in the thread?



Thanks for the help! Yes this did work. It now shows the proper Type Of Part


However, it is now showing all the TypeofPart 's that are the same.


I attached a sample excel sheet. I'm trying to build a pricing list for items we sell


Basically, gallery1= CustomerType. Select the Type, which goes to

Gallery2 = TypeofPart, whichever is selected will show

Gallery3 = Part, Whichever is selected will show

Gallery4 = Description, with the price of each part


Gallery 1 formula is GroupBy(Table1,"CustomerType","CustType")

Gallery 2 forlmula is Filter(Table1, CustomerType=BrowseGallery1.Selected.CustomerType)  **But it shows some of the same parts instead of grouping them into 1 selection**


Thanks for the help!


So I figured out a solution to get to my second browsing screen. I was missing the Disctint formulation

Distinct (Filter(Table1, CustomerType=BrowseGallery1.Selected.CustomerType), TypeofPart)


Now however, when I try to apply the same concept to a third screen (From CustomerType, to TypeofPart, to Part), I get an error. Distinct (Filter(Table1, TypeofPart=Gallery1.Selected.TypeofPart), Part)

I think what I am missing is a reference to my first screen so Powerapps knows what to look for

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,139)