Can we create a new Excel workbook based off of a Excel template similar to what Google Forms Publisher does once a form is submitted.
Not really sure why !!!
you can add, delete, update rows and columns, create new sheets but not new workbooks.
Unless you buy a 3rd party connector @plumsail and triger it from there.
Sometimes it seems Microsoft blocks Tier A developments in order to allow 3rd parties to sell at customer expense. Excel is from Microsoft and what they're telling us is to "please purchase a 3rd party" to manage our products.
I also need this functionality and my customer is not ready to buy a third-party solution. So I think the only way is I should go with the non-flow solution.