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
Solved! Go to 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 !
Hi @FGUEVARA
Is PROY column a choice type in sharepoint ? What is the formula for items of drp_proy ?
@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,
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 !
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
72 | |
50 | |
42 | |
30 |
User | Count |
---|---|
266 | |
121 | |
94 | |
90 | |
81 |