cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FGUEVARA
New Member

Filter Table with multiple dropdown

Hi, I'm trying to filter a data table, usign multiple dropdowns, but the formula bar can't recognize the input. Anybody can tell me what I'm doing wrong.

 

Thanks

 

captura.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @FGUEVARA again, 

 

gabibalaban_0-1604591038391.png

 

Your formula should be:

Filter(PENDIENTES;PROY = drp_proy.Selected.Result)

 

I'm still confused why in your formula you used PROY, not PROYECTO.

 

Hope it helps !

View solution in original post

4 REPLIES 4
gabibalaban
Dual Super User
Dual Super User

Hi @FGUEVARA 

 

Is PROY column a choice type in sharepoint  ? What is the formula for items of  drp_proy ?

  

 

FGUEVARA
New Member

@gabibalaban thanks for your atention.

 

The source is an Excel table in Onedrive. It contains 3 columns (TAREA,PROYECTO,FECHA)

The table shows the columns (PROYECTO,FECHA)

The dropdowns (drp_tarea, drp_proy) uses the formula Distinct for the columns (TAREA, PROYECTO) 

 

Hi @FGUEVARA again, 

 

gabibalaban_0-1604591038391.png

 

Your formula should be:

Filter(PENDIENTES;PROY = drp_proy.Selected.Result)

 

I'm still confused why in your formula you used PROY, not PROYECTO.

 

Hope it helps !

FGUEVARA
New Member

@gabibalaban 

Finally works, thank you!!!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,886)