JSON-Code (multiple "$Attendees.email")

Question

JSON-Code (multiple "$Attendees.email")

Martin, Heidi (SE GP T SP PS) 571

Good morning,

I have a JSON-Code for a SharePoint column. The code works fine, but if there are multiple "[$Attendees.email]" then unfortunately this code stops working.

Tested with 6 "[$Attendees.email]" it worked fine. But I also have more than 6 "[$Attendees.email]", there it didn't work anymore.

Is it possible to customize the code so that many email recipients work?

Thank you!

This is the code snippet:

{
  "$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=XXX,
            "[$BCC]",
            "&subject= Event name: ",
            "[$Title]",
            " | Event date: ",
            "[$Startdate]",
            "&body=",
            "Dear XXX,",
            "\r\n \r\n",
....

Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-09T06:39:49.32+00:00

No ideas?
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-09T07:59:26.8666667+00:00

Hi, we are currently doing some research on this issue, will let you know as soon as possible.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-09T08:01:44.2566667+00:00

Thank you so much!

Accepted answer

4 additional answers

Your answer

Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-09T06:39:49.32+00:00

No ideas?
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-09T07:59:26.8666667+00:00

Hi, we are currently doing some research on this issue, will let you know as soon as possible.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-09T08:01:44.2566667+00:00

Thank you so much!

Answer 1

Hi @Martin, Heidi (SE GP T SP PS) ,

First of all, the Q&A forum is an open platform, please pay attention to protecting private information.

According to my research and testing, there should be no such limitation. My tests have also proven this to be the case. Can you describe specifically how it behaves with more than 12 recipients?

This is the JSON code I used for testing:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "style": {
    "display": "=if(length([$Atendees]) > 0, 'flex', 'none')",
    "text-decoration": "none"
  },
  "attributes": {
    "href": {
      "operator": "+",
      "operands": [
        "mailto:",
        "=join([$Atendees.email], ';')",
        "?Bcc=",
        "[$BCC.email]",
        "&subject=Event name: ",
        "[$Title]",
        "&body=Dear XXX,",
        "\r\n \r\n",
        "As you probably know, we have created the GT-wide overview for the handling the relevant external events, conferences, and trade shows: https://xxx",
        "\r\n",
        "The target is to have the single tool for all relevant events for SE GT to reach transparency, coordinate performance, use the synergies, and evaluate the efforts for the future.",
        "\r\n",
        "\r\n",
        "Furthermore, we want to learn from events where we have participated to evaluate our performance, and to learn for the participation in further events. For this purpose we have created the event feedback sheet: https://xxx, which you also can find in the above tool bar as per screenshot below.",
        "\r\n",
        "I kindly ask you to take approx. 9 Min. time and fill in this event to support us. As per our notes, you’ve participated in: ",
        "\r\n",
        "Furthermore, we store all conference proceedings (papers, publications, presentations, etc.) in: https://xxx to allow access for all GT staff.",
        "\r\n",
        "In case you as participant have got access to these documentation, please provide it to me for the uploading.",
        "\r\n \r\n",
        "Appreciating your support with kind regards,",
        "\r\n \r\n"
      ]
    }
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "Mail"
      }
    },
    {
      "elmType": "span",
      "txtContent": {
        "operator": "+",
        "operands": [
          "Send email to ",
          {
            "operator": "?",
            "operands": [
              "=length([$Atendees]) == 1",
              "[$Atendees.title]",
              "='all ' + length([$Atendees]) + ' members'"
            ]
          }
        ]
      }
    }
  ]
}

In this code, I removed ******@XXXX.com and

" | Event date: ",
        "[$Startdate]",

Because of adding these, the code doesn't work properly. I don't know if your problem has anything to do with these. Here is the result, it works fine:

User's image

08111

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.

Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-11T07:29:48.84+00:00

Dear @Yanli Jiang - MSFT

That was by mistake. Thank you for pointing it out.

