Send an email (V2) with dynamic content for email body from html file

[kedarsk]

Hello friends,

I am building the flow that automatically sends out email invitations to all my recipients for our webinar or events series.  I have the list of email ids in an excel table and everything is well connected.  In fact I tried to sent out the test email with contents and that worked well as desired.

Now the issue is what if I have several different events and webinars invitations formatted in a HTML file.  Here, I manually need to edit the body of the flow and then run it.

Is there any way that I can rather get the HTML code from the file stored on my onedrive e.g. Let's say that the invitation-A.html and invitation-B.html has the actual invitation formatted in HTML.

So I want to insert the html code from above mentioned files to the body field of Send an email (V2).

Is  the above possible?  Any help for this will be much appreciated.

Thank you

[Jcook · Accepted solution]

Hello @kedarsk 

Can you try:

Please note, that not all HTML code is acceptable through email.

[Jcook · Accepted solution]

@kedarsk

Did you have a chance to try my solution.

[kedarsk]

@Jcook  Apologies for the delayed reply.  

Yes, indeed the solution worked.  I also need further support from you.  Appreciate if we can connect directly.  kedarsk@hotmail.com is my email id.

Thank you

Kedar

[mjfigg123]

Hello there, 

I am also using this solution and it works well. However I would like to be able to pass a variable reference into my email. 

That is, I will include a "@{variables('firstname')} in my html text. However when I run the flow it does not resolve to the variable reference and assumes t is just text within the html. any idea on how to resolve this?

Thanks,

MJ

[mjfigg123]

Actually just managed to solve my own issue!.. 

I used replace() to identify where I had a dynamic variable within my HTML and replace it with the desired value and then set a new variable with my html. It works great.