Set default value by logged user for people and groups column type in a SharePoint list

(0) Share

Report

Posted on by ROSEBLACK

205

Hi Everyone,

I have a column in SharePoint list with Person type.

Can we set the logged user is the default value in the CurrentLoggedUser field when adding a new item?

-> default value is the current logged user

Thanks a lot!

ROSE

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

MS.Ragavendar 5,015 Super User 2025 Season 2 on at

Like (0)

Report
@ROSEBLACK,

In SharePoint Online, you cannot set the default value for a Person or Group column directly in list settings. However, you can achieve this using Power Automate or JSON column formatting but column format only display.

Approach 1

Create → Automated cloud flow.

Choose "When an item is created" (SharePoint trigger) and choose your SharePoint List.

Click + New Step → Update item and Select Person column.

Set its value to "Created By" (this automatically assigns the user who created the item).

Save & Test.

Approach 2

If you want only display the logged-in user but not set it as a default, you can apply JSON formatting.

Click the Person column → Column settings → Format this column and Select Advanced mode and paste this JSON

{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=[$CreatedBy.displayName]"
}

Approach 3

https://learn.microsoft.com/en-us/answers/questions/126433/use-current-user-as-default-value-in-a-person-or-g

If you any queries revert me back.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

Thank you very much @MS.Ragavendar

For the approach 1, this automatically assigns the user who created the item -> it is not suitable in my case, for example User A is logging in to filling data on behalf of User B so that the user A need to select email of the user B in the field.

For the approach 2, column format only display -> no data recorded.

Cheer!

ROSE

Was this reply helpful? Yes No
MS.Ragavendar 5,015 Super User 2025 Season 2 on at

Like (0)

Report

@ROSEBLACK,

You have clarified about the both approaches, BTW what is the approach which you opted for solving your problem?

Was this reply helpful? Yes No
ROSEBLACK 205 on at

Like (0)

Report

MS.Ragavendar

I closed the question because there was no better option.

I had to change my approach.

Thanks a lot!

ROSE

Was this reply helpful? Yes No