I have a sql table that contains the fields: FileNamePrefix, TableName Then I have files in blob storage that begin with the FileNamePrefix with some datetime in the name:

SQL TABLE:
FileNamePrefix TableName

File1 Table1
File2 Table2
File3 Table3 etc..

Files in blob storage:
File1_20240101.xlsx
File2_20240102.xlsx

I’m using a Lookup Activity to get the records from the SQL table I’m trying to use a Get Metadata activity to see what files are in storage, then do a ForEach only on the files from the lookup that have a corresponding file in storage.

I’ve tried to use the Filter activity with various options, but nothing seems to do what I need.

In the data above, I want to only send the ForEach activity File1/Table1 and File2/Table2 as File3 has no file in storage.