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
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 |
---|---|
198 | |
171 | |
60 | |
32 | |
31 |
User | Count |
---|---|
337 | |
270 | |
104 | |
72 | |
56 |