How can I get a Date & Time column to display correctly in GMT/UK format in PowerApps?
In my SharePoint list my due date column is displayed correctly:
23/09/2020, 12:18:02
I want this column to display the same in PowerApps, currently it is not!
I have tried Text(DateValue(Parent.Default), "[$-en-GB]dd-mm-yyy-HH-mm-ss")
However this displays at 23/09/2020-00-00-00
Solved! Go to Solution.
Try
Text(Parent.Default, "[$-en-GB]dd-mm-yyy hhmm ss")
Or
Text(DateTimeValue(Parent.Default), "[$-en-GB]dd-mm-yyy hhmm ss")
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Try
Text(Parent.Default, "[$-en-GB]dd-mm-yyy hhmm ss")
Or
Text(DateTimeValue(Parent.Default), "[$-en-GB]dd-mm-yyy hhmm ss")
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Thank you, the second option worked. I tweaked the formatting a bit:
Text(DateTimeValue(Parent.Default), "[$-en-GB]dd/mm/yyy hh:mm:ss")
😉
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
183 | |
71 | |
37 | |
33 |
User | Count |
---|---|
344 | |
274 | |
118 | |
76 | |
58 |