Populate dropdown field in SharePoint form with data from list located in another site

Forms SharePoint 2019
1

good day !
I want to populate a dropdown field (fields from plumsail form) with values from another list from another site with Title. It works, but sho not all items. List have 1500+ items, returned only 50.
From manual

function populateDepartmentCodes(){

    //specify your site URL
    var siteURL = 'http://intranet/sites/help/';
    let web = new Web(siteURL);

    web.lists.getByTitle('Products').items.select('Title').get().then(function(items) {

        fd.field('DropDown1').widget.setDataSource({
            data: items.map(function(i) { return i.Title })
        });

        //set the dropdown with the previously selected value
       // fd.field('DropDown1').value = fd.field('DepartmentCode').value;
    });
}

fd.spRendered(function() {

    //call function on from load
    populateDepartmentCodes();

    //fill SharePoint field with the selected value
    fd.field('DropDown1').$on('change', function() {
      //  fd.field('DepartmentCode').value = fd.field("DropDown1").value;
    });
});
2

Hello @ixxxl,

For large lists, you should use paging. Find more information in the PnPjs documentation here.

If you are using Plumsail Forms v1.8.7, you can use the Lookup control to get data from different sites and site collections.

3

@mnikitina
for now i have some problems with 1.8.7 in test environment,. Work with support team about this issue. and i still work with 1.4.8
i will try with pnp.. thank you

4

@mnikitina
Good day!
How can i sort by title after populating dropdown field from another site?

5

@Nikita_Kurguzov @mnikitina
Can you help me please?

6

Dear @ixxxl,
You can try it like this:

web.lists.getByTitle('Some list').items.orderBy('Title', true).get().then(function(resutls) {
  // etc
})
1 Like
7

@Nikita_Kurguzov
Thank you!