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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

panand99 641 on at

Like (0)

Report
Copy link

Link copied!

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)))

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

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
markus_poeschl 34 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
Verified answer

markus_poeschl 34 on at

Like (1)

Report
Copy link

Link copied!

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 !

Was this reply helpful? Yes No