Forum Discussion
Send e-mail when ownership is assigned not listing IDs
I have a SharePoint site whereby whenever a user is assigned an item, they get a notification. This is done by going to "List Settings" --> "Advanced Settings" --> "Send e-mail when ownership is a...
vincetaylor70 It works for me with Issue Tracking list as well:
Try this:
- Create one more list on same site with Issue tracking list template (for testing)
- Create one column "CustomID"
- Create one item in the list
- Check if you get the email with CustomID.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
When I added a number column and a "Single Line of Text" column, they both appeared in the e-mail template.
But as soon as I added the code below to the column formatting section, both fields were removed from the email
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "[$ID]"
}
Are you using the same code?
If not then what are you using ?
That will not work because Column Formatting is just for UI, it does not store value actually in the list based on Column Formatting.
You need to store ID some how into your custom column which you can set when you are assigning issue to some person.Important: You can't use ID column in SharePoint Calculated column.
If you don't want to go with setting ID in your custom column, then you can't use Default Email functionality here, there I would suggest to go with Power Automate which can send an email when issue is assigned to someone.
Hope it will helpful to you.
vincetaylor70 I was not using any JSON formatting on column. I entered the value in CustomID column manually from list form.
Anyway, I can still see the custom column in email even when using JSON formatting on column:
Note: JSON column formatting does not set the actual column value. It only customizes the display of column to show the value in list view. Hence, the value shown in list view will not be sent in email.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
