Answered

Many toogle buttons

(0) Share

Report

Posted on by TorbenSBendixen

I am first getting started with Power Apps, and have a question 🙂
If I have several toogle buttons, to show different states of support tickets, how do I show the status for the toogle buttons that are true.

I have this code for one single toggle button, but can't figure out how to do if I want to display the result for two toogle buttons that are true.

If(
Hold.Value=true;Filter('support'; "Hold" in Status.Value);
Started.Value=true;Filter('support'; "Started" in Status.Value);

Closed.Value=true;Filter('support'; "Closed" in Status.Value)
)

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @TorbenSBendixen

Here is a suggestion for your app. The upper left hand corner has a small gallery that contains the choices as the item property (in this case, ["France","Germany","Mexico"]) and a toggle. The formulas for the gallery OnSelect property and the default toggle is below it in red. The principle behind it is that a temporary collection is created when one of the toggles is selected. Items are added or removed from the collection by selecting the toggle for the country. The temporary collection created filters the big gallery to the right.

The big gallery on the right has its items formula above it. It filters the main list by the temporary collection created by selecting the toggles in the small gallery.

Was this reply helpful? Yes No
TorbenSBendixen 16 on at

Like
a
(0)

Report
Copy link

Link copied!

That is a great idea, thank you!

I have made the gallery of "status" like this, in order to get the different values from my sharepoint list:
SortByColumns(Distinct('support';Status.Value);"Result")

That gives me the problem, that I can't get your suggested code to work.
Any idea how to proceed?

Was this reply helpful? Yes No
TorbenSBendixen 16 on at

Like
a
(0)

Report
Copy link

Link copied!

After messing around most of the day, I finally think I figured it out!
Thank you very much for your help!!

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@TorbenSBendixen

For anyone else using Distinct() for the formula for Items in the small gallery. Instead of "Value" if you hard code the choices, you will need to use "Result" in the formulas:

Was this reply helpful? Yes No