Send Email Action Issue - HTML For Table
I'm working on an email body to be used with the Send Internal Email action and I'm getting nothing on the other end. I am not getting an error in the form; I'm just not receiving the email. Somehow, it did work once when I did not include the lookup field data, but i've not gotten it to work any other time under the same conditions. The two lookup fields are "Managed LLC" and "Payee". I've tried setting these to Key, Value, as well as just the field itself with no change. Can you please tell me what I'm doing incorrectly? Thanks!
Code is below
<p><span style="font-size:18px">MNMS SharePoint</span></p>
<p><span style="font-size:14px">New Deposit Item Created</span></p>
<table border="0" cellpadding="1" cellspacing="1" style="width:500px">
<tbody>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Managed LLC</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[ManagedLLC]]</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Payee</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[Payee]]</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Check Number</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[Title]]</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Status</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[Status]]</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Received From</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[Received From]]</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Check Date</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[Check Date]]</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Amount</strong></span></td>
<td style="width:328px"><span style="font-size:10px">[[Amount]]</span></td>
</tr>
<tr>
<td style="width:159px"> </td>
<td style="width:328px"> </td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Edit Item Link</strong></span></td>
<td style="width:328px"><a href="https://https://REMOVEDFORPRIVACY.com/sites/REMOVEDFORPRIVACY/_layouts/15/start.aspx#/Lists/Deposit%20Log/EditForm.aspx?ID=[[ID]]"><span style="font-size:10px">Click Here to Edit Item</span></a></td>
</tr>
<tr>
<td style="width:159px"> </td>
<td style="width:328px"> </td>
</tr>
<tr>
<td colspan="2" style="width:130px"><span style="font-size:9px">Created by: on </span></td>
</tr>
</tbody>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
-
Hi Dan
I'm quite sure the placeholders with spaces are wrong - like these: [[Received From]], [[Check Date]]. Use the correct internal field names for these.
Use the "Test" button in Expression Builder to check if the email body can be evaluated well and the output is your expected HTML.If you have issues in general with sending/receiving emails (regardless of the email body content) with the Send Internal Email action, make sure the recipient user is known in the current SharePoint site (e.g., used in a PeoplePicker field). You can check if the user exists by checking the hidden User Information List on your site: {yourSiteCollectionUrl}/_catalogs/users
0 -
Thanks for the reply! I must have pasted the wrong code in my initial post, but yes, those field names were correct in the actual action. I've also checked the users as you suggested and see myself who is the recipient on all these test emails. Below is the sanitized Test result from the expression builder. Additionally, i've tried sending from my own email to myself, an O365 group email, as well as no-reply@sharepointonline.com. Anything else I can try?
<p><span style="font-size:18px">MNMS SharePoint</span></p>
<p><span style="font-size:14px">New Deposit Item Created</span></p>
<table border="0" cellpadding="1" cellspacing="1" style="width:500px">
<tbody>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Managed LLC</strong></span></td>
<td style="width:328px"><span style="font-size:10px">XXXXXXX LLC</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Payee</strong></span></td>
<td style="width:328px"><span style="font-size:10px">XXXXXXX Services LLC</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Check Number</strong></span></td>
<td style="width:328px"><span style="font-size:10px">1249</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Status</strong></span></td>
<td style="width:328px"><span style="font-size:10px">Pending Receipt</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Received From</strong></span></td>
<td style="width:328px"><span style="font-size:10px">XXXXXX Boulevard LLC</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Check Date</strong></span></td>
<td style="width:328px"><span style="font-size:10px">11/15/2022</span></td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Amount</strong></span></td>
<td style="width:328px"><span style="font-size:10px">4000</span></td>
</tr>
<tr>
<td style="width:159px"> </td>
<td style="width:328px"> </td>
</tr>
<tr>
<td style="width:159px"><span style="font-size:10px"><strong>Edit Item Link</strong></span></td>
<td style="width:328px"><a href="XXXXXXXXXXX.com/sites/XXXXXXXXXServicesLLC/_layouts/15/start.aspx#/Lists/Deposit%20Log/EditForm.aspx?ID=2"><span style="font-size:10px">Click Here to Edit Item</span></a></td>
</tr>
<tr>
<td style="width:159px"> </td>
<td style="width:328px"> </td>
</tr>
<tr>
<td colspan="2" style="width:130px"><span style="font-size:9px">Created by: on </span></td>
</tr>
</tbody>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>0
Please sign in to leave a comment.
Comments
2 comments