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 = "email@example.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!
Hi @ckserra ,
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.
Microsoft Business Applications MVP
Microsoft Certified Trainer MCT
@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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.