Hi team,
I want to download the excel file from a sharePoint and drop it into my Data folder under my project.
However, I want the file to have time timestamp before being stored in the folder.
Can anyone help!
Cheers!
Hi team,
I want to download the excel file from a sharePoint and drop it into my Data folder under my project.
However, I want the file to have time timestamp before being stored in the folder.
Can anyone help!
Cheers!
Hi @Sisay_Dinku
You can add the time stamp like this:
yourFileName+"_"+Now.ToString("MM/dd/yyyy")+"[file extension]"
Hope this helps,
Best Regards.
Where can I add that? from the above screenshot.
Path.Combine(Environment.CurrentDirectory, “Data”,“temp”)
Try this
Path.Combine(Environment.CurrentDirectory, "Data","temp-" + Now.ToString("yyyy-MM-dd") + ".filetype")
/
and \
are not allowed in folder/file names.
In the above expression, you can add it like this:
→ In as Assign activity, initialise file path:
yourFilePath = yourFileName+"_"+Now.ToString("MM/dd/yyyy")+"[file extension]"
→ Then include it in the expression:
filePath = Path.Combine(Environment.CurrentDirectory, “Data”,“Temp”,yourFilePath)
Hope this helps,
Best Regards.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.