Use DATA from other list with lookup choice to perform formula

H
Badge +2

Hi everybody,

I search to apply calcul with input from an other list (in the same sharepoint).

Details :

One liste name "WU" : in this list, each line have deisgnation in "Title" column and number corresponding to it on "hours" column.

then in an other list, I have a choice of this first list by "Title" and I need the column "hours" information to apply calcul whit it.

Picture will be more easy then explanation (sorry for my english !)

205438_pastedImage_2.png

 

If somebody can help me ?

I had try with lookup formula (  lookup("ETV -- Work Units","Title",WU choice,Hours) )

Thanks in advance for your help.

Regards.

HeliClem

10 replies

L
Badge +9

Hi clement peyrusaubes‌,

try with -  lookup("ETV -- Work Units","Title",WU choice,"Hours")

Thanks,

Lakshmi Narayana C‌

H
Badge +2

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>

L
Badge +9

Have you Include quotes correctly in the formula for 'hours' column, it will work.

lookup('Test Request Number','Request Status',RequestStatus,'Request Name')

205475_pastedImage_1.png

H
Badge +2

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>

E
Userlevel 5
Badge +14

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)‍

 

L
Badge +9

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')

205500_pastedImage_1.png

Thanks,

Lakshmi Narayana C‌

H
Badge +2

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>

H
Badge +2

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>

E
Userlevel 5
Badge +14

great!

please mark correct answer.

L
Badge +9

can you please mark the parse lookup function as correct answer.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings