Write Datestamped FileName to Sharepoint

Hi.

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…

Any thoughts?
KR

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)

3 Likes

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.

/jpau

2 Likes

Hi jpau,
you could also use the path and date&time function in the Column Expressions node. Have a look at these workflow for more details

Bye
Tobias

5 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.