Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
News and Announcements icon
Power Platform Community / Forums / Power Apps - Building Power Apps / Date format change fro...
Power Apps - Building Power Apps
Unanswered

Date format change from SharePoint List to Power Apps

(0) ShareShare
ReportReport
Posted on by CU14101822-0
I have a SP list with multiple columns. One of the columns is date type. I have a Power Apps with a dropdown field that retrieves and views the data type column from the SP list, but the date format comes back in a very different format. For example, 29/10/2024 would return 165524400000 . I can't find a way to mitigate this. Does any one have a solution?
 
Categories:
Connectors
Mobile App
General Questions
  • WarrenBelz Profile Picture
    WarrenBelz 143,591 on at
    Date format change from SharePoint List to Power Apps
    This will display all the dates in Text 
    ShowColumns(
   AddColumns(
      Sort(
         SPList,
         YourDateField,
         SortOrder.Descending
      ),
      DateTxt,
      Text(
         YourDateField,
         "dd/mm/yyyy"
      )
   ),
   DateTxt
)
    Just be aware that writing it back as a Date will have some complexities (caused mainly by dd/mm/yyyy instead of the USA standard mm/dd/yyyy ) - the Data Card Update
    With(
   {
      _Data: 
      Split(
         YourComboBoxName.Selected.DateTxt,
         "/"
      )
   },
   Date(
      Last(_Data).Value,
      Index(
         _Data,
         2
      ).Value,
      First(_Data).Value
   )
)
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee
     
  • Srini007 Profile Picture
    Srini007 2,817 on at
    Date format change from SharePoint List to Power Apps
    Hi,
     
    You can write as below
     
    Text(DateValue(YourSharepointDateColumn), "[$-en-US]dd/mm/yyyy")
     
     
    If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.
    Regards,
    Srini
     

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

News and Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans