Download email attachments from outlook, create folders in local directory

[Nithinkrishna]

Kindly show the Assign activity.

Use Create Directory for creating folders.

[Steven_McKeering]

Hey @zyzz

“/” is not a valid character in the directory.

See the “/” in your Assign for “StrDate”

Update the highlighted “/” to be a “-” or “.” or “_” or another preferred character.

Hopefully this helps,

Cheers

Steve

[zyzz]

hi Steve, thank you for your reply, I tried using “-” or leaving it blank and i still get the same error, could it be there’s something wrong with the format i used to parsed in? when i write line it out i see the format is exactly the same as what i have though

[zyzz]

Hi Nithin, the assign activity is as follows

[Steven_McKeering]

Hey @zyzz

Its possible.

Replace this:

With this syntax:
CDate(item.Headers(“Date”)).ToString(“ddMMyyyy HHmmss”)

Like this post:

Get received date Mail outlook?

@Maria99 Try below expression. CDate(item.Headers(“Date”)).ToString("dd/MM/yyyy")

Cheers

Steve

[Nithinkrishna]

Did you print or check in debug mode what is item.Headers("date") ?

[zyzz]

the actual date and time stamp appears it’s uncommented out initially

[zyzz]

thanks Steve, the create folder activity doesn’t seem to be working though, still looking at that part

[Nithinkrishna]

Hey @zyzz

So the date format is clearly different from the format you have defined in the Parse function.

Kindly change the format in the second argument of Date.ParseExact function.

Thanks
#nK

[Steven_McKeering]

What’s the exception message / where are you stuck?

Plenty of people like @Nithinkrishna still here to help

[zyzz]

the excel attachment gets saved into the same folder as where i specified it to be without creating new folders as specified with the create folder activity

[zyzz]

Thanks nK,
DateTime.ParseExact(item.Headers(“Date”).ToString,“MMddyyyy HH:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“ddMMyyyy HHmmss”)

so basically i need to change the part on “MMddyyyy HH:mm:ss” to mirror this format right:
Thu, 16 Jun 2022 10:47:53 +0800

i tried looking up online for the exact date format online that includes:
, DD MM YYY HH:mm:ss <+GMT timing>
and wasn’t able to look for it - or should there be another format for this?

[Steven_McKeering]

Hey @zyzz

Take a look here for this one:

Suppose If the input is of full format

Strinput = “23/11/2022 02:20:31 +5:30”

Then to get this as Datetime

var_datetime = Datetime.ParseExact(Strinput.ToString, “dd/MM/yyyy hh:mm:ss K”)

Source:

All about Datetime - UiPath

Hi All, My recent post on datatable [All About Datatable- UiPath] (All about Datatable - UiPath) was received well in forum with great feedbacks and many suggested to provide some tutorial on topics which are discussed often in our forum In regards to that I would like to share the commonly used expression for DATETIME conversion Let’s get started one by one 1. Get Current Date in string format Datetime.Now.ToString() (Output - string type - “dd/MM/yyyy hh:mm:ss”) **To get only current da…

Cheers

Steve

[Steven_McKeering]

I am a bit confused

It saves the attachment but in the incorrect folder?

[Nithinkrishna]

@Steven_McKeering

Plenty of people like @Nithinkrishna still here to help

Cool

[Nithinkrishna]

There is a format, Let me try to post it for u in few mins.

[ppr (Peter)]

@zyzz

Message: string was not recognised as a valid Datetime.

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

[THIRU_NANI (NaNi)]

Hi! @zyzz ,

Try this way!

Save attachments with date

Hi, How to save attachments from with current date appending to it

Regards,
NaNi

[zyzz]

it saves the attachment in the main folder as specified here from the variable i created

it does not create new folders as specified in the create folder activity not sure why

[THIRU_NANI (NaNi)]

Hi! @zyzz ,

Try this

FolderPath=C:\Users\

Regards,
NaNi