cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

Filter Gallery

Hello everybody
I would like to filter the gallery according to my dropdown selection.
I got a single filter, but I need a double filter.

 

The abbreviations M should always be displayed and all others only after selection in my dropdown box.

 

Filter Test.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Hi @Robertjde ,

you are using and condition on the same columns , use orcondition."

OR  ( || ) condition means you will get the result record with abbreviation M and T. 

Thanks,
Vijay 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

View solution in original post

Highlighted
Resolver I
Resolver I

That is the solution! The decisive hint came from @VijayTailor 

 

I use it to set up an email distribution list in such a way that when a department is selected, all information from the form is sent to this distribution list.

Sort(
    If(
        Label.Text = "T" And Label01.Text = "M";
        Filter(
            'TEST Liste';
            Titel = Label.Text Or Titel = Label01.Text
        );
        Label.Text = "P" And Label01.Text = "M";
        Filter(
            'TEST Liste';
            Titel = Label.Text Or Titel = Label01.Text
        );
        Label.Text = "M" And Label01.Text = "M";
        Filter(
            'TEST Liste';
            Titel = Label.Text Or Titel = Label01.Text
        );
        IsBlank(Dropdown5.Selected.Value);
        'TEST Liste'
    );
    Titel;
    Ascending
)

 

Form1_Verteiler.PNG

View solution in original post

7 REPLIES 7
Highlighted
Super User III
Super User III

Hi @Robertjde ,'

I am not completely clear on your requirements, but is this what you want?

If(
   IsBlank(Label.Text);
   'Test Liste';
   If(
      IsBlank(YourDropdown.Selected.Value);
      Filter(
         'TEST Liste';
         Tite1="M"
      );
      Filter(
         'TEST Liste';
         Tite1=Label.Text
      )
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Highlighted
Resident Rockstar
Resident Rockstar

Hi @Robertjde ,

YOu can add the and Condition for Filter with a Selected item from Drop/Combo box selected.

&& ColumnName = ComboxName.Selected.Value  (Iff you selected the mutliple option then use in function for filter all the selected values.
See the below reference - 

VijayTailor_0-1603873889902.png

 


for M abbreviation, you want to display all the records than simply use the code you are using.

Thanks,
Vijay 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay



  

Highlighted

@WarrenBelz 
I determine the abbreviation in the label using the dropdown5 box

 

Kürzel.PNG

 

In the gallery the abbreviation "M" should always be displayed and abbreviations "T" and "P" optionally with the help of the dropdown box.

Maybe I am too cumbersome about my project!?!?

Highlighted

@WarrenBelz 
i have no idea why it doesn't work.
Can you maybe help?

 

Filter Test2.PNG

 

Highlighted

Hi @Robertjde ,

you are using and condition on the same columns , use orcondition."

OR  ( || ) condition means you will get the result record with abbreviation M and T. 

Thanks,
Vijay 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay

View solution in original post

Highlighted

@VijayTailor  exactly I want to get the result dataset with the abbreviations M and T

I also tried different columns, unfortunately without success.

 

 If( Label.Text = "T" And Label01.Text = "Management";Filter('TEST Liste';  Titel = Label.Text And Abteilung = Label01.Text))
Highlighted
Resolver I
Resolver I

That is the solution! The decisive hint came from @VijayTailor 

 

I use it to set up an email distribution list in such a way that when a department is selected, all information from the form is sent to this distribution list.

Sort(
    If(
        Label.Text = "T" And Label01.Text = "M";
        Filter(
            'TEST Liste';
            Titel = Label.Text Or Titel = Label01.Text
        );
        Label.Text = "P" And Label01.Text = "M";
        Filter(
            'TEST Liste';
            Titel = Label.Text Or Titel = Label01.Text
        );
        Label.Text = "M" And Label01.Text = "M";
        Filter(
            'TEST Liste';
            Titel = Label.Text Or Titel = Label01.Text
        );
        IsBlank(Dropdown5.Selected.Value);
        'TEST Liste'
    );
    Titel;
    Ascending
)

 

Form1_Verteiler.PNG

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (2,773)