Forum Discussion
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 showing the current user name.
Thanks a lot!
ROSE
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
5 Replies
Thank you Dave,
Try to use a Power Automate Flow for that - >It seems difficult to create such the Power Automate Flow
Hi BLACKROSE
that's right, you can't set a default value for people and groups columns:
Try to use a Power Automate Flow for that.
Regards, Dave
Dear DaveMehr365,
Can we do the same for a column with Person or Group type?
Thanks a lot!
ROSE
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
