Automation is set up to perform the following steps:
1. Copy a blank excel template to a specific file name with data suffix (copy file action).
2. Execute a SQL query and write to a specific tab in the Excel file (select to file action)
3. Execute a second SQL query and write to another tab in the same Excel file (select to file action)
Everything works except for the last step – although the query brings back data, there is nothing on the second tab when the query finishes.