Using slider to filter gallery with wildcard

(0) Share

Report

Posted on by ckserra33

421

Hi everyone.

Trying to filter a gallery using a slider. I have 2 of the 3 slider positions working. I am trying to get the position 0 to show everything. Here is the code. Any help would be appreciated! I have tried to use the asterisk as the wildcard but no dice.

Here is my full code for the gallery as well if thats needed.

Thanks!

Chris

Filter(
DropColumns(
SortByColumns(
AddColumns(
Search(
Filter(
AmusementAssets,
(Dropdown8.Selected.Name = "All") || 'Status (cr3db_status)' = Dropdown8.Selected.Name,
(ComboBox1.Selected.Result = "All" || 'Current Store Name' = ComboBox1.Selected.Result)

),
tiGameName.Text,
"cr3db_name"
),
"_calced",
Value(NBV)
),
"_calced",
If(
varNBVSort,
Descending,
Ascending
)
),
"_calced"
),SetForRetirement = If(Slider4.Value = 1,"Yes",If(Slider4.Value = 2, "No",If(Slider4.Value = 0, "*" ))))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@ckserra33

Hi Chris!

Please consider changing your Formula to the following:

Filter( DropColumns( SortByColumns( AddColumns( Search( Filter(AmusementAssets, (Dropdown8.Selected.Name = "All") || 'Status (cr3db_status)' = Dropdown8.Selected.Name, (ComboBox1.Selected.Result = "All" || 'Current Store Name' = ComboBox1.Selected.Result) ), tiGameName.Text, "cr3db_name" ), "_calced", Value(NBV) ), "_calced", If(varNBVSort, Descending, Ascending) ), "_calced" ), SetForRetirement = Switch(Slider4.Value, 1, "Yes", 2, "No", 0, "*" ) )

Now, this is assuming the SetForRetirement has a * in it.

Is that what you are referring to? Or is it that you want all SetForRetirement items to return if it is 0?

If so, then change the formula to:

Filter( DropColumns( SortByColumns( AddColumns( Search( Filter(AmusementAssets, (Dropdown8.Selected.Name = "All") || 'Status (cr3db_status)' = Dropdown8.Selected.Name, (ComboBox1.Selected.Result = "All" || 'Current Store Name' = ComboBox1.Selected.Result) ), tiGameName.Text, "cr3db_name" ), "_calced", Value(NBV) ), "_calced", If(varNBVSort, Descending, Ascending) ), "_calced" ), Slider4.Value = 0 || SetForRetirement = Switch(Slider4.Value, 1, "Yes", 2, "No" ) )

I hope this is helpful for you.

Was this reply helpful? Yes No
ckserra33 421 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes That works perfectly!! The only text in the column is "Yes" and "No", I was unsuccessfully trying to use the * as a Wildcard, and show all rows where there was text in that column. Your method is much cleaner! What is the best way to add another slider with the same elements to it? I have an Archived column that contains Yes and No as well, do I add an additional Filter on the front of the entire formula?

Thanks again, enjoy your coffees!

Chris

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ckserra33

Thanks for the coffee!! (as I take a sip of it right now!)

You can incorporate the archived into the same formula in the same place.

Ex:

Filter( DropColumns( SortByColumns( AddColumns( Search( Filter(AmusementAssets, (Dropdown8.Selected.Name = "All") || 'Status (cr3db_status)' = Dropdown8.Selected.Name, (ComboBox1.Selected.Result = "All" || 'Current Store Name' = ComboBox1.Selected.Result) ), tiGameName.Text, "cr3db_name" ), "_calced", Value(NBV) ), "_calced", If(varNBVSort, Descending, Ascending) ), "_calced" ), Slider4.Value = 0 || SetForRetirement = Switch(Slider4.Value, 1, "Yes", 2, "No" ), SliderX.Value = 0 || Archived = Switch(SliderX.Value, 1, "Yes", 2, "No") )

In the above sliderX is the new slider.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ckserra33

In the OnVisible of the screen: Set(varslider,"All")

In the Slider properties:

Min: 0, Max: 2, Default:0 OnChange: If( Slider1.Value = 1, Set(varslider,"Yes"), Slider1.Value = 2, Set(varslider,"No"), Slider1.Value = 0, Set(varslider,"All") // accounts for user changing selection ) // from 0 to another value then back again

Tidying up the gallery Items property:

With({aa:Filter(AmusementAssets, Or(Dropdown8.Selected.Name = "All", 'Status (cr3db_status)' = Dropdown8.Selected.Name ) && Or(ComboBox1.Selected.Result = "All", 'Current Store Name' = ComboBox1.Selected.Result ) && Or(varslider = "All", SetForRetirement=varslider ) )}, Filter( SortByColumns( AddColumns( Search(aa, tiGameName.Text, "cr3db_name" ), "_calced", Value(NBV) ), "_calced", If(varNBVSort,Descending,Ascending) ) ) )

Was this reply helpful? Yes No