Filter Gallery - show multiple results single dropdown value

(0) Share

Report

Posted on by MP4249

Hi, still new to all this!

I know this should be really simple but cant quite get it right. I need to filter a gallery by say colour in this case.

So the gallery needs to display multiple results based on a single selection of a dropdown called 'Colour':

Colour

Red

Blue

Green

Items

Red Item1

Red Item2

Red Item3

Blue Item 1

Blue Item 2

Blue Item 3

Green Item 1

Green Item 2

Green Item 3

How would I go about this please?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

You didn't say exactly how you determine that an item is a red item or a blue item, so I'm going to assume that you actually have a column in your data source that contains the color of the item. Let's say your color selection dropdown is DropDown1 and your data source is List1 and your item color is ItemColor.

Then you would filter the items as Filter(List1, ItemColor = DropDown1.Selected.Value)

Was this reply helpful? Yes No
MP4249 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for your reply.
That the problem, this value is not contained in the data source - I was hoping to use the formula to state what it should be. So in this example can i not just force the filter to show the three values by specifying them?

Sorry for my lack of know how here.

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

I guess I'm just not understanding what you are trying to accomplish. If you select Red from the dropdown with the 3 colors in it, which items do you expect to see in your gallery -- those which you have listed as Red items only, correct? If so, what in the data source containing the items allows you to know that these are the red items?

Was this reply helpful? Yes No
MP4249 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry know it seems strange and counter productive, but I really just want to tell the filter to explicitly show items I define based on a selection elsewhere.

So if dropdown value equals ‘x’
Then show ‘this item, this item and this item’ only

I’m Sure it’s simple enough but don’t know how to format it in this example

Many thanks!

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmmm... OK. Botttomline, you must have something associated with each item to tell the filter to select it. It would be rather cumbersome and artificial but I suppose you could create a collection with each of your items and include a new "selection column" that you either populate as you load the collection or patch that column with the value that indicates "pick me if red is selected". Then you can run your filter on that new column.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MP4249 how are you progressing with this issue?

@Anonymous

Was this reply helpful? Yes No