cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
mkattke
Nintex Newbie

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
4 Replies
Automation Master
Automation Master

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
Reply
mkattke
Nintex Newbie

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
Reply
Automation Master
Automation Master

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
Reply
Automation Master
Automation Master

Re: Trying to export SharePoint 2016 list into Csv

I've tried to use that UDA but it's giving me an error message. I've even tried to put into an action set to run as the account which I use to call web service but it's still giving me 401 error message. Also, UDA is not giving any option to choose which account I want to use to call web service.

 

Also, I'm using this UDA in a site workflow.

 

Am I doing anything wrong here !!!!

0 Kudos
Reply