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
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (2,559)