Forum Discussion

t1agow's avatar
t1agow
Copper Contributor
May 20, 2021
Solved

I can't set "people or group" in a column in sharepoint list (The data came from excel datasheet)

Hello everybody,   Can someone help me? I uploaded dataset from excel to a sharepoint list. Now I want to put people on the column "Name" to be easier searching the name in PowerApps, but don't ap...
files
Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    May 21, 2021

    t1agow Can you show us the structure of excel data?

     

    You cannot set/update person or group column using excel data if the column in excel is just text (name of person). In SharePoint, person or group column is stored by using user ID (ID of user in hidden User Information List).

     

    Also, if you have existing "Person or Group" column & you don't want to allow selection of SP group, you can set the column settings like (untick the highlighted checkbox):

    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.

ganeshsanap's avatar
ganeshsanap
MVP
May 21, 2021

t1agow Can you show us the structure of excel data?

 

You cannot set/update person or group column using excel data if the column in excel is just text (name of person). In SharePoint, person or group column is stored by using user ID (ID of user in hidden User Information List).

 

Also, if you have existing "Person or Group" column & you don't want to allow selection of SP group, you can set the column settings like (untick the highlighted checkbox):

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.

Resources