Announcements
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:
Hello @bren88
The expression you are looking for is:
formatDateTime(<'YOUR DATE HERE'>,'dd-MM-yyyy')
@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'
Hi @bren88
What happens if you try and use the Action Convert time zone, under the Date Time connector?
@Jcook I found the formatDateTime now, but how do I insert my Modified colummn in here? I con't choose from dynamic selector?
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
@Jcook it displayed this : formatDateTime(2020-04-17T02:14:03Z, dd-MM-yyyy) in my Excel column?
Here's my flow:
@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:)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 58
David_MA 53 Super User 2026 Season 1
Expiscornovus 36 Most Valuable Professional
