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:
Solved! Go to Solution.
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
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!