Hi E.J.,

In this case I’d create a flow part to manually check for duplicates. The output will show all unique items

First create a data-item for the unique items ‘CompanyUnique’.

Then add a new flow part with the companies as input.

Add a repeat action based on the companies in your input.

In the repeat action itself: create a lookup to filter current company in CompanyUnique.

if CompanyUnique is empty, add the current company and end the repeat action

if CompanyUnique is not empty? do nothing and end the repeat action

after your repeat action perform a clean up by deleting all data from the Unique data-item (else the next time you do it it still contains the old values)

Select the “Add data-item” from the repeat action as an output, which will contain all the items you just added.