I've browsed many many forums looking for a solution but I'm yet to find one.
I look to filter a gallery using the results from a combo box.
I'm having two issues however.
I'm searching a SharePoint list column based on 'Office'.
This means that I have multiple iterations of the same value, I would like to filter this by unique values.
Help would be much appreciated.
Solved! Go to Solution.
Good morning @mdevaney,
If( IsBlank(ComboBox2.Selected.Value), Filter('Apprentice List',StartsWith('Full name',TextInput1.Text)), Filter('Apprentice List','Base Office' in ComboBox2.SelectedItems,StartsWith('Full name',TextInput1.Text)))
Please see the compelted code above.
Your solution has worked.
Thanks a million for your help.
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!