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

Get data from another list triggered by a calculated profile value.

Jump to solution

Good Day Team,

I need your suggestion about my request, The maint list is called "UserProfil" I am trying to pull information from the user profil and put into the nintex form. So far I was able to get the current user profile information, however there are some fields that I was not able to find, field like zip code, state, city and so on. So What I am trying to do is bring the information from another sharepoint list called locations, I put in the sharepoint list "Locations" all the possibles addresses that could be exist and my idea is create a lookup between my locations and Userprofil, in the form (Userprofile) I was able to get the "location code " and what I need is, based in the code Location trigger and get the other fields (zip code, city, state...) from the list Locations but I am not sure if it posible, I have been trying but I failed.

Here is my maint list "Profil"

This is the list "locations" that i am trying to associate to the the blank fields.

I will really appreciate any suggestion.  Thanks in advance.

Walt

Labels: (2)
0 Kudos
Reply
3 Replies
Automation Master
Automation Master

Re: Get data from another list triggered by a calculated profile value.

Jump to solution

so I assume Location field in Profil list is a lookup field to Locations list.

so you can use calculated value controls with formula like

lookup('Locations','ID',parseLookup(LookupNamedControl,false),'ADDRESS1')‍‍

last parameter in the function call is name of field in Locations list. so you will have to change it for each field accordingly.

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: Get data from another list triggered by a calculated profile value.

Jump to solution

Great, this is working, my last question will be " Is the a way to select by defaul the location code? for instance SANSS instead of please select a value? or should I consider other way to push it thro? 

Thank you for your help Marian.

Reply
Highlighted
Automation Master
Automation Master

Re: Get data from another list triggered by a calculated profile value.

Jump to solution

only with javascript

0 Kudos
Reply