Sending an email with Dynamic Content for each Unique Vendor in an Excel file
I had a problem on customizing "Send an Email Action". I do not know how to insert unique vendor name from an excel column.
This is how my excel table looks like
I have successfully created a flow that send only one mail to each unique email address and create an html table.
Now, I want to customize the email sent that it changes also the Vendor name but the problem is I had also multiple vendor name which i need to get only the unique one.
This is the sample of created email sent. I want to include the name of vendor in the highlighted area, which changes depending to whom the email was sent. For this sample it should be "Hi, Sir. John".