External Data (SQL Table)

Forms SharePoint 2019
1

Hello everyone
I have an external list in SharePoint 2019 that consumes data from a SQL table. In a custom-list I created a lookup on a column of the external list. When I display this in a Plumsail form, Plumsail tells me that this field type is not supported. The next attempt was a lookup control with the external list as a data source and a field from the external list as a dropdown. At first glance this works, but I only see a very small portion of the data. The external list has 7000 entries, but the lookup control only shows me 35. Is there a way to display data from an external list in a Plumsail form as a dropdown (lookup)?

Thanks in advance
Dietmar

2

Dear @DietmarDeeg,
The only option here is the Lookup control, which supports filtering as you type the text in, and you can scroll down to expand available options.

You can also use code to expand the number of visible options, though we don't recommend expanding it to include all values:

fd.spRendered(function(){
  fd.control('Lookup').ready(function(control) {
    control.widgetOptions = {
      dataSource: {pageSize: 100}
    }
  });
});