Multitab SharePoint Outout

[Ctraore]

Hello, 

I am trying to produce an Excel output with multiple tabs that will be stored in SharePoint. However, using the SharePoint Output Tool and I am not able to get the desired result. The best I was able to achieve was to produce 2 separate Excel files. Like mentioned above, I would like to have them in 1 Excel file with multiple tabs. I am not sure whether it is doable with SharePoint or not. I attached the workflow here for review. Please assist. Thank you.

[alexnajm]

I am not sure why it's doing that - I just tried it on my end and it worked fine! You need to change "rename" to "overwrite sheet"

[Ctraore]

Hello,

Thanks for your reply.

This is what I was mentioning in my earlier post. Anytime I choose a configuration other than "Rename", it only prints the 1st SharePoint Output and I get an error message for the second SharePoint Output. Please see the new screenshots.

In the first screenshot, I chose the same file path for both SharePoint Output Tools and named the files "Sales Data". The second screenshot shows the how both SharePoint Output tools were configured to overwrite the Sheet. However, only the first SharePoint Output writes a file, and the second Output gives me an error. 

Keep in mind that these are supposed to be new files that I am creating. I am not updating an existing file. So, essentially, the question is to figure out whether or not we can create an Excel Output with tabs using multiple SharePoint Output tools. Thank you.

[alexnajm]

Funny, I don't get that error with the same configuration.

And ah ok, the new files wasn't apparent to me originally. Converting the solution Gawa presented into a batch macro that cleanses out null columns with a Data Cleansing tool before the SharePoint Output should address that then - basically making sure that even though your data may have different columns when you union them together, the Data Cleansing will ensure you only have the columns that have data coming through into the final output.

Otherwise you said Control Containers weren't successful - I am surprised by this so I might recommend taking a closer look. Good luck!

[lwolfie]

Were you able to figure this out?  I'm running into a similar problem and have tried the suggested approaches.  I'm on 2023.1 and haven't even tried using server yet.

[paulhardmangilead]

I am also encountering the same problem - even with control containers, the Sharepoint Output tools will overwrite each other, so three Sharepoint output tools in three Control Containers with three different configured sheet names results in just one sheet in the output file.