How to check if there are duplicates in a list of strings?

Help
14

Hi @Madhavi
What I try to do is if a new entry of username in the new row is duplicated to the other row in column “username”, Then send an email to user to change, Else continue to another task.

I checked the filter datatable activity, but it seems only output “filtered DataTable variable”, not a boolean as I need.

So I tried the first suggestion from you, but not sure what are “x” and “g” for
dt.AsEnumerable().Select(function(x) x.Field(of String)(“username”)).GroupBy(function(x) x).Where(function(g) g.Count() > 1).ToList().Count
But got error Option Strict On not allow from ‘Integer’ to ‘Boolean’…

Thanks for your help.

1 Like