I have received much help over the last week and I am very nearly there.
I have managed to add 2 dropdown menus (I may add more) and with help, I have Added the ability to select all but, when I select an option from 1 column and leave the other as All, I am not getting any information.
For example, I want to search for ALL Open tickets. If I select Open and leave the other as All. Nothing appears. If I select Open and People, I get the 1 option currently available.
I have enclosed images of what I am currently seeing.
Solved! Go to Solution.
What I mean is, in your current gallery that lists your SharePoint list items, you have what looks like the Status field as a column.
Could you add the Category field there as well, just so we can verify the information in that field?
Oh, sorry, I didn't realize the field was already visible as a column in your gallery.
You should be able to get what you want by changing the Items property for your Gallery control to the below expression:
If( StatusDropdown.SelectedText.Value="All", NewNCR, If( CategoryDropdown.SelectedText.Value="All", Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value), Filter(NewNCR, Status.Value = StatusDropdown.SelectedText.Value && Category.Value = CategoryDropdown.SelectedText.Value) ) )
Did this post solve your problem? Please click Accept as Solution so that others may find it more quickly.
If you liked my response, please give it a Thumbs Up.
Do you want to hear more from me? Visit my blog Marble's Power Corner.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.