I have two connectors to Business Central. One brings in Item Categories of which there are only 7. The other brings in Items of which there should be over 2000. Every item will be assigned to a item category. So I would like the user to be able to select a category from a dropdown and have a clearconnect run and bring in only those items which are assigned to the category the user selected and save these into the collection.
I thought something like this may work but get an error.
ClearCollect(colBCItems, Filter(items,itemCategoryCode = drpCategories.Selected.code))
So my question is, can I bring in data into a collection from Business Central when there are over 2000 records?

Report
All responses (
Answers (