A while back I wrote about formatting dates in Power Automate. Today it’s Power Apps time!
Dates in Power Apps
Dates in Power Apps are easy, or maybe not! When I looked at dates in PowerApps today and I set a label to Now() a date was displayed as expected in dd/mm/yyyy hh:mm format. This is all easy, but what if the dates come from SharePoint.
I still get the same dates coming back. Ok, this is good, but how about calculated fields:
Calculated SharePoint Dates in Power Apps
Calculated SharePoint fields are shown in a different way.
This is weird:
Now the dates come back in a different format. How do I get the right date format back? The solution is easy. I had a look through my PowerApps Function as and Expressions post from a while back and found the DateTimeValue function
Formatting dates properly
All we now need to do is use the DateTimeValue function to convert the weird looking date format back to a proper date and time.
DateTimeValue('Calculated Date')
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There’s a better way — and I can show you exactly what it looks like. I’m the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I’ve been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://staging.sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://staging.sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@staging.sharepains.com
Leave a Reply
You must be logged in to post a comment.