Lookup column with reference to other sharepoint list with a column from people/group

Gollnast, Viktoria 21 Reputation points
2022-09-14T12:27:28.207+00:00

I want to create a column with "lookup" in sharepoint list 2. This column should refer to sharepoint list 1, to the 4th column. This column is a self added column "People/Groups" - not the column with Title, ID, Created by, etc.
When I create a demand column, I can only refer to the automatically created columns in List 1. (Picture 2)

Does anyone know a solution to this problem?

240990-bild1.jpg241015-bild2.jpg

241081-bild3.jpg

Microsoft 365 and Office | SharePoint Server | For business
Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows
{count} votes

Accepted answer
  1. Renjie Sun-MSFT 2,861 Reputation points Microsoft Employee
    2022-09-15T07:45:34.997+00:00

    Dear @Gollnast, Viktoria ,

    Thank you for your post in our forum.

    According to the research, ‘Person&Group’ column type cannot be used to create lookup columns.
    241355-image.png

    More information about lookup column.

    Should you have any questions or concerns, please do feel free to contact me.

    Yours sincerely,
    Renjie Sun


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.