Unanswered

Power Apps changing date format (SP Lookup column)

(0) Share

Report

Posted on by jmccune1

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

elseb 774 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
jmccune1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
jmccune1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you again.

The item is displayed as : Choices([@'Student Profile - Processing New Hire Training'].'Class ID:Start Date')
The default is blank.

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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")

Was this reply helpful? Yes No