Forum Discussion
BLACKROSE
Mar 21, 2025Copper Contributor
Set default value by logged user for title colum in a SharePoint list
Hi Everyone, I want the current user is the default value in Title column (or Person or Group column type). How can I achieve this? I have tried to set default value is [Me] but it's not showin...
- Mar 24, 2025
Hi BLACKROSE
you can try to use a ColumentFomratting, to show only the email address in your colument like this:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=substring(@currentField, lastIndexOf(@currentField, '|') + 1, 1000)"
}Best, Dave
BLACKROSE
Mar 24, 2025Copper Contributor
Dear DaveMehr365,
Can we do the same for a column with Person or Group type?
Thanks a lot!
ROSE
DaveMehr365
Mar 24, 2025MVP
Hi BLACKROSE
you can try to use a ColumentFomratting, to show only the email address in your colument like this:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=substring(@currentField, lastIndexOf(@currentField, '|') + 1, 1000)"
}
Best, Dave