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.
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?
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications