Multiple Filter in gallery

Like (0) Share

Report

Posted on 6 Mar 2024 06:20:46 by AdityaRana

Hii All,

I am using two dropdown to filter my gallery. But it was not showing anything or showing incorrect value.

In the above file I have used two dropdown:

Dropdown1- contains test1 and test2.

Dropdown2 - contains 1,2.

When I select both the dropdown it shows nothing.

I am using this formula on my gallery:

Filter (testlist, And(

StartsWith(Roles, Dropdown1.SelectedText. Value),

StartsWith(Roles, Dropdown1_1.1. SelectedText.Value)

))

Categories:

Connecting to Data

Using Apps Using Formulas

All responses (4)

Answers (1)

AdityaRana on 06 Mar 2024 at 07:05:41

Like (0)

Report

Re: Multiple Filter in gallery

It is working as I want. Thanks for your help.
Verified answer

v-yueyun-msft on 06 Mar 2024 at 06:47:52

Like (0)

Report

Re: Multiple Filter in gallery

Hi , @AdityaRana

Do you mean you want filter the [liness] by your dropdown1_1? If this , you need to use this code:

Filter (testlist, And(

StartsWith(Roles, Dropdown1.SelectedText. Value),

StartsWith(Text(liness), Text(Dropdown1_1.1. SelectedText.Value))

))

If this can not help you , what's the type of your [liness] column? And If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang
AdityaRana on 06 Mar 2024 at 06:43:32

Like (0)

Report

Re: Multiple Filter in gallery

I have also checked it but it doesn't work
let me show you my data list.
I want to make a sequential filter, let me tell you in steps:
Step-1: when we took test1 in dropdown1 it shows all the data of test1 in gallery
Step-2: After we select 1 in dropdown1_1 the it will show all the data of 1 where role will be test 1 in gallery

Hope you will understand the real query.

I want to make multisequential filter. both are connected
v-yueyun-msft on 06 Mar 2024 at 06:24:56

Like (1)

Report

Re: Multiple Filter in gallery

Hi, @AdityaRana

Please try to use :

Filter (testlist, Or(

StartsWith(Roles, Dropdown1.SelectedText. Value),

StartsWith(Roles, Dropdown1_1.1. SelectedText.Value)

))

StartsWith is used to filter the text if start with some string text. If you use And , it will return in your side.

For example:

If this still can not help you , can you show your testlist table data and what data you need to filter by your dropdown control.

Best Regards,

Yueyun Zhang