Help with filter

[fernandocxv]

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

[RezaDorrani · Accepted 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

[v-xida-msft]

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,

[fernandocxv]

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