Multiple Filter in gallery

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AdityaRana on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AdityaRana on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No