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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,908)