I have tested it now and it works for all but not for the 12 attendees. If I delete the links in the email text then it works. What could be the reason for this?
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-09-14T08:58:00.8333333+00:00

Hello @Yanli Jiang - MSFT,

Is it possible to insert the link to the event element in the above code?

At the moment only the event name appears here. But it would be great if you could put the link to this event element here.

Thank you so much
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-09-15T02:56:19.7733333+00:00

Hi Heidi ,

Do you mean adding a hyperlink? Or do you want this part of the content to be displayed dynamically? Because your needs are different from the previous ones, so that your question can be seen by more people, and so that other users can better search for questions and answers, it is recommended that you create a new thread. Thank you for your understanding. :-)
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-09-15T05:47:27.6733333+00:00

Good morning Yanli Jiang,

Sorry, I thought because it belongs to this JSON code.

When I click on "Send email to all 2 members", an email opens.

In this email, I would like to insert the direct link to this item "ELFACK". At the moment we have only the event title in the email, but I want the direct link to this event element - example "ELFACK". Is it possible with this code? Thank you so much!

Answer 2

Hi @Martin, Heidi (SE GP T SP PS) ,

Please try this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "style": {
    "display": "=if(length([$Atendees]) > 0, 'flex', 'none')",
    "text-decoration": "none"
  },
  "attributes": {
    "href": {
      "operator": "+",
      "operands": [
        "mailto:",
        "=join([$Atendees.email], ';')",
        "?Bcc=",
        "[$BCC.email]",
        "&subject=Event name: ",
        "[$Title]",
        "&body=Dear XXX,",
        "\r\n \r\n"
      ]
    }
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "Mail"
      }
    },
    {
      "elmType": "span",
      "txtContent": {
        "operator": "+",
        "operands": [
          "Send email to ",
          {
            "operator": "?",
            "operands": [
              "=length([$Atendees]) == 1",
              "[$Atendees.title]",
              "='all ' + length([$Atendees]) + ' members'"
            ]
          }
        ]
      }
    }
  ]
}

User's image

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.

Answer 3

Hello @Yanli Jiang - MSFT,

the code works, but unfortunately it no longer works with 12 recipients. Why is that? Can this still be adjusted?
Here is the complete code:

{
  "$schema": https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json,
  "elmType": "a",
  "style": {
    "display": "=if(length([$Attendees]) > 0, 'flex', 'none')",
    "text-decoration": "none"
  },
  "attributes": {
    "href": {
      "operator": "+",
      "operands": [
        mailto:,
        "=join([$Attendees.email], ';')",
        ?Bcc=xxx,
        "[$BCC.email]",
        "&subject=Event name: ",
        "[$Title]",
        " | Event date: ",
        "[$Startdate]",
        "&body=",
        "Dear XXX,",
        "\r\n \r\n",
        "As you probably know, we have created the GT-wide overview for the handling the relevant external events, conferences, and trade shows: https://xxx",
        "\r\n",
        "The target is to have the single tool for all relevant events for SE GT to reach transparency, coordinate performance, use the synergies, and evaluate the efforts for the future.",
        "\r\n",
        "\r\n",
        "Furthermore, we want to learn from events where we have participated to evaluate our performance, and to learn for the participation in further events. For this purpose we have created the event feedback sheet: https://xxx, which you also can find in the above tool bar as per screenshot below.",
        "\r\n",
        "I kindly ask you to take approx. 9 Min. time and fill in this event to support us. As per our notes, you’ve participated in: ",
        "\r\n",
        "Furthermore, we store all conference proceedings (papers, publications, presentations, etc.) in: https://xxx to allow access for all GT staff.",
        "\r\n",
        "In case you as participant have got access to these documentation, please provide it to me for the uploading.",
        "\r\n \r\n",
        "Appreciating your support with kind regards,",
        "\r\n \r\n"
      ]
    }
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "Mail"
      }
    },
    {
      "elmType": "span",
      "txtContent": {
        "operator": "+",
        "operands": [
          "Send email to ",
          {
            "operator": "?",
            "operands": [
              "=length([$Attendees]) == 1",
              "[$Attendees.title]",
              "='all ' + length([$Attendees]) + ' members'"
            ]
          }
        ]
      }
    }
  ]
}

