We have recently moved our storage system to Sharepoint and I have been struggling to convert some existing workflows to the sharepoint outputs and also run them on gallery.
Current issue - I had a workflow that used a formula tool to establish the File Name and Sheet name dynamically.
I want to output to the existing file name if it exists, or create a new one if not, and then also create a new sheet dynamically by a field name, and overwrite sheet if not.
I've attempted to set this up in the sharepoint output tool but am getting an error of "Worksheet does not exist".
I then tried to establish the file and sheet name in a formula tool again and got an upload error of "run time error error while uploading file but expected one of bytes, unicode"
Looking for any guidance - I am able to run the workflow successfully if overwriting the FILE but not Overwriting the Sheet.
