SharePoint - Populate a Column in One List with Multiple Values from Another List, Using Just OOTB Functionality

KePr22 1 Reputation point

I am a non-technical person and using SharePoint for a work project. I am hoping there is a way to do this OOTB.

I have a list called "Group A" it has a single field in it called "Members" - so it's structure is:

Group A
Person 1
Person 2
Person 3

(I have similar lists called Group B, Group C, Group D, etc., but they all have the same structure).

I have a second list called "Distribution Methods" with multiple fields, one field is called "Recipients." In the "Recipients" field I want to be able to select Group A, Group B, Group C, etc. and have the field populate with the members names. This way as I need to change the makeup of the various groups, I can change the individual Group A, Group B, Group C, etc. list and the Distribution Methods list will update with the new members.

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,247 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CaseyYang-MSFT 10,366 Reputation points

    Hi @KePr22 ,

    Have you created user account for these Person in SharePoint?

    You could create SharePoint groups and add users to these groups, then you can limit the employees shown in people picker field using SharePoint group.

    Create Person or Group column(Recipients) > Column settings > Choose from > SharePoint Group > Select group


    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.