Microsoft Dynamics 365 Overview

Question

Hello,

maybe someone can help me. I have a SharePoint column and a JSON code stored here. But I want that in the email not only at Subject: the Title is but also the start date (so another column "Start"). Unfortunately I can't get it to work. Thank you!

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "span",
      "style": {
        "padding-right": "20px"
      },
      "txtContent": "@currentField.title"
    },
    {
      "elmType": "a",
      "attributes": {
        "iconName": "Mail",
        "class": "sp-field-quickActions",
        "href": {
          "operator": "+",
          "operands": [
            "mailto:",
            "[$Attendees.email]",
            "?Bcc=xxxx.com",
            "[$BCC]",
            "&subject=",
            "[$Title]",
            "&body=",
            "Dear XXX,",
            "\r\n \r\n",

          ]
        }
      }
    }
  ]
}

Answer 1

To involve Start column in the email subject, you should first convert date value in the Start column into text value.

1.Create a calculated column named Startdate with below formula.

=TEXT([Start],"YYYY-MM-DD")

2.Using JSON codes to involve Start column in the email subject

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "children": [
    {
      "elmType": "span",
      "style": {
        "padding-right": "20px"
      },
      "txtContent": "@currentField.title"
    },
    {
      "elmType": "a",
      "attributes": {
        "iconName": "Mail",
        "class": "sp-field-quickActions",
        "href": {
          "operator": "+",
          "operands": [
            "mailto:",
            "[$Attendees.email]",
            "?Bcc=xxxx.com",
            "[$BCC]",
            "&subject=",
            "[$Title]",
            ",",
            "[$Startdate]",
            "&body=",
            "Dear XXX,",
            "\r\n \r\n"
          ]
        }
      }
    }
  ]
}

3.Result:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.