I've been tasked with creating a flow that will send an email to all our staff with custom attachments.
A typical attachment would be in this format: "John.Smith-123456789.PDF" (FirstName.LastName-EmployeeNumber)
As we have approximately 1500 staff there are cases where we have duplicate names so simply cannot extract the name from the file and match it to a username.
I had a theory that if we have a list of All names, email addresses and employee numbers we could then match the employee number in the filename against the one in the list and send an email to the email address associated with the employee number attaching the PDF file.
What is the best way of doing this as I dont yet have the PDF files.
This is how my current flow looks.