Filter table by dropdown.

(0) Share

Report

Posted on by MarcoGouveia

Hey, guys. I'm trying to filter a table by two conditions (dropdown lists) BUT I can't even set one condition!

The formula I'm trying:

Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Value)

It's not working and I stil need to filter with the second dropdow...

Hope you guys can help me.

There is a screenshot attached.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Usually, this should be working except if the dropdown is Distinct, in that case:
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Result)
With the second dropdown
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Result&&Dropdown3.Selected.Result)

OR
Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.Selected.Result&&Dropdown3.Selected.Value)

Was this reply helpful? Yes No
MarcoGouveia 23 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you very much for replying!!

I tryide the alternative formula and still had no result.

But thank you again anyway!

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Is it possible to show the formula in both dropdowns, A screenshot will help

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MarcoGouveia

What is the data type you're using to fill the dropdowns?

Have you tried:

Filter(CeF_Fmto_Ftas; CeF_Fmto_Ftas_Cliente = Dropdown2.SelectedText.Value)

Was this reply helpful? Yes No
MarcoGouveia 23 on at

Like
a
(0)

Report
Copy link

Link copied!

That workd!

You guys have an reference where I can learn the diferences between "SelectedText" "Selected.Value" "Selected.Id" and so on??

Was this reply helpful? Yes No
MarcoGouveia 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the tip about the sec dropdown!

Was this reply helpful? Yes No