Flow Designer - How to get unique records from "Look Up Records" action

[Jonathan Monks]

I'm trying to use Flow Designer to get some a list of unique records from a table, then pass them into a Send Email action.

I'm just wondering if I have to write a script to achieve this or if there is something I'm missing that might make it easier.

The table build up is similar to the following:

Name	Email	Type	Location
Joe	joe@email.com	Primary	Site A
Billy	billy@email.com	Primary	Site A
Joe	joe@email.com	Primary	Site B
Billy	billy@email.com	Secondary	Site B

Obviously there are some duplicate email addresses here. If the email exists twice, I only want to grab one version of it.

[Ankur Bawiskar · Accepted solution]

Hi,

there is nothing in Look Up Records OOB to get unique values

you might have to use custom script for this

Regards
Ankur

[Jonathan Monks]

Thank you Ankur, I thought that might be the case.

Appreciate the help!

[Adam Peterson]

Did you figure out a solution for this? Looking for something similar. 

[ysrivast77]

https://www.servicenow.com/community/developer-forum/get-unique-records-excluding-duplicates-flow-de...