compare file names in document library (a@123.com; b@123.com ..) with email list in Sharepoint list( a@123.com;b@123.com;c@123.com) to find which email address is not exist in the document library and send a mail to the email address. Thanks

[GGG666]

Dear All,

I would like to compare file names in document library (a@123.com; b@123.com ..)  with email list in Sharepoint list( a@123.com;b@123.com;c@123.com) to find which email address is not exist in the document library and send a mail to the email address. Thanks

[DamoBird365]

Hi @GGG666 

You are describing an except, which can be performed with a filter array.

Take a look at the examples here Efficient Union, Except And Intersect – Great Method - DamoBird365

Damien