Hi @PA-Jimmy ,
I made a sample for you.
There are the following files in the library, and there is a column of text that is the email address to which the file is sent.
Create a flow, and I will explain it step by step.
Gets the properties of the files in the library.
Select column ‘email address’ data.
Create an array and save only one email address for the same email address.
union(body(‘Select’),body(‘Select’))
Create an empty array.
Add 'Apply to each' to get the properties of the files in the library and filter the same data as the current email address.
Items(‘Apply to each’)?[‘Email’]
Based on the results of the ‘Filter array’, create another 'Apply to each'. Get the file contents based on the path.
items('Apply_to_each_2')['{FullPath}']
Append the following to the empty array.
{"Name": items('Apply_to_each_2')['{FilenameWithExtension}'],
"ContentBytes": body('Get_file_content_using_path')}
Send email with array 'varFile' attached. Finally, set the array to empty.
Items(‘Apply_to_each’)?[‘Email’]
Save flow and run it.
Best Regards,
Wearsky
