cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
meddlema
Helper I
Helper I

HTML Table with Send an eMail V2

Hello, 

 

I have a couple of Power Apps forms that collects information and when the user clicks the submit button it sends an email to the required people (it is not posted to SharePoint or anywhere else) and the body of the email has a formatted HTML table with the data.  I was able to successfully setup this up using Send an Email action and having it collect the data from the form.  The form has the To, CC and Body.  I used an HTML text box in the form that his hidden that has the data and html format. 

 

Screenshot of the submit button on the form 

Submit Button Format.png

 

and the flow is set to Ask in Powerapps (HTML is set to Yes)

New Hire Flow.png

and the output of the email body is formatted the way it should. 

 

With that said, my issue is in using the action Send an Email V2

 

They data is collected into the email but the HTML formatting is gone.  (ignore the /td> I can fix that)  

I am not sure how to collect and format the data now with Send an Email V2.

 

Term Email.png

 

Any help will be greatly appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User III
Super User III

@meddleam
I have two suggestions:

First, create a label in your PowerApps and put the code HtmlText1.HtmlText in the Text property. Does it show the expected HTML text? Perfect, if yes move on to suggestion #2.

In your Flow initialize a variable and set it to the the value of the HTMLText piece with a type String. Run the code and check that it comes in properly.

Also, it would likely help if you shared some of your HTML code. Let me know.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

2 REPLIES 2
mdevaney
Super User III
Super User III

@meddleam
I have two suggestions:

First, create a label in your PowerApps and put the code HtmlText1.HtmlText in the Text property. Does it show the expected HTML text? Perfect, if yes move on to suggestion #2.

In your Flow initialize a variable and set it to the the value of the HTMLText piece with a type String. Run the code and check that it comes in properly.

Also, it would likely help if you shared some of your HTML code. Let me know.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

Apologies for the delay in response!   The HTML was incorrect.   I fixed that everything is working.  Thank you for the assist!!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (31,659)