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.
Check out new user group experience and if you are a leader please create your group
Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.