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…
Hi @jpau and welcome to the forum.
(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:
Sharepoint_File_Datestamp_Example.knwf (19.9 KB)
Thanks @ScottF !
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.
you could also use the path and date&time function in the Column Expressions node. Have a look at these workflow for more details
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.