How to return only 1 of like items from data source to browse gallery

[awalker]

I have a data source (collection) that has multiple market sectors in a state, multiple customers in a market sector and multiple records (contacts, login credentials, devices, etc) for each unique customer. I'm trying to return all customers in a state and market sector but only one instance of each unique customer.

The user can then select a customer and see the the various records for that specific customer in another browse gallery.

I am having trouble with the filter script. Any suggestions?

Greetings

[WarrenBelz · Accepted solution]

Hi @awalker ,

You did not supply any code, but the GroupBy() function is what you need.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[awalker]

Good Evening Mr Belz

That's what was needed - thank you! I had no clue where to even begin and therefore could not find much online that was addressing my problem. Now that I have the function I can learn how make it work with my browse galleries and edit forms. The microsoft documentation is clear as mud, but here is a youtube video that was a very helpful jumpstart into using GroupBy()

https://youtu.be/70tEP0ZAmsM

Thanks again for your help, Mr Belz. Always glad when you are responding to my questions.