Filter Table with multiple dropdown

[FGUEVARA]

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

[gabibalaban]

Hi @FGUEVARA 

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

[FGUEVARA]

@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) 

[gabibalaban · Accepted solution]

Hi @FGUEVARA again, 

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]

@gabibalaban 

Finally works, thank you!!!