Skip to main content

I am new to Nintex and am currently working on a project that is turning out to be quite complicated for me. I currently have 6 SharePoint lists (Forms have been built and in an ideal state would be filled out by 200+ unique users each day) that I need to merge into one master file at the end of the day. I will be building out a Workflow. Is there anyone who can point me in the right direction?

Hi @ks3 



 



Could you detail reasoning for merging the data? is it to just make a big Sharepoint list or to put it all into a document? 



 



If its to just merge it all into an excel file theres an easy solution, you could go to each list and hit the export to CSV option, this will download an excel connection file, you can download multiple of these and add them all to a single excel document, then each list can be added as a new table on different sheets, the great thing about this is you can get the latest information just by hitting refresh. If you want to merge the tables excel can do this.



 



https://support.microsoft.com/en-us/office/export-to-excel-from-sharepoint-or-lists-bfb2ea48-6118-4fa9-abb6-cced9424e5d9



 



If you need a workflow to do the same for creating the data into lists, I don't suggest duplicating data like that so I will wait for your answer to my first question. 


Reply