Answered

Help in a dropdown filter

Like (0) Share

Report

Posted on 19 Aug 2019 20:24:46 by Community Power Pla...

Hello again.

I am trying to make the filters independent of each other, when in one select "-none-" that only appear filtered with a single dropdown, in this case they have to be related to the 2 to show the search, otherwise it will not show anything

Categories:

General Questions

All responses (2)

Answers (1)

v-xida-msft on 20 Aug 2019 at 09:48:13

Like (1)

Report
Re: Help in a dropdown filter

Hi @Anonymous ,

I have made a test on my side, please consider take a try to modify your formula as below (set the Items property of the Gallery to following😞

GroupBy( Filter( OrdenesAbiertas2, If( Dropdown1.SelectedText.Value = "-none-", true, Dropdown1.SelectedText.Value in CLIENTE ), If( Dropdown3.SelectedText.Value = "-none-", true, Dropdown3.SelectedText.Value in VENDEDOR ), TextSearchBox1.Text in 'OC CLIENTE' ), "OC_x0020_CLIENTE", "Ordendeventa" )

Please take a try with above solution, check if the issue is solved.

Best regards,
Verified answer

RezaDorrani 12,141 on 19 Aug 2019 at 21:35:44

Like (0)

Report

Re: Help in a dropdown filter

HI @Anonymous

I am assuming you need a condition where is None is selected then avoid that filter
If this is the case then use the following :

GroupBy(
Filter(
OrdenesAbiertas2,
(Dropdown1.SelectedText.Value in CLIENTE || If(
Dropdown1.SelectedText.Value = "-none-",
true,
false
)),(Dropdown3.SelectedText.Value in VENDEDOR || If(
Dropdown3.SelectedText.Value = "-none-",
true,
false
)),TextSearchBox1.Text in 'OC CLIENTE'
),
"OC_x0020_CLIENTE","Ordendeventa"
)

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly