I can get this to work when writing an excel file to a “normal” file share, but cannot seem to get it to work with a SharePoint connection. So the use case is to use a “Create Date&Time Range” node to append the current date to a file name, and then pass this as input to an Excel writer node. Since this is a SharePoint location I also need to turn on a “File system connection” and when I do this, the Excel Writer node does not accept the variable with the full path, even though it is converted into a path variable…
(I moved your question into its own topic since I thought it was specific enough that it might help others.)
Here’s an example workflow that I think should get you what you want, or at least pretty close. I tested on my system and it worked, at any rate. See what you think:
That did the trick. The part that I had difficulties wrapping my head around was where in the flow to apply the path variable, and your solution illustrates that perfectly.
