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.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.