Multitab SharePoint Outout

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.

Screenshot.png

Test.yxmd

Sharepoint

Accepted answers

All comments

alexnajm

I remember this thread addressing it - does this help? Solved: SharePoint output tool- create new Excel file and ... - Alteryx Community

Ctraore

Yes, I saw the same thread. I tried using the Control Container Tool without success. I also tried following Gawa's instructions, but it does not really work for me as the Summary Tab and the Full Table tab are conveying different information. As a result, the instructions do not work neither. Do you have another approach I can try? Thanks.

Ctraore

Sorry, I tried to respond to you but just posted my response above.

alexnajm

I am sorry, I don't have another approach - if they convey different information, then two SharePoint Output tools are your easiest solution

Ctraore

Alright, thank you.

alexnajm

You can still output to different tabs in the same file - what has been the issue with setting the same file / different tabs?

Ctraore

Yes, I can output to different tabs in the same file using a formula tool for the path and then a regular output tool, but that will require outputting to a local drive or a network drive. That defeats the purpose of what we are trying to achieve as the company is going away from the network drives. Everything is moving to SharePoint. So, we are trying to see if we can produce the multiple excel tabs output in SharePoint as we are normally able to, using the regular output tool. But I don't think the formula tool works in using SharePoint Output tool unless I am mistaken. But that's why I need guidance, if it is possible to achieve a multiple tab output in SharePoint. Thank you.

alexnajm

I understand, but I am confused - are you saying you are unable to specify a different tab in the same file in each SharePoint Output tool you have?

Multitab SharePoint Outout.png

Ctraore

I am able to configure the SharePoint output tool. However, it is printing separate files instead of adding a tab. So, maybe my configuration is incorrect but I have tried different configurations, and this is the one that actually prints both files. When I tried overwriting for example, it only prints one file and I get an error for the second file. Please see the attached screenshots below. Thanks.

Configuration screenshot.png

Output Screenshot.png

Excel Output Screenshot.png

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.

File location and Name.png

Suggested Configuration.png

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!

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.

raxit

Thanks for the idea!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703