Hi @evilnw , thank you for the tip! I just realized you can run scripts. So I used the following python script to output the wk number to a string variable:
from datetime import date
today = date.today()
isodate = today.isocalendar()
print (isodate[1])
Another problem I am running into now is that I am trying to send an email with an attachment with a variable filepath that includes the wk number as a string:
U:\I\abc\def\Example(Week%str_isowknum%_%str_year%).xlsx
However I am getting a runtime error. The file exists and the email sends successfully when I replace the variables with the actual name of the file.....
The error states: U:\I\abc\def\Example(Week%str_isowknum%_%str_year%).xlsx not found
Details are:
Microsoft.Flow.RPA.Desktop.Modules.SDK.ActionException: Attachment U:\I\abc\def\Example(Week%str_isowknum%_%str_year%).xlsx not found. ---> System.ArgumentException: Illegal characters in path.
at System.IO.Path.CheckInvalidPathChars(String path, Boolean checkAdditional)
at System.IO.Path.GetFileName(String path)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at MimeKit.AttachmentCollection.Add(String fileName)
at Microsoft.Flow.RPA.Desktop.Modules.Email.Actions.EmailActions.AddAttachment(String fileName, AttachmentCollection attachments)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Email.Actions.SendEmail.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)
Is this a bug? The program seems to think I am using a character that is not allowed?
