Cascading limitation on number of items

Question

I have implemented cascading in SharePoint online. The problem is that it is not populating items when the number of items is more than 100.

I am using below code for cascading.

$().SPServices.SPCascadeDropdowns({
    relationshipList: "BG",
    relationshipListParentColumn: "BUSINESS_GROUP",    
    relationshipListChildColumn: "COE",
    parentColumn: "BG",
    childColumn: "COE",
    debug: true
  });

Is there any way to overcome this limitation.

Hard to suggest anything without actually knowing anything about your implementation. Any hard-coded 100 limit shouldn't exist, but sure it will depend on how the cascading has been created. — moe, Mar 20 '18 at 12:25
This might be due to SharePoint web services limiting to 100 results when getting items. See https://sharepoint.stackexchange.com/q/74777/8992 — Dylan Cristy, Mar 20 '18 at 14:16

score 0 · Answer 1 · answered Mar 20 '18 at 15:22

Try to use SPComplexToSimpleDropdown function for the column contains more than 100 item,
check the below example:

$().SPServices.SPComplexToSimpleDropdown({  
    columnName: "COE", // the colums name which contains more than 100 item
    completefunc: null,
    debug: true
});

$().SPServices.SPCascadeDropdowns({
    relationshipList: "BG",
    relationshipListParentColumn: "BUSINESS_GROUP",    
    relationshipListChildColumn: "COE",
    parentColumn: "BG",
    childColumn: "COE",
    simpleChild: true,
    debug: true
  });

Cascading limitation on number of items

1 Answers1