
Announcements
I am looking to create a mail merge flow that sends an email to each individual in a excel spreadsheet and then sends two unique attachments to the individual.
I have attached a picture of what the excel spreadsheet looks like. Essentially, there is a column in the spreadsheet called Award sent. The default value for this column is no, if this is the case the flow will send an email with the users email address and cc their manager into the email. The content of the email is dependent on the value in the accreditation completed field.
i.e If the user achieved bronze a unique attachment stored in SharePoint will be added to that email and sent off, once sent off the the award sent column is updated with yes for the relevant user.
The name of the attachment is the ID the accreditation completed and then either B or C for banner or certificate.
i.e 1bronzeB.jpg
Is this possible/how can this be achieved. I have seen others do this with OneDrive but have yet to come across someone doing this via SharePoint.