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.
Filtering by multiple selections at a time gets a lot more complex. Now you'll have to pull the selected offices into a local collection and do a Search (rather than a Filter) to see if a record is 'in' the collection.
One more thing. I'm still yet to bring distinct/unique values to the combo box. It's a single-text column as originally thought.
FYI, you can make more than one post the solution if you wish. I think @Pstork1 deserves credit for at least 50% of the problem solving here
Actually, I was hoping you could show me what happens when you type up to this point in the function and see what the automcomplete suggests
Distinct('Apprentice List','Base Office'.
I've just created a collection in my combo box as earlier suggested.
If you could help me with one last thing that would be golden!
Currently if no items are selected, the gallery returns blank. Do you know a fix to this?
You could do something like this. If IsBlank does not work try IsEmpty.
If( IsBlank(ComboBox.Selected.Value), your_code_to_filter_combobox_here )
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.