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

Outlook to Excel Flow - Format Date Time Issue

Hi All,

 

I am a beginer, trying to setup Flows for my routine works like following up emails. 

I am setting a Flow - Which will insert a row ina Excel spreadsheet with Subject and Date when I flag a email in outlook.

 

Everything works fine except DateTime stamp output format from Outlook is not recoganised by Excel!!

 

I have read in community message here below formula works,

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

 

But unfortuntley, It doesnt work for me, may be I am making a mistake inserting it in the flow.

(I have attached a screen shot how I am inserting it now).

 

Kindly advise where and how should I insert this formula in the Flow. Thanks.

 

 

Screen Shot 02-14-20 at 02.43 PM.PNG

 

 

Raja.

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Outlook to Excel Flow - Format Date Time Issue

Hi
Your trigger is 'when an email is flagged', right?
Then you need to replace
triggerBody()?['start']
in your expression and add the equivalent reveived date time from your trigger, you should find it by editing your expression and switching to 'dynamic content'
Not in front of my desktop, but I think it's called
triggerBody()?('DateTimeReceived')

 

If I were you, I would try the following

formatDateTime(triggerBody()?('DateTimeReceived'), 'dd/MM/yyyy')

 

I am also assuming your excel destination column does not have Date format, if I am wrong please let me know, because in such case we need to convert it into a number. As explained in the following link, Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.

https://support.office.com/en-us/article/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252


Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

1 REPLY 1
Dual Super User
Dual Super User

Re: Outlook to Excel Flow - Format Date Time Issue

Hi
Your trigger is 'when an email is flagged', right?
Then you need to replace
triggerBody()?['start']
in your expression and add the equivalent reveived date time from your trigger, you should find it by editing your expression and switching to 'dynamic content'
Not in front of my desktop, but I think it's called
triggerBody()?('DateTimeReceived')

 

If I were you, I would try the following

formatDateTime(triggerBody()?('DateTimeReceived'), 'dd/MM/yyyy')

 

I am also assuming your excel destination column does not have Date format, if I am wrong please let me know, because in such case we need to convert it into a number. As explained in the following link, Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.

https://support.office.com/en-us/article/datevalue-function-df8b07d4-7761-4a93-bc33-b7471bbff252


Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,841)