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:)
User | Count |
---|---|
23 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
23 |