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

Question

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
etc.

(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.

Answer 1

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.