convert datetime format

[bren88]

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:

[Jcook]

Hello @bren88 

The expression you are looking for is:

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

[bren88]

@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'

[Jcook]

Hi @bren88 

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

[bren88]

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

[Jcook]

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

[bren88]

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

Here's my flow:

[bren88 · Accepted solution]

@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:)