Filtering multiple galleries

(0) Share

Report

Posted on by Valentino1

111

Hey everyone, I want to filter multiple galleries but im not sure how to write the code for it.

The image bellow is what I want to be able to filter, it can be one of 5 choices or it can be multiple of them in one record, so 2+. I want it to be filtered for example, I choose "HR" I want the records that have only "HR" AND the ones that have "HR" among other ones.

In the image below is how it looks like, the drop down is the filter. On the right I cant find my "Domains" column as shown in the previous picture of the sharepoint.

When i try to write this code im getting an error.

Does anyone know how to get through this?

Note: I already have the "Search" filter next to the drop down, in case that changes something.

These are the filters i already have.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Valentino1 ,

Dropdown control allows to select only one choice, is it OK for you? If it's fine, the formula in Items of Dropdown should be:

Choices(ListName.Domains)

Then to filter in the Gallery, you need below kind of formulas in Gallery Items:

Filter(SPlist, DomainDropdown.Selected.Value in Domain.Value)

Best regards,

Was this reply helpful? Yes No
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, thank you for the response, Im really new at this so I need to ask one more question. Im not sure how to integrate the second formula into my existing one.
This is what I already have.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Valentino1 ,

It seems you have already gotten the formula to work. Are there any other problems to these galleries?

Best regards,

Was this reply helpful? Yes No
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, I got it somehow haha. I have one thing i want to change still.
Is there a way for these "Domains" to have a default one so that it doesnt automatically filter on the "HR" one.

This is them in sharepoint.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Valentino1 ,

If you mean Not to default to HR in the Dropdown, you can change AllowEmptySelection to true and then clear the Default property of the Dropdown:

Best regards,

Was this reply helpful? Yes No
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah, now it doesnt show the request, im guessing because the default is nothing, and i dont have nothing as an option, there needs to be at least one Domain in order to filter them.

Is there a way I could maybe put all Domains as default and then when someone selects one it filters to that one. i dont know im just guessing .

Was this reply helpful? Yes No