Sending an email with Dynamic Content for each Unique Vendor in an Excel file

[hdonato]

Hi,

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". 

Attaching also the workflow i made.

Thank you so much!

[RossB]

Hello,

Would it be possible to add some logic so that it just says 'Hi, Sir.' if the values are not the same?  You could also use the vendor that is listed the most for the email address.