Jul 05 2022 07:12 AM
I am trying add another record field called, 'manager group' and I want it to automatically populate the person group based off the category the user selects. Should I make a separate source list with all the manager groups, similar to how I did the activities and categories or is there another way? I have attached a screenshot of the list as well:
Aug 06 2022 11:57 PM
Hi @DKnight1
Yes, that's an easy way to maintain your groups/users, but you should use a flow to populate this based on your criteria.
Aug 08 2022 01:42 AM
@DKnight1 What will be the column/data type of "Manager group" column?
As manager group is based on Category selected, I will suggest you to create a "Manager group" column in Category list.
Then, in lookup settings of Category column, you can extend the lookup column to show "Manager group" as an additional column.
Example: I am showing "SubParent" column along with "Title" column:
Note: Lookups only support below column types:
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.