Export form sublist to Excel

Discussion created by GarethJ1 on Mar 14, 2019
Latest reply on Mar 18, 2019 by ChristofN

Hi everyone


I've got a form setup in SharePoint for recording expenses.  Each expense item is recorded in a sublist on the form that points to a separate SharePoint list and this all works fine.


I've now been asked to provide functionality where the sublist in the form can be exported into an Excel spreadsheet.  If I select all the items in the sublist by clicking the top left-hand corner I get an option on the SharePoint ribbon to Export to Excel but this only seems to work with Internet Explorer which we are moving away from.  Is there a way I could build this functionality within Rich Forms e.g. create a button that runs some code to export the sublist to Excel?  I've had a look and so far haven't been able to come up with anything that works.


I'd be grateful for any advice.  Thanks in advance for your help.