Filter/Update Gallery by Button

(0) Share

Report

Posted on by markus_poeschl

Hi all,

I´m almost done with my first app, but am struggling with one last thing:

i have a gallery in the main-screen using this:

SortByColumns(Filter(Antrag, StartsWith(Familienname, SucheFeld1.Text)), "Title", If(SortDescending1, Descending, Ascending))

near to the gallery i have an icon for Ascend/Descend - Sorting, thats works fine. Also searching for the Name via an input field.

What i now need (the last feature) is using a radio-button for filtering this gallery using a boolean-Field in the

data-source named "NeuErstellt" .. so when i toggle the button only those with "true" are shown, untoggled ALL items should be shown.

I tried fiddling around with "updatecontext()" but did not come to a conclusion.

maybe somebody can help me with a short "push" ?

Kind regards,

Markus

Categories:

General Questions

All responses (4)

Answers (1)

Verified answer

markus_poeschl 34 on at

Like (1)

Report

Re: Filter/Update Gallery by Button

i figured it out now. Here´s my solution:

------------
If (Checker1 = 1, (SortByColumns(
Filter(
Filter(Antrag, StartsWith(Familienname, SucheFeld1.Text)),
If(Checker1 = 1, NeuErstellt<>true, false)
),
"Title",
If(SortDescending1, Descending, Ascending))),

SortByColumns(Filter(Antrag, StartsWith(Familienname, SucheFeld1.Text)), "Title", If(SortDescending1, Descending, Ascending)))

------------

So thank you all for the "pushes" in the right direction !
markus_poeschl 34 on at

Like (0)

Report

Re: Filter/Update Gallery by Button

Dear panand,

thank you , i understand you concept, but when this formula is implemented i adopted it to:

>> Checkbox1 is Oncheck = "UpdateContext({Check1:true})" and "false" on OnUncheck ...<<

If(Check1=true,
SortByColumns(Filter(Antrag, NeuErstellt=true && StartsWith(Familienname, SucheFeld1.Text)), "Title", If(SortDescending1, Descending, Ascending)),
SortByColumns(Filter(Antrag, StartsWith(Familienname, SucheFeld1.Text)), "Title", If(SortDescending1, Descending, Ascending)))

But now neither the filter itself, nor the textsearch or the sorting work anymore ..

Kind regards,
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report

Re: Filter/Update Gallery by Button

@markus_poeschlif your source is SharePoint, be aware that there is currently a bug on boolean fields.
I have found the workaround for the time being to set my condition to the opposite.

So an potential formula for you is something like this:
SortByColumns(
Filter(
   Filter(Antrag, StartsWith(Familienname, SucheFeld1.Text)),
   If(Radio1.Selected.Value = "Your Value", NeuErstellt<>false, true)
   ),
  "Title",
   If(SortDescending1, Descending, Ascending))

Note, this is a filter of a filter - perfectly legitimate, but you could also possibly combine the statement. I put it out in two to show a little clarity of what is going on based on your condition.
panand99 641 on at

Like (0)

Report

Re: Filter/Update Gallery by Button

You can use like this :

if(radio1.selected.value="YourValue",
SortByColumns(Filter(Antrag, NeuErstellt=true && StartsWith(Familienname, SucheFeld1.Text)), "Title", If(SortDescending1, Descending, Ascending)),
SortByColumns(Filter(Antrag, StartsWith(Familienname, SucheFeld1.Text)), "Title", If(SortDescending1, Descending, Ascending)))