cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ppl
Post Patron
Post Patron

Send a table from PowerApps to email

Hello.

I have a flow, triggered with PowerApps button.

ppl_5-1616316659529.png

 


 

In details there is a dynamic content which I am getting from PowerApps and I get it with function Concat

ppl_1-1616313121501.png

 


As a result I recieve an email with body:

ppl_4-1616315377393.png

 


How can I change it to table like this?

ppl_3-1616315147089.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

@ppl ,

@rubin_boer has a good point - this should insert it in the body of the email

"<table>
   <tr>
       <td><b>Article</b></td>
       <td><b>Title</b></td>
       <td><b>Price per one</b></td>
       <td><b>Qty</b></td>
       <td><b>Total price</b></td>
   </tr>" & 
Concat(
   YourCollection,
   "<tr>
       <td>"&Article&"</td>
       <td>"&Title&"</td>
       <td>"&'Price per one'&"</td>
       <td>"&Qty&"</td>
       <td>"&'Total price'&"</td>
   </tr>"
) &
"</Table>"

View solution in original post

5 REPLIES 5
rubin_boer
Super User
Super User

hi @ppl 

have a look at this https://powerusers.microsoft.com/t5/Building-Power-Apps/send-Gallery-List-via-email-through-powerapp... or you can add a table in flow, Ryan Maclean has a great blog on it, here: https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/

 

Hope it helps

Ps simply curious, any reason why you opt not do the logic in power apps?

 
WarrenBelz
Super User
Super User

@ppl ,

@rubin_boer has a good point - this should insert it in the body of the email

"<table>
   <tr>
       <td><b>Article</b></td>
       <td><b>Title</b></td>
       <td><b>Price per one</b></td>
       <td><b>Qty</b></td>
       <td><b>Total price</b></td>
   </tr>" & 
Concat(
   YourCollection,
   "<tr>
       <td>"&Article&"</td>
       <td>"&Title&"</td>
       <td>"&'Price per one'&"</td>
       <td>"&Qty&"</td>
       <td>"&'Total price'&"</td>
   </tr>"
) &
"</Table>"

@WarrenBelz @rubin_boer 

Thank you!

Its ok in simple email in my flow,

ppl_0-1616332232629.png

but in Approval email I am seeing html code.

ppl_1-1616332477854.png

 

 

 

rubin_boer
Super User
Super User

hi @ppl can you please post your flow. i assume you do have a Create HTML table in it?

 

@rubin_boer 

ppl_0-1616362751217.png

In Send email step I see correct table. And in Approval there is html code.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (4,110)