Hi clement peyrusaubes,
try with - lookup("ETV -- Work Units","Title",WU choice,"Hours")
Thanks,
Lakshmi Narayana C
Namaste Lakshmi,
I just tried it know and I have the same issue.
When I choose on the list, “loading” is coming and after that, is blank.
Have you another solution ?
Thanks in advance.
Clement
De : Lakshmi Narayana C
Envoyé : mardi 11 juillet 2017 17:26
À : PEYRUSAUBES, Clement
Objet : You have been mentioned by Lakshmi Narayana C in Re: Use DATA from other list with lookup choice to perform formula in Nintex Community
Nintex Community <https://community.nintex.com/?et=notification.mention>
You have been mentioned
by Lakshmi Narayana C<https://community.nintex.com/people/lakshminarayana?et=notification.mention> in Re: Use DATA from other list with lookup choice to perform formula in Nintex Community - View Lakshmi Narayana C's reference to you<https://community.nintex.com/message/66112-re-use-data-from-other-list-with-lookup-choice-to-perform-formula?commentID=66112&et=notification.mention#comment-66112>
Have you Include quotes correctly in the formula for 'hours' column, it will work.
lookup('Test Request Number','Request Status', RequestStatus,'Request Name') |
Yes.
Enclosed screen shot :
[cid:image002.jpg@01D2FA76.7B675460]
[cid:image004.jpg@01D2FA76.7B675460]
If you have an idea?
Thank for your support.
Regards.
Clément, Peyrusaubes
AIESK - PDI / ETV
Coordinator Airbus India / Airbus Helicopters
Téléphone : +91 80 66 380 472
E-mail: clement.peyrusaubes@airbus.com<mailto:clement.peyrusaubes@airbus.com>
De : lakshminarayana
Envoyé : mardi 11 juillet 2017 17:50
À : PEYRUSAUBES, Clement
Objet : Re: - Re: Use DATA from other list with lookup choice to perform formula
Nintex Community <https://community.nintex.com/?et=watches.email.thread>
Re: Use DATA from other list with lookup choice to perform formula
reply from Lakshmi Narayana C<https://community.nintex.com/people/lakshminarayana?et=watches.email.thread> in Dev Talk - View the full discussion<https://community.nintex.com/message/66113-re-use-data-from-other-list-with-lookup-choice-to-perform-formula?commentID=66113&et=watches.email.thread#comment-66113>
as you might see on your screenshot, value of lookup control is 1;#301
where 1 id ID of item in remote list referenced by lookup function, and 301 is likely value of Title column.
so to make lookup by Title value your formula should look like
lookup("ETV -- Work Units","Title",parseLookup(WU choice,true),Hours)
Hi ,
You mentioned it is a choice column, for choice column the above formula previously what mentioned will work correctly.
But for a lookup choice column you have to use 'parseLookup' function.
lookup('Departments','Title',parseLookup( depat2,true),'ID') |
|
Thanks,
Lakshmi Narayana C
It’s work ! 
Thanks for your support.
Regards.
Clément, Peyrusaubes
AIESK - PDI / ETV
Coordinator Airbus India / Airbus Helicopters
Téléphone : +91 80 66 380 472
E-mail: clement.peyrusaubes@airbus.com<mailto:clement.peyrusaubes@airbus.com>
De : emha
Envoyé : mercredi 12 juillet 2017 05:23
À : PEYRUSAUBES, Clement
Objet : Re: - Re: Use DATA from other list with lookup choice to perform formula
Nintex Community <https://community.nintex.com/?et=watches.email.thread>
Re: Use DATA from other list with lookup choice to perform formula
reply from Marian Hatala<https://community.nintex.com/people/emha?et=watches.email.thread> in Dev Talk - View the full discussion<https://community.nintex.com/message/66180-re-use-data-from-other-list-with-lookup-choice-to-perform-formula?commentID=66180&et=watches.email.thread#comment-66180>
It’s work !
Thanks for your support.
Regards.
Clément, Peyrusaubes
AIESK - PDI / ETV
Coordinator Airbus India / Airbus Helicopters
Téléphone : +91 80 66 380 472
E-mail: clement.peyrusaubes@airbus.com<mailto:clement.peyrusaubes@airbus.com>
De : lakshminarayana
Envoyé : mercredi 12 juillet 2017 10:45
À : PEYRUSAUBES, Clement
Objet : Re: - Re: Use DATA from other list with lookup choice to perform formula
Nintex Community <https://community.nintex.com/?et=watches.email.thread>
Re: Use DATA from other list with lookup choice to perform formula
reply from Lakshmi Narayana C<https://community.nintex.com/people/lakshminarayana?et=watches.email.thread> in Dev Talk - View the full discussion<https://community.nintex.com/message/66157-re-use-data-from-other-list-with-lookup-choice-to-perform-formula?commentID=66157&et=watches.email.thread#comment-66157>
great!
please mark correct answer.
can you please mark the parse lookup function as correct answer.
