Display lookup info from an external list

[igorsp]

Is it possible to display lookup info on runtime in the form with info coming from the external list (external content type)?

In my scenario I would like the user to be able to select a value from the external content type and then lookup additional values and display it on the form? Is this doable?

I tried the standard lookup runtime function but it doesn't seem to be working.

[patrickabel]

Hello Igor Karon​ – Does the List View control fit your needs?

This control would allow you to show the user multiple columns of data associated with an external list and you can filter/show those results based on another control's value using the "Filter listed items" property.

[igorsp]

Hmmm... Not sure exactly how I could use it when creating a new item. Can you please give me a little more information about it? Thanks!

[patrickabel]

Without some more context on the specifics of your problem I'm not sure how helpful I'll be, but I'll give it a shot.

Going off your sample, you could setup a List Lookup which allows the user to select an existing location and then see any items in the external list (through a List View control) filtered based on what you've selected in the list lookup.

For instance, in the below screenshot, I've got an external list with location data which is being filtered based on the ID I'm specifying in the list control. This filter like I mentioned above is driven by the Filter listed items property of the list view control.

What you then need to do with the data would significantly impact the implementation direction, but this is a solid route when display/reference is the primary goal.

[igorsp]

Trying to experiment with this but when I go to setup the List View control I dont see my external list as an option. I only see regular SharePoint lists. Any idea why?

[patrickabel]

I've noticed the "refresh" at times doesn't immediately re-populate based on what you've selected in the Source SharePoint site so you might try it a few times. I'd also use the arrow to the right of that control to make sure you've got the path correct (UI selection instead of manual entry).

Once you do this, you should see your other lists.

[igorsp]

Regular SharePoint list show up immediately. I waited and refreshed a couple of times by the External List is not showing up.

[patrickabel]

What's your definition of an external list? Different farm? Different site collection?

[igorsp]

I just use Microsoft's definition:

Differences between native and external lists - Office Support

How to: Create External Lists in SharePoint

Thanks!

[prashanth_hamse]

I also have the same issue rolling on my head. trying to figure out how to fill value='CustomerID' where i have primary key setup in external list (connected to SQL table)

I upgraded to latest & greatest Nintex Forms 2013 ( 2.9.2.20 ) version  No luck

here are my steps. Please let me know solution to this dropdown also when i save form doesnt save this value (hope as Value='0' for all items in drop down list, it doesnt save anything to coloumn)