Power Platform Community Forum Thread Details

I am trying to use Power automate / Flow, in a similar manner to mailmerge.

I have a generic email body, with one body content field which differs per customer. (The To email, and subject lines would vary depending on the customer details in each excel row).

I have an excel file on OneDrive I want to connect to, with many lines, each with different emails, customer ref, and amount.

I have tried to do it 2 ways

- from excel, got the add-in, then built the flow, however it will not give me an option to "run"

- from Power Automate, create new, Manually trigger a flow, Send an email V2, add the generaic text and specify the fields, however it will only send to one email (which is mine, as a test). I think its to do with the Key Column and Key Value. I have included one column called "Key", and all rows include the value of "key" to get round this.

However it is not working.

What am I missing?

Can you help?

I viewed some videos that said I could use Flow, similar to Word mailmerge, but its not working and I dont want to use one of the Mailchimps!

Thank you

Categories:

General topics