jamesiliff
Nintex Newbie

Nintex WF to count items in list and move items to different list

Hello,

I am creating items in a SharePoint list through a Excel VBA macro.

The macro takes a large document, breaks it apart into 15,000 work items and creates a SharePoint list item for each of the 15,000.

I want to use Nintex workflow to check the number of items in a list.

As the macro is adding items, when the list reaches 4,500 items, can Nintex workflow move the 4,500 items to another list while and the macro continues to populate the original list until it reaches 4,500 items, and so on.

I am trying to avoid the 5,000 item throttling limit in SharePoint.

Thank you for the help.

James

0 Kudos
Reply
3 Replies
murphybp2
Cloud Wanderer

Re: Nintex WF to count items in list and move items to different list

The 5,000 item limit only is an issue with viewing data.  There is no problem with storing more than 5,000 items in a list.  Just build views that don't display more than 5,000 items and you'll be fine.  There's no need to move the records to another list.

Reply
emha
Automation Master
Automation Master

Re: Nintex WF to count items in list and move items to different list

hopefully with your amounts this is one-off action.

if so you could use 'Import Spreadsheet' application. it will be way too faster and it should be able to deal with whole document in one go.

you will find respective icon among Site content apps

Reply
sojanm
Workflow Veteran

Re: Nintex WF to count items in list and move items to different list

You can query the list and store the result in Collection Variable. Then use collection operation control to get the count

0 Kudos
Reply