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

Export a List to Excel

Jump to solution

I have a List that grows by 300 items a day.  Thus, I have an archive process in place to purge the items every 3 days.  The challenge now is the manager wants to view the past 6 months of data for metric purposes.

What are my options given that I am always being told that List can not exceed 5,000 rows, but having a need to store 27,000 rows for metrics and other validation purposes such as an audit check...

Is it possible via a Workflow to export to a Excel spreadsheet daily (append the records to a master workbook)..

0 Kudos
Reply
3 Replies
Workflow Hero

Re: Export a List to Excel

Jump to solution

Hi David, 

you can try it : 

- Get the contents of your list (ex: with   "Build string" , comma separated)
- Loop and Store it into the "content" variable.
- To export in to  CSV format use  the Attachment feature in "Send Notification"


Hope this can help you

Regards,
Reva Eka Patria

Reply
Workflow Hero

Re: Export a List to Excel

Jump to solution

When you say loop and store...loop thru each individual record and store...do I need to create a variable for each column or can I do it row by row...thx

0 Kudos
Reply
Workflow Hero

Re: Export a List to Excel

Jump to solution

Hi David, 

1. use Query List, to get all ID ( Set to colID)
2. insert For each base on query ColID  
3. In for Each action,  Insert Query list again base on txtID to get all field and store each variable.
4. In for Each action,  insert Build String base on field .

Regards, 

Reva Eka Patria

Reply