SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2373950%22%20slang%3D%22en-US%22%3EI%20can't%20set%20%22people%20or%20group%22%20in%20a%20column%20in%20sharepoint%20list%20(The%20data%20came%20from%20excel%20datasheet)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2373950%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%3F%3C%2FP%3E%3CP%3EI%20uploaded%20dataset%20from%20excel%20to%20a%20sharepoint%20list.%20Now%20I%20want%20to%20put%20%3CSTRONG%3Epeople%3C%2FSTRONG%3E%20on%20the%20column%20%22Name%22%20to%20be%20easier%20searching%20the%20name%20in%20PowerApps%2C%20but%20don't%20appear%20this%20option.%20Just%20appear%20'%3CSTRONG%3Epeople%20or%20group%3C%2FSTRONG%3E'%20when%20I%20create%20new%20column%20(%20I%20can't%20use%20the%20new%20one%2C%20because%20I%20have%26nbsp%3Bhistorical%20data)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20pic%20is%20in%20portuguese%2C%20but%20it's%20just%20for%20show%20that%20there%20is%20no%20the%20option%20'%3CSTRONG%3Epeople%3C%2FSTRONG%3E'(pessoa%20in%20portuguese)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20solve%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2373950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2374435%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20set%20%22people%20or%20group%22%20in%20a%20column%20in%20sharepoint%20list%20(The%20data%20came%20from%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2374435%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1059442%22%20target%3D%22_blank%22%3E%40t1agow%3C%2FA%3E%26nbsp%3BCan%20you%20show%20us%20the%20structure%20of%20excel%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20cannot%20set%2Fupdate%20person%20or%20group%20column%20using%20excel%20data%20if%20the%20column%20in%20excel%20is%20just%20text%20(name%20of%20person).%20In%20SharePoint%2C%20person%20or%20group%20column%20is%20stored%20by%20using%20user%20ID%20(ID%20of%20user%20in%20hidden%20%3CSTRONG%3EUser%20Information%20List%3C%2FSTRONG%3E).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20if%20you%20have%20existing%20%22Person%20or%20Group%22%20column%20%26amp%3B%20you%20don't%20want%20to%20allow%20selection%20of%20SP%20group%2C%20you%20can%20set%20the%20column%20settings%20like%20(untick%20the%20highlighted%20checkbox)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ganeshsanap_0-1621573624005.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F282524i468A8203DB568711%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ganeshsanap_0-1621573624005.png%22%20alt%3D%22ganeshsanap_0-1621573624005.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 appear this option. Just appear 'people or group' when I create new column ( I can't use the new one, because I have historical data)

 

The pic is in portuguese, but it's just for show that there is no the option 'people'(pessoa in portuguese) 

 

How can I solve that?

 

Thank you in advance

1 Reply
best response confirmed by t1agow (New Contributor)
Solution

@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):

ganeshsanap_0-1621573624005.png


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.