Forum Discussion
Use a drop down in one list connected to another list selecting employee contained in the list
VeeExcelLearn For your requirements, you can use lookup columns in SharePoint. You can create one master list for employees & use columns from this list to tasks list by creating a lookup column.
Note: lookup columns support below column/data types only:
Single line of text
Number
Date and Time
- Lookup (single value)
Documentation: Create list relationships by using lookup columns
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.
VeeExcelLearn For your requirements, you can use lookup columns in SharePoint. You can create one master list for employees & use columns from this list to tasks list by creating a lookup column.
Note: lookup columns support below column/data types only:
Single line of text
Number
Date and Time
- Lookup (single value)
Documentation: Create list relationships by using lookup columns
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.
A bit late to this party, but this is perfect! I'm attempting the same. my next step though is to filter the list by the value of another column (both columns in the lookup list). any advice on that?