cancel
Showing results for 
Search instead for 
Did you mean: 
slwhite63
Nintex Newbie

Lookups to Different List with Peoplepickers

Jump to solution

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

ST Manager

CTO

 

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?

Labels: (1)
Tags (2)
0 Kudos
Reply
2 Replies
courtney_shelto
Nintex Newbie

Re: Lookups to Different List with Peoplepickers

Jump to solution

Do you have to do it in the form or can you do it with workflow after submission? 

0 Kudos
Reply
slwhite63
Nintex Newbie

Re: Lookups to Different List with Peoplepickers

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

View solution in original post

Reply