I am trying to figure out if it is possible to generate an excel document that contains the queried SharePoint list results? I am trying to make a form where a user can request to have the whole SharePoint list exported to excel or grab specific rows from the list based on a search form and have that exported as a spreadsheet.
I tried to see if I could add a document trigger for the collections variable to the excel document for generation but that doesn't seem to be possible. That might make sense though since the queried results could vary as it could be pulling 1 row to as many as 100 rows from the SharePoint list.
I know SharePoint also has a built in option to export the whole list to Excel document and I am also curious if there is anyway Nintex can call that option in SharePoint.
Thanks in advance.