web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Date format is messed ...
Power Apps
Unanswered

Date format is messed up all of a sudden!

(0) ShareShare
ReportReport
Posted on by 90

I have a label defined as....

 

Text(Last_x0020_Updated,ShortDateTime) & " by " & ThisItem.Last_x0020_Updated_x0020_By

 

It was working fine but all of a sudden it's not. I'm not sure why. I would like it to show up as....

 

5/16/2018 7:45 PM by Robert Smith

 

But, now it's showing up as.....

 

2018-05-16T19:45:21.63TZ by Robert Smith

 

I even tried this to see if I could manipulate it at all, but it showed the same thing...

 

Text(ThisItem.Last_x0020_Updated,"[$-en-US]dd/mm/yyyy")

 

I even opened the data source file in Excel and made sure the columns were formatted correctly...

Format_Cells_and_InventoryTracker_xlsx.jpg

 

The only thing I believe I changed recently was how "Items" was defined for the gallery...

 

SortByColumns(
Search(
Filter(
Inventory,
Category=ddlFilterCategories.Selected.Value),
TextSearchBox1.Text,
"Category","Product_x0020_Name"
),
"Product_x0020_Name",
If(SortDescending1, Descending, Ascending)

 

But I don't think that should matter much.

 

Any ideas why?

 

Thanks!

Categories:
I have the same question (0)
  • Lisabel0 Profile Picture
    154 on at

    What is the data source of this app?

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.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard