Building a Flow to get an excel attachment from an email, upload to One Drive Folder and time stramp it.

[Dan24]

Hi All

Please advise if you can assist on the below which i am trying to create in Flow: 

When a new email arrives in my Outlook 365 Inbox with an excel attahcment i would like flow to extract that excel attachment and upload it to my One Drive Folder called "Oracle Excel". Sometimes i am dealing with multiple excel files with different or similar names and i would like to find a way to put a date and time in the excel attachment name like "Oracle Report 18/05/2021 6:50pm".

I would also like to make sure that files with similar names should not overwrite each other hence i woud like to put a date and time stamp. Also the date and time needs to be in Australian Eastern Standard Time. 

I would like for the timestamp date and time to appear at the end of the attachment title for example it should be "Oracle Report - 18/05/2921 6:50pm" and not "18/05/2021 6:50pm Oracle Rreport.xls"

Please advise if you can assist.

[v-duann-msft · Accepted solution]

Hi @Dan24 

Thank you for posting.

According to your description, you would like to add time stamp into file name in ‘AUS Eastern Standard Time’. If any misunderstanding, please kindly let me know.

As per my test, we can achieve most of your requirements including add time stamp and show it as AUS Eastern Standard Time. However, we can’t insert special characters like ‘:’ and ‘/’ into filename. That is not supported right now in sharepoint. All unsupported characters will be automatically replaced by ‘_’. So we can't use format like that:18/05/2921 6:50pm.

Restrictions and limitations in OneDrive and SharePoint - Office Support (microsoft.com)

Instead of the point I mentioned above, we can reach your goal using below flow:

Flow in detail:

Convert to AU Eastern timezone: convertTimeZone(utcNow(),'UTC','AUS Eastern Standard Time','dd/MM/yyyy HH:mm')

Insert date&time to file name :replace(outputs('Get_Attachment_(V2)')?['body/name'],'.',outputs('Compose'))

When I send email with 4 attachments and 2 of them are excel, the flow goes and only excel files copied to onedrive:

https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones

Hope the content above may help you.

Best regards,

Anna

[Dan24]

thanks very much!