Formatting your dates in PowerApps

Format your dates in PowerApps

Dates in PowerApps are easy, or maybe not! When I looked at dates in PowerApps today and I set a label to Now() a date was displayedas 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

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

DateTimeValue(‘Calculated Date’)

Date Time Value


Leave a Reply

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

%d bloggers like this: