cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Workflow Hero

Trying to export SharePoint 2016 list into Csv

Hello all,

I'm trying to take a simple SharePoint 2016 on-prem list and have all the items, using Nintext WF, in a Csv. I'm not a newbie, but not advanced in Nintex WFs.

I already have a stringnintexString.JPG

A query list: nintextQuery.JPG

A forEach action that I don't know how to config yet:  nintexForEach.JPG

Finally, a send notif: nintexSendNotif.JPG

what am I missing? I'm stuck on config forEach and know I need a var to represent all items in SP list.

Any help/guidance would be appreciated. 

Labels: (1)
0 Kudos
Reply
3 Replies
Workflow Hero

Re: Trying to export SharePoint 2016 list into Csv

if you want to export all the items, wouldn't it be easier to use SP's OOTB 'Export to excel' button from ribbon?

i.jpg

 

 

 

if you still want to learn how to do CSVC export from workflow, have a look on Vadim's blog

http://www.vadimtabakman.com/nintex-workflow-list-to-csv-uda.aspx

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Trying to export SharePoint 2016 list into Csv

I know how to export a SP list on the ribbon, but my supervisor wants a Nintex WF to do it autonomously. I'm just stuck config a forEach action, but there could be other methods of achieving this.

I already tried this http://www.vadimtabakman.com/nintex-workflow-list-to-csv-uda.aspx but it does not do what my boss wants. He wants the Csv packaged in an email, not the Csv populated in the SP list.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Trying to export SharePoint 2016 list into Csv

UDA itself returns CSV formatted string, so you can take it and as a mail attachement or process whatever way you need.

saving csv file to a library is just a matter of test workflow that uses/presents the UDA functionality.

0 Kudos
Accept as Solution Reply