Lookup multiple columns from list on another site collection

  • 18 December 2019
  • 2 replies
  • 1 view

Badge +10

Hi all,

 

I have a form where I use a lookup in order to get information out of a list located one level above my site. This works:

6004i35DAF1F0B42F8340.png

 

Now I want not only this info, but two additional infos written in two other columns.

 

I put two additional lookup items on my form, using the first lookup as a filter.

This - somehow - works:

6005i2A065AC492317356.png

 

Unfortunately it does not look like this:

6006i98A0DD7E534DE8A5.png

 

but like this:

6007iCB4B0D2D508A1C9F.png

 

So the results are not "selected". How can I grab the values given back?

 

Cheers

mai-kel

 

PS: it does not mater if this is done within forms or within workflow, but I would prefer to get this info immediately - so within the form

How am I able to utilize this additional two pieces of information


2 replies

Userlevel 6
Badge +22
Hi,

Use a Calcualted control with the lookup runtime function that is filtered off of the first lookup control. This will display the information immediately without having to select it.
Badge +12

@SimonMuntz ...his lookup list is in a site which is 1 level up. I don't think calculated parse lookup will look be helpful. Correct me if I'm wrong.

Reply