Answered

Start an email from a Sharepoint list item that is populated with ticket details without sending it

(0) Share

Report

Posted on by Community Power Pla...

I want to press a button in a Sharepoint List that populates an email template with details of the selected line item without sending it. Similar to this thread, but the email address is prefilled with the request submitter's email and a field in the body of the message & the signature is prefilled with the assignee's name.

@Expiscornovus , would you be able to help me with this?

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

I was able to solve this issue by editing the JSON of the email button. I had to pay special care to what the metadata file name is of columns that have special characters (#, . , etc)

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

here's the JSON I used. Hopefully someone will find it helpful:

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"children": [
{
"elmType": "span",
"style": {
"padding-right": "8px"
},
"txtContent": "@currentField.title"
},
{
"elmType": "a",
"style": {
"text-decoration": "none"
},
"attributes": {
"iconName": "Mail",
"class": "sp-field-quickActions",
"href": {
"operator": "+",
"operands": [
"mailto:",
"@currentField.email",
"?subject=Your Ops Request Ticket: ",
"[$Title]",
"&body= Your Ops Ticket No. is: ",
"[$TicketNo_x002e_]",
"\r\n\r\nTitle: ",
"[$Title]",
"\r\n\r\nYour Customer Ops Assignee: ",
"[$OpsOwner.title]",
"\r\n\r\nRequest Description: ",
"[$RequestDescription]",
"[$TicketNumber]",
"\r\n---\r\nClick this link for more Ops Request documentation. https://yourtenant.sharepoint.com/sites/yourlink"
]
}
}
}
]
}

Was this reply helpful? Yes No