Answer 4

Yanli Jiang - MSFT 31,596 Microsoft External Staff

Hi @Martin, Heidi (SE GP T SP PS) ,

The reason why it does not work may be that the link contains special characters, which will affect the Code. This can be avoided by placing the link alone.

Please try this:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "a",
  "style": {
    "display": "=if(length([$Atendees]) > 0, 'flex', 'none')",
    "text-decoration": "none"
  },
  "attributes": {
    "href": {
      "operator": "+",
      "operands": [
        "mailto:",
        "=join([$Atendees.email], ';')",
        "?Bcc=",
        "[$BCC.email]",
        "&subject=Event name: ",
        "[$Title]",
        "&body=Dear XXX,",
        "\r\n \r\n",
        "As you probably know, we have created the GT-wide overview for the handling the relevant external events, conferences, and trade shows:",
        "https://www.baidu.com",
        "\r\n",
        "The target is to have the single tool for all relevant events for SE GT to reach transparency, coordinate performance, use the synergies, and evaluate the efforts for the future.",
        "\r\n",
        "\r\n",
        "Furthermore, we want to learn from events where we have participated to evaluate our performance, and to learn for the participation in further events. For this purpose we have created the event feedback sheet: ",
        "https://www.baidu.com",
        ", which you also can find in the above tool bar as per screenshot below.",
        "\r\n",
        "I kindly ask you to take approx. 9 Min. time and fill in this event to support us. As per our notes, you’ve participated in: ",
        "\r\n",
        "Furthermore, we store all conference proceedings (papers, publications, presentations, etc.) in: ",
        "https://www.baidu.com",
        " to allow access for all GT staff.",
        "\r\n",
        "In case you as participant have got access to these documentation, please provide it to me for the uploading.",
        "\r\n \r\n",
        "Appreciating your support with kind regards,",
        "\r\n \r\n"
      ]
    }
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "Mail"
      }
    },
    {
      "elmType": "span",
      "txtContent": {
        "operator": "+",
        "operands": [
          "Send email to ",
          {
            "operator": "?",
            "operands": [
              "=length([$Atendees]) == 1",
              "[$Atendees.title]",
              "='all ' + length([$Atendees]) + ' members'"
            ]
          }
        ]
      }
    }
  ]
}

08151

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.

Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-15T05:09:47.8+00:00

Good morning @Yanli Jiang - MSFT

Thank you for your great help. Unfortunately it still does not work with the 12 attendees. What else can you do?
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-15T05:24:37.7233333+00:00

Hi @Martin, Heidi (SE GP T SP PS) ,

It works fine for me, can you describe your situation specifically?
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-15T05:34:14.5+00:00

Hi @Yanli Jiang - MSFT ,

Yes, when I click on the "Send email to all 12 members" option, Outlook does not open. All the others work.
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-15T05:58:13.13+00:00

Hi @Martin, Heidi (SE GP T SP PS) ,

That's weird, for me, there is no such case. 112 receivers will still work just fine.

Can you show me how you add the code? Because in my previous test, some details such as symbols will also cause the code to not work properly.

Martin, Heidi (SE GP T SP PS) 571

Hi @Yanli Jiang - MSFT

This is the code I put in the "Format this column" Email.

