Formatting your dates in PowerApps

Formatting dates in Power Apps

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.

Getting the current date

I still get the same dates coming back. Ok, this is good, but how about calculated fields:

A SharePoint Datefield

Calculated SharePoint Dates in Power Apps

Calculated SharePoint fields are shown in a different way.

This is weird:

Calculated fields in SharePoint

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')

Formatting dates  in Power Apps using DateTimeValue

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,912 other subscribers

Recent Posts


Thank you for visiting SharePains

%d bloggers like this: