How to obtain current logged in user Display Name in lists?

Question

Hello,

Recently I changed SharePoint Server on-premise to SharePoint Online. In lists, we want to obtain current user name for fields. But failed.

In SharePoint Server on-premise, the formula =[me] is supported. But in SharePoint Online, it is no longer supported. I tried to use Mid, but didn't work.

Do you have a solution for that? Thanks in advance.

Screenshot 1: SharePoint Online

Answer 1

Hi BillYoung

Thank you for coming back to forum.

Based on your further description about your question, if you just want to the user name will fill automatically when you create a new list.

We suggest you can go to the list>All Items>Edit current view>check the Creates by box then to see the result.

Hope the suggestion can help you.

Regards,

Stacey

Answer 2

Hi BillYoung

Thanks for posting the thread on our forum.

According to your description, it seems that you want to obtain the current logged in user name  display in the SharePoint list.

If my understanding is correct, we suggest you can use the JavaScript to achieve your requirement.

Open the drop-down menu under a column>Format this column>then type the below script in the box>Save to see the result.

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "div",

"txtContent": "@currentField.title"

}

For more detailed information, you can refer to Use column formatting to customize SharePoint | Microsoft Docs

Hope the suggestion can help you.

Best regards,

Stacey

Answer 3

Hello Stacey,

Thanks for your reply. My requirement is when user create a new item in list, they don't have to input user name. The user name will be filled automatically.

For example, when staff creates a new item, the name will be obtained from logged in user information.

Answer 4

Thank you. This is really a smart way!