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,
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
207 | |
187 | |
83 | |
52 | |
37 |
User | Count |
---|---|
288 | |
245 | |
119 | |
77 | |
56 |