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 string
A query list:
A forEach action that I don't know how to config yet:
Finally, a send notif:
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.
if you want to export all the items, wouldn't it be easier to use SP's OOTB 'Export to excel' button from ribbon?
if you still want to learn how to do CSVC export from workflow, have a look on Vadim's blog
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.
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.