Filtering a dropdown with a toggle

[ckserra]

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

[PowerAddict]

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. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[ckserra]

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

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?

[ckserra]

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