I am building a form which will allow a user to request overtime hours. I have a need to email to different people based on the inputs from the requester. The requester will select the Global Resource Manager (GRM)
Global Resource Manager
What I am trying to do is when the Global Resource Manager is input (this is a people picker) the form will fill in the ST Manager and the CTO (currently also set as People Pickers)
I have a second list (STManagerandCTO) which has the relationships built, which GRM goes to which ST Manager to which CTO. These are a one to many relationship.
The column headings are:
Global Resource Manager ST Manager CTO
Steve Mark John
Trent Mark John
Ralph Chris Mike
Joe Chris Mike
Dan Rick Susie
I want to be able to pull in the associated ST Manager and the CTO to the form based on the input for GRM. So if Steve is picked it will fill in Mark as the ST Manager and John as the CTO. I will need to be able to email approvals to them based on other inputs on the form. Right now I can’t get the names to populate to the form using People Pickers. If I switch to another value I have issues sending the emails.
The ST Managers and CTO are not listed in the Users profile in SharePoint.
Ideas? Am I making this harder than it should be?
Solved! Go to Solution.
I was able to complete this with workflows and an additional list. I used the additional list to maintain the CTO's and the STManagers. This list will be updated as needed. I still wanted to use people pickers for the forms, so I created a workflow to run when new users were added to the list. The workflow adds them to the SP Group.