Hi all,
How are you?
I would like to find an efficient way to filter a datasource in function of a combobox. This combobox has sever options: A, B, C, ... and All. If I choose All, I don't want to apply the filter. I have thought of using the following trick:
Filter(Datasource, If(Combobox.Selected.Value = "All",1=1,Column = Combobox.Selected.Value))
Is there any way to achieve this?
Thank you in advance.
Best regards,
Fernando
Solved! Go to Solution.
Hi @fernandocxv
check my video on this
https://www.youtube.com/watch?v=pn50AKn3Q1Y
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 @fernandocxv
check my video on this
https://www.youtube.com/watch?v=pn50AKn3Q1Y
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 @fernandocxv ,
Could you please share a bit more about your issue?
Is there some error message with your Filter formula?
Further, could you please share a bit more about the column (filter column) you used in your Filter formula? Is it a Single text type column or Choice type column?
Based on the formula you provided, I could not find any syntax error with it. Please consider modify your formula as below:
Filter(
Datasource,
If(
Combobox.Selected.Value = "All",
true,
Column = Combobox.Selected.Value
)
)
If the filtered Column you used in your Filter formula is a Choice type column, please consider modify your formula as below:
Filter( Datasource, If( Combobox.Selected.Value = "All", true, Column.Value = Combobox.Selected.Value ) )
Best regards,
There is no issue, I just was looking for a way in which I avoid using 1=1 in my code. As I can see, it is better solution to use true.
Thank you @v-xida-msft!
Best regards,
Fernando
User | Count |
---|---|
229 | |
102 | |
97 | |
57 | |
32 |
User | Count |
---|---|
282 | |
112 | |
106 | |
63 | |
63 |