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.
@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:)
Hello @bren88
The expression you are looking for is:
formatDateTime(<'YOUR DATE HERE'>,'dd-MM-yyyy')
Proud to be a Flownaut!
@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?
Proud to be a Flownaut!
@Jcook I found the formatDateTime now, but how do I insert my Modified colummn in here? I con't choose from dynamic selector?
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
Proud to be a Flownaut!
@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:)
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
21 | |
18 | |
9 | |
9 | |
9 |
User | Count |
---|---|
31 | |
27 | |
25 | |
21 | |
11 |