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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Error with date values...
Power Apps
Answered

Error with date values from sharepoint lists, passed to a custom component

(0) ShareShare
ReportReport
Posted on by 35

I'm using April Dunnham's date picker component (https://github.com/aprildunnam/PowerApps/blob/master/Components/Calendar%20Component%20(4).msapp)

 

I would like to pass date values to this component. The date values are in a sharepoint list:

Capture.JPG

 

Inside the component, I set a sample table for the CalendarItems input property to:

Table({Title: "Meeting sample ",Start: "6/12/2021 1:00 PM"})

and I have a gallery inside the component with Items set to CalendarComponent.CalendarItems. This shows up as expected when I'm in the component layout, and If I'm in my screen where this component is used:

sniagsh_0-1625232051093.png

 

The problem is when I get the Title and Start from my sharepoint list, the date doesn't show up correctly:

sniagsh_1-1625232348833.png

Any idea what is going on here? As you can see, the title displays correctly, while the Start field contains a13-digit number.

 

 

Categories:
I have the same question (0)
  • Verified answer
    Al_10 Profile Picture
    1,691 Super User 2024 Season 1 on at

    @sniagsh 

     

    it looks like a Unix time.
    If you open SHarePoint list, does this date is shown as 13 digit?

    You can convert it in your app by:

    Text(1625223600000, "mm/dd/yyyy hh:mm AM/PM")

  • sniagsh Profile Picture
    35 on at

    Thanks, that worked. The time zone is incorrect using this approach, but easy to fix.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 638

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard