Display lookup info from an external list

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.

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.

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.

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

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)