SharePoint Output Tool

[DanielG]

Hi all,

I am outputting data as an Excel file to SharePoint document library as part of any Analytic App.  I dynamically create the file name and the sheet names in formulas, then use those in the SP output config AND I deselect the 2 options to have file name and sheet name in output.

However, when I run it the workbook name appears in the output but the sheet name does not.

Can't not figure out why this is occuring or anyway to fix it.

No errors or warnings in the process either, so it is running successfully to completion.

Anybody experienced this and have a solution?

Thanks

[Dean4U]

Hi @DanielG, 

Thanks for reaching out to the community. Not sure if this will solve your issue, but I think it's worth trying first to verify that your dynamically generated sheet name field is mapped correctly as the sheet name in the output tool configuration. You should also double-check that this field has a value at runtime (you can use a browse tool right before the output to verify).

Also, please ensure that the sheet name contains no invalid characters and that you haven't accidentally selected the "Overwrite Sheet" or the "Append to Existing Sheet" option, which could cause Alteryx to ignore dynamic sheet names.

If the issue persists, please log into your MyAlteryx (https://my.alteryx.com) account, click on the 'Case Management' tab, and tap the 'Submit a Case' button to create a support ticket for this concern. You can mention all these details there, which will allow our support team to investigate this issue.

Additionally, you can also check out this SharePoint guide that Megan Bowers created a few weeks ago for additional resources.

Hope this helps.

Take care.