SharePoint Files Output Tool: Appending Columns on Select SP Sheets and Preserving Formats

[ualejo]

Hi folks, 

Ask: I am relatively new to Alteryx, so I was hoping to get some insights on how to update existing excel files, with multiple sheets, on my SharePoint. 

Workflow Info: I blended data from Google Analytics (GA Sessions) with a report I have on SharePoint (which includes info on select url slugs and keywords), and I appended the blended data sheet to the original SharePoint excel file via the SharePoint Files Output tool. It seems, however, that the SharePoint Files Output tool cannot append specific columns (my GA sessions column) by sheet, as the append functionality under "Existing File Action" dropdown only appends the blended data sheet . Is there a way to append SP excel sheets with select columns via Alteryx? 

2nd Ask: Also, when I use the SharePoint Files Output tool, it wipes the original formatting, formulas, and color schemes on the  SP file. Is there a way to direct the tool to "Preserve Formatting on Overwrite," similar to the Output tool? 

[susanz]

I am also curious about the 2nd ask. Looking to see how I can preserve formatting for output Excel sheets using Sharepoint Files Output tool, similar to the normal Output tool. Thanks!

[CarterJ]

Also interested in the 2nd Ask.

Using SharePoint Output tool is it possible to:

1) define a range and preserve formatting (just like the normal Output Data tool)

2) take file/table name from field (such as when wanting to add date to file name each day, like you can do with Output Data tool)