Automatically assign values for one column based on another column with options from second list

Copper Contributor

Okay I will try to explain this as best as I can. I hope I am not re-asking a question but I couldn't find anything that matched my problem:


I have two SharePoint Lists:

List 1 = Requests - Collects data from users using a form and this list is the primary list that the end user does not see.

List 2 = Option Coordinators - Defines roles to my team members (set up so this coordinator can be changes as people move in/out of the department).


What I am trying to do:

1. The user selects which "option" they want in List 1

2. What I want is the "option" in List 1 to assign an "option coordinator" from List 2 automatically (Power Automate).


Note in List 2 has columns of "Option" and "Option Coordinator". 


Any help would be appreciated 

1 Reply

@John603 What is the column/data type of Option and Option Coordinator column in the List 2?


If it is a single line of text, you can do this:

  1. Create a lookup column in list 1 which will point to list 2
  2. Use main column as option 
  3. Extend lookup and use additional column for Option Coordinator in lookup settings: ganeshsanap_0-1686317592881.png

Check these documentations for more information:

  1. Create list relationships by using lookup columns 
  2. Create a column in a list or library 

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.