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 the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.