cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
satishkumark
Helper I
Helper I

how to filter gallery data multiple controls using a button control in powerapps

Hi Reader,

I would like to filter a gallery data with multiple controls like input text and 5combobox controls on my screen, only when i click on a button.

Note: when I navigate to that screen, gallery data should be empty.

SharePoint list is my Data source.

Please find the screenshots :

satishkumark_0-1630682750596.png

 

Is there a way to do so?

Please help me out how to achieve this scenario.

 

Shanks in advance

Satish 

 

1 ACCEPTED SOLUTION

Accepted Solutions
zmansuri
Super User
Super User

On your find button OnClick set a variable for eg.

Set(VarEnable,true);

On your reset button OnClick set a variable for eg.

Set(VarEnable,false);

 

on your gallery item code write your logic like this:

If(varEnable=true,

Filter by comboboxes and text input,

No Filters

)

 

App.OnStart or Scree.OnVisible

Set(VarEnable,false);

 

This way when you start the app there will be no filters. Even when you select anything in comboboxes no filters will apply. as soon as you click find button. variable will be true and gallery will filter according to your filter code. When you click reset all filters will be gone.

View solution in original post

3 REPLIES 3
Nogueira1306
Community Champion
Community Champion

There is. It IFS but, you will have to consider ALL CONDITIONS.

 

And thens is jsut

If( condition..;

     FILTER;

      If( condition..;

      FILTER;

            ........

 

 

 

Nogueira1306_0-1630683055037.png

 

 

I have four itens to filter there...

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

zmansuri
Super User
Super User

On your find button OnClick set a variable for eg.

Set(VarEnable,true);

On your reset button OnClick set a variable for eg.

Set(VarEnable,false);

 

on your gallery item code write your logic like this:

If(varEnable=true,

Filter by comboboxes and text input,

No Filters

)

 

App.OnStart or Scree.OnVisible

Set(VarEnable,false);

 

This way when you start the app there will be no filters. Even when you select anything in comboboxes no filters will apply. as soon as you click find button. variable will be true and gallery will filter according to your filter code. When you click reset all filters will be gone.

View solution in original post

Ramole
Resident Rockstar
Resident Rockstar

Hi @satishkumark 
Have look this solved post if it helps you https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-multi-select-choice/m-p/927213#M29431... 

Thank you
If this post helps, then please consider Accept it as the solution to help the others and consider giving it a "Thumbs Up."

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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