cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TroyLeininger
Frequent Visitor

Filtering exact phrase

Hi everyone!

I'm a UX designer and new to PowerApps. I'm working on a project where when the user clicks on a flavor of ice cream, a list of ingredients show up of that type of ice cream.

The problem we have is that when we click on "Chocolate", we get a list that has ingredients for chocolate ice cream, but also Chocolate Chip, Chocolate banana, etc.. So the filter is bringing in all ingredients for any ice cream that has the word "Chocolate" in it. 

This is the code for the gallery:
Filter( [@'IceCream - Flavors'],  FlavorButton.Selected.Title  in  Concat ('Ice Cream Ingredients', Text(Value), " ") )

Hope you can help. Thanks!

3 REPLIES 3
proxyprochy
Resolver I
Resolver I

This should work.

Filter( [@'IceCream - Flavors'], 'Ice Cream Ingredients' = FlavorButon.Selected.Title )

 

also, check this:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Thanks for responding! I'm still having issues though. I tried to rearrange the elements so it matched your suggestion, but it gave me this error:

proxyprochy
Resolver I
Resolver I

I'm not sure what type of column is that. Try:

 

Filter( [@'IceCream - Flavors'], 'Ice Cream Ingredients'.Value = FlavorButon.Selected.Title )

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,421)