cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Outlook to Excel Flow - Output date format is reversed from dd/MM/yyyy to MM/dd/yyyy only for some items!!

Hi All,

 

I am writing a Flow for Outlook to Excel - When I flag an email in Outlook it is added as a new row in a Excel sheet. I am capturing Date and Subject in that row.

 

I am using below expression string,

 

formatDateTime(triggerBody()?['receivedDateTime'],'dd/MM/yyyy')

 

For some strange reason - When I flag about 20 emails, about 10 emails date s are captured in wroong format, i.e  MM/dd/yyyy (reversed). I peeked in to the code, where Output shows in the correct format i.e dd/MM/yyyy

 

I could not figure out where is the issue. Kindly advise.

 

1 REPLY 1
Resolver I
Resolver I

When I read a date field from excel it comes in as a number which is the number of days since 12-30-1899 (30th December 1899).

 

I am fairly sure that if it is a datetime it comes in as a decimal value (sorry have not needed to decode a datetime).

 

Anyway, to turn it into a date I use the following

 

formatDateTime(adddays('12-30-1899',int(variables('Cstart')),'yyyy-MM-dd'),'dd-MM-yyyy')
 
I am just wondering if you reversed this to get your dates as a number and store that into excel - then it would solve the 'inconsistancy issue'?
 
 
Stan

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (11,804)