cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

convert datetime format

The Modified column in my Excel table is displaying as yyyy-MM-ddThh:mm:ssZ

How can I change it to just dd-MM-YYYY ?

I don't seem to have the formatDateTime expression. Here's my flow showing the Modified column:

Capture2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Re: convert datetime format

@Jcook thank you for your help so far, got around the problem in the end by following this

https://powerusers.microsoft.com/t5/Connecting-To-Data/formatDateTime/td-p/24013

The following now works:)

Capture5.PNG

View solution in original post

7 REPLIES 7
Highlighted
Super User
Super User

Re: convert datetime format

Hello @bren88 

 

The expression you are looking for is:

formatDateTime(<'YOUR DATE HERE'>,'dd-MM-yyyy')

 





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Helper II
Helper II

Re: convert datetime format

@Jcook I don't think I have access to this expression, it's coming up with :

 

'australia.flow.microsoft.com says the expression is invalid'

Highlighted
Super User
Super User

Re: convert datetime format

Hi @bren88 

 

What happens if you try and use the Action Convert time zone, under the Date Time connector?





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Helper II
Helper II

Re: convert datetime format

@Jcook I found the formatDateTime now, but how do I insert my Modified colummn in here? I con't choose from dynamic selector?

Capture3.PNG

Highlighted
Super User
Super User

Re: convert datetime format

Hi @bren88 

 

So before the Excel action add a Compose action. Inside this action use the formatdatetime() expression.

 

You almost have the expression right do not add the <>

 

You want to type the expression than inside the () select your dynamic content

 

Than inside your excel action reference the Compose action for your modified date





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up ?


Proud to be a Flownaut!





Highlighted
Helper II
Helper II

Re: convert datetime format

@Jcook  it displayed this :    formatDateTime(2020-04-17T02:14:03Z, dd-MM-yyyy)    in my Excel column?

Here's my flow:

Capture4.PNG

Highlighted
Helper II
Helper II

Re: convert datetime format

@Jcook thank you for your help so far, got around the problem in the end by following this

https://powerusers.microsoft.com/t5/Connecting-To-Data/formatDateTime/td-p/24013

The following now works:)

Capture5.PNG

View solution in original post

Helpful resources

Announcements
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!

Top Solution Authors
Top Kudoed Authors
Users online (6,206)