Announcements
Hello-I am working on a project that uses a SharePoint list as my primary data source. The SharePoint list has a lookup column called Class ID, which brings over a class start and end date. The issue I am having is that the date is showing in Power App as 2024-02-26T08:00:00Z. I only need it to show MM/DD/YYYY. I have found a lot of information on changing dates, but am not able to apply since the dates showing are from a lookup value. Any idea on how I can convert this, so its showing correctly in Power Apps as MM/DD/YYYY?Any help would be amazing.
Hi,
DateValue("2024-02-26T08:00:00Z") will result in: 26/02/2024
you can also format it with text():
Text(DateValue("2024-02-26T08:00:00Z"),"mm/dd/yy") to show what you need.
although you may get the correct format already from the first command if this is your regions default format (i think)
Thank you for your reply. I am extremely new to Power Apps, which is why Im having a couple of issues the date being one of them. I know how to display the date if its entered into Power Apps, but im still a bit confused how I how Display the date correctly if its coming from SharePoint (Lookup) column. Do I put this code in the Display section of the field in Power Apps? It does not seem like it should be this hard, but its vexes me greatly. That and I am very confused on my checkboxes in Power Apps keeps going aways after I submit part of my form.. But that’s for another place. This project is due Thursday and I am getting concerned I wont figure these things out.
You said the date is showing in power app as: 2024-02-26T08:00:00Z how is it being displayed? date picker, label?
let me know what is it and paste the code from default property, I will be able to help you further.
Thank you again.
The item is displayed as : Choices([@'Student Profile - Processing New Hire Training'].'Class ID:Start Date')The default is blank.
DateValue(Choices([@'Student Profile - Processing New Hire Training'].'Class ID:Start Date'))
or if you want to format it further edit the format with:
Text(DateValue(Choices([@'Student Profile - Processing New Hire Training'].'Class ID:Start Date')), "mm/dd/yy")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211
