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 / Display date from shar...
Power Apps
Answered

Display date from sharepoint in label powerapps

(0) ShareShare
ReportReport
Posted on by 122

I have a label in powerapps where I want to show the latest date from a sharepoint list.
I have tried: First (Sort (TestFuel; SisteTest; Descending)) .SisteTest
It's fine until a newer date comes in. It works when I change to Ascending, but if this date is deleted then the wrong date is displayed back from SP (the lowest date is displayed).

Is there a better way to code this label?

Categories:
  • ArchitectMadhan Profile Picture
    1,584 on at

    I have tried your formula in Power Apps to fetch date value from SharePoint list.

    Formula: First(Sort('Task Tracker','Due date',Descending)).'Due date'.

    But the only difference I see from your formula and my formula  is "," in the place of ";" (you have used).

    ArchitectMadhan_4-1626246219709.png

     

    SharePoint list view: The latest date value is 7/8/2021

    ArchitectMadhan_0-1626245710520.png

    In the canvas app it is showing the recent date correctly.

    ArchitectMadhan_1-1626245773771.png

    When I have added new event list item with latest Due Date (7/23/2021), it picked the value correctly as shown below.

    ArchitectMadhan_3-1626246136934.png

     

    But you need to refresh the page in Power Apps

    ArchitectMadhan_2-1626246050725.png

     

    If you find my solution helpful for resolving the issue, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • ENRM Profile Picture
    122 on at

    @ArchitectMadhan 

    Found the error. The column  in SP was not formatted as date.🙈

  • Verified answer
    v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @ENRM ,

    Glad that you have found the cause and slove your issue.

    You can mark your reply as a solution. This will benefit other community members who stuck with the same question.

    Best regards,

    Allen

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard