Skip to main content

Notifications

Community site session details

Community site session details

Session Id : OdM7qswcrYiNNPf0HRrd8S
Power Apps - Building Power Apps
Answered

Multiple Filter in gallery

Like (0) ShareShare
ReportReport
Posted on 6 Mar 2024 06:20:46 by

Hii All,

 

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

 

AdityaRana_0-1709705800479.png

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 (testlistAnd(
    StartsWith(Roles, Dropdown1.SelectedText. Value),
    StartsWith(Roles, Dropdown1_1.1. SelectedText.Value)

))
 
 
 
  • AdityaRana Profile Picture
    on 06 Mar 2024 at 07:05:41
    Re: Multiple Filter in gallery

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

  • Verified answer
    v-yueyun-msft Profile Picture
    on 06 Mar 2024 at 06:47:52
    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 (testlistAnd(
        StartsWith(Roles, Dropdown1.SelectedText. Value),
        StartsWith(Text(liness), Text(Dropdown1_1.1. SelectedText.Value))
    ))

    vyueyunmsft_0-1709707665805.png

    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 Profile Picture
    on 06 Mar 2024 at 06:43:32
    Re: Multiple Filter in gallery

    I have also checked it but it doesn't work

    let me show you my data list.

    AdityaRana_0-1709707077135.png

    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 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 Profile Picture
    on 06 Mar 2024 at 06:24:56
    Re: Multiple Filter in gallery

    Hi, @AdityaRana 

    Please try to use :

    Filter (testlistOr(
        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:
    vyueyunmsft_0-1709706882250.png

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard
Loading started