I have a sharepoint list with a Choice-column called "Practice" it has 11 different choices. I wish to filter a gallery based on the choices, but I would like to use a combobox to choose different "Practices" and sometimes more than one:
I have found the IsMatch() function. However, I am experiencing some issues with the function. I can write the below formula:
Practice.Value = IsMatch(cbPracticeFilter.Selected.Value, "",Contains)
But ideally, what I want is to filter so that ALL the choosen from cbPracticeFilter (the combobox) should be matched towards the Practice.Value.
How do I do that? Is there another way to do this in an easier way?
Solved! Go to Solution.
This works for a single selection in a combobox, but if multiselect is turned on and multiple are select it only returns results for the last selection, not all selections.
Any further help, I figure it would need a ForAll or something to loop through all the selections of the combobox.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
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.