{
  "$schema": https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json,
  "elmType": "a",
  "style": {
    "display": "=if(length([$Attendees]) > 0, 'flex', 'none')",
    "text-decoration": "none"
  },
  "attributes": {
    "href": {
      "operator": "+",
      "operands": [
        mailto:,
        "=join([$Attendees.email], ';')",
        ?Bcc=xxx,
        "[$BCC.email]",
        "&subject=Event name: ",
        "[$Title]",
        " | ",
        "[$Startdate]",
        "&body=Dear XXX,",
        "\r\n \r\n",
        "As you probably know, we have created the GT-wide overview for the handling the relevant external events, conferences, and trade shows:",
        https://xxx,
        "\r\n",
        "The target is to have the single tool for all relevant events for SE GT to reach transparency, coordinate performance, use the synergies, and evaluate the efforts for the future.",
        "\r\n",
        "\r\n",
        "Furthermore, we want to learn from events where we have participated to evaluate our performance, and to learn for the participation in further events. For this purpose we have created the event feedback sheet: ",
        https://xxx,
        ", which you also can find in the above tool bar as per screenshot below.",
        "\r\n",
        "I kindly ask you to take approx. 9 Min. time and fill in this event to support us. As per our notes, you’ve participated in: ",
        "[$Title]",
        " | ",
        "[$Startdate]",
        "\r\n",
        "Furthermore, we store all conference proceedings (papers, publications, presentations, etc.) in: ",
        https://xxx,
        " to allow access for all GT staff.",
        "\r\n",
        "In case you as participant have got access to these documentation, please provide it to me for the uploading.",
        "\r\n \r\n",
        "Appreciating your support with kind regards,",
        "\r\n \r\n"
      ]
    }
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "Mail"
      }
    },
    {
      "elmType": "span",
      "txtContent": {
        "operator": "+",
        "operands": [
          "Send email to ",
          {
            "operator": "?",
            "operands": [
              "=length([$Attendees]) == 1",
              "[$Attendees.title]",
              "='all ' + length([$Attendees]) + ' members'"
            ]
          }
        ]
      }
    }
  ]
}

Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-15T06:37:49.42+00:00

Hi @Martin, Heidi (SE GP T SP PS) ,

Ok. I found that you are missing double quotes in these statements:

?Bcc=xxx, should be "?Bcc=xxx",

https://xxx,should be "https://xxx",

And, you add some parameters according to your own needs.

Let's do a few things to narrow down the problem:

Don't rush to make changes, please click the copy here and use the code I provided directly to see if it works.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-15T06:50:29.1+00:00

I'm missing your code, it didn't show up.

This is my code: I don't know why it looks different when copied, but now as an image. Is everything correct here?
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-15T07:15:44.07+00:00

Hi @Martin, Heidi (SE GP T SP PS) ,

What I'm talking about is the code provided in my latest answer, which can be displayed normally when I read the thread here. According to your screenshot, there is no problem. This is very strange. In this way, you re-create a list for testing, and then only use the code provided in my latest answer to see if it works normally.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-15T07:41:31.4133333+00:00

Your code works also with 12 Attendees, but if I insert my links in the text, then no more.

Now I tested it again with 7 Attendees and my links, then it works. I don't know any more.
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-15T07:53:48.8066667+00:00

Hi @Martin, Heidi (SE GP T SP PS) ,

I don't know how this happened. Because there is no problem on my side of the test. It may be that there are some settings on your site that affect the work of JSON. I suggest you can create a new service request in M365 admin center as an admin, they can provide more direct and professional help.

(Microsoft 365 admin center ->> Support ->> Help & support)

Thanks for your understanding.
Martin, Heidi (SE GP T SP PS) 571 Reputation points

2023-08-15T07:56:40.97+00:00

Many thanks for the fast and good support.
Yanli Jiang - MSFT 31,596 Reputation points Microsoft External Staff

2023-08-15T08:19:46.0566667+00:00

Hi @Martin, Heidi (SE GP T SP PS) ,

Thank you for your approval.

Hope your problem will be resolved soon. We also welcome you to share your solution here.

You can accept the answer to close this thread.

The behavior will help others who meet the similar issue in the future quickly find the useful information.

Answer 5

Martin, Heidi (SE GP T SP PS) 571

Hello @Yanli Jiang - MSFT,

Is it possible to insert the link to the event element in the above code?

At the moment only the event name appears here. But it would be great if you could put the link to this event element here.

Thank you so much!

User's image

Share via

JSON-Code (multiple "$Attendees.email")

4 additional answers

Your answer