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
Solved! Go to Solution.
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
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
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,
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
188 | |
52 | |
51 | |
35 | |
33 |
User | Count |
---|---|
266 | |
97 | |
84 | |
77 | |
73 |