cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (19,586)