Unanswered

Filtering a dropdown with a toggle

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone. I am really struggling filtering a dropdown with a toggle. This is the code I am using on a gallery and its working correctly.

'If(varUser.Mail = "zzz@zzz.com",SortByColumns(Filter(Game_view_powerappss,StoreID= 165),If(Toggle4_1.Value,"cr3db_seqorder","cr3db_gamenameandmodifier"),Ascending)'

I am missing a step in using that code in a dropdown. Any help would be amazing, thank you!

Chris

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I am not sure I understand your question. Are you saying you want to use the same formula in the Items property of a toggle? Or something else?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube | Email
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@PowerAddict Hi and thank you for your quick reply. When I use that code in a drop down, I am showing no data in The drop down, but no errors. I would like it to show the column gamenameandmodifier, but sort it alphabetically when the toggle is in one position and seqorder when the toggle is in the other position. It’s working correctly on the gallery but I cannot get the drop-down to show any information.
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Do you actually see records in the dropdown but with no labels or does the dropdown not have any records when you try to expand it?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PowerAddict . I deleted my dropdown and inserted a new one using the same code, and I am now seeing items in the list. The list is now working alphabetically, but when I try sequentially, it appears to be random. The seqorder column is a whole number column, and like I said before, works in the gallery.
Thanks again!
Chris