cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Post Prodigy
Post Prodigy

DOUBLE FILTER ON A GALLERY, IS IT POSSIBLE?

Hey guys, I need filter a gallery on PowerApps with two parameters, the first one: 

name and the another is 'centro de custo'.Value....

 

I don't know very well how to work with filters yet if someone can help me, I will appreciate it. 

 

See the screenshot:

 

 double filter powerapps expanses.png

1 ACCEPTED SOLUTION

Accepted Solutions

Just adding with some of your code (and thanks @PowerAddict , for pointing out you can use a comma to replace And() / &&,) but you must use Or() / ||  for  a multi value filter so I generally show && when giving examples.

So if you do something like:

Filter(
   ExpenseMaster, 
   ID = Dropdown.Selected.ID &&
   [your test field] = 'centro de custo'.Value
)

this will give you the desired filter.

 

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.

 

View solution in original post

5 REPLIES 5
WarrenBelz
Super User III
Super User III

Hello @Gorilla_8 

Try 

Filter(
   [Data Source],
   [Criteria 1] &&
   [Criteria 2]
)

If you give me the actual tests, I can help you with the code if you need,

 

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

PowerAddict
Super User II
Super User II

Try something like this:

Filter(DataSouce, Name = TextInput.Text, Column = Dropdown.Selected)

Something like that, use your actual names. Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Just adding with some of your code (and thanks @PowerAddict , for pointing out you can use a comma to replace And() / &&,) but you must use Or() / ||  for  a multi value filter so I generally show && when giving examples.

So if you do something like:

Filter(
   ExpenseMaster, 
   ID = Dropdown.Selected.ID &&
   [your test field] = 'centro de custo'.Value
)

this will give you the desired filter.

 

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.

 

View solution in original post

I am trying by selecting the "ID"; 

 

Filter(
ExpenseMaster;
ID = Dropdown1.Selected.ID )

print_reembolso_filter.png

 
 

Hi @Gorilla_8 ,

What is the Items property of Dropdown1?

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (58,003)