cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Two filters in a gallery

I need to filter a sharepoint list.

 

I have two filters to do, one of them, come from a QR Code scan var. But those rows filtered by this var have to be filtered where the column STOCK <> 0.

 

filterapps.png

 

It's not working with FILTER. 

 

a.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Two filters in a gallery

Hi @gabrielrosa94

Could you tell me what Estoque's data type is?

If it is Text type,please try this code:

Filter(ControleEstoque;Value(Estoque)>0 && IDenderico = vartestemov)

Best Regards,

Bof

View solution in original post

4 REPLIES 4
Highlighted
Super User
Super User

Re: Two filters in a gallery

HI @gabrielrosa94 

Filter(ControleEstoque;Estoque>0 && IDenderico = vartestemov)

Highlighted
Super User
Super User

Re: Two filters in a gallery

@Drrickryp 

Agreed, though it is strange a delegation error is already happening with the current formula.  What do you think could be causing that?

Highlighted
Frequent Visitor

Re: Two filters in a gallery

Hey! Thanks for you support.

 

This is not working. I tried this one, but my formula bar looks like this:

 

TESTE.png

Highlighted
Microsoft
Microsoft

Re: Two filters in a gallery

Hi @gabrielrosa94

Could you tell me what Estoque's data type is?

If it is Text type,please try this code:

Filter(ControleEstoque;Value(Estoque)>0 && IDenderico = vartestemov)

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (10,596)