Skip to main content

Notifications

Announcements

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : gREj4lHJbnVNrFHezoKjTd
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Find the last record s...
Power Apps - Microsoft Dataverse
Suggested answer

Find the last record saved

Like (0) ShareShare
ReportReport
Posted on 29 Mar 2025 03:39:22 by AE-06082037-0 2
Hello
 
How can I find the last record saved in a dataverse table using a Text Column
 
Regards
Categories:
Microsoft Dataverse
  • Suggested answer
    ronaldwalcott Profile Picture
    ronaldwalcott 1,878 on 29 Mar 2025 at 03:52:55
    Find the last record saved
    Dataverse tables have a created on column
    You should be able to do something like
     
    First(Sort(YourTable, CreatedOn, Descending))
  • Michael E. Gernaey Profile Picture
    Michael E. Gernaey 37,890 Super User 2025 Season 1 on 29 Mar 2025 at 03:44:53
    Find the last record saved
     
    Can you please be more specific. what does using a Text Column mean?
     
    It sounds like maybe you are saying the below, but would be good for you to provide more details, or see below my guess at what you mean.
     
    I'd like to find the last record saved that has a value of XYZ in a text column based on a value I type into the screen? And when you say Last, I assume you mean the most recent created?
     
    Imagine you have a text input called MyInput (and this depends on Classic Versus Modern text box)
    The below, first Filters your datasource by a TextColumn being equal to the MyInput text input control
    Then it sorts it by the Created On date descending
    Then it grabs the first one
    First(SortByColumns(Filter(MyDataSource, MyTextColumn = MyInput.Text), "createdon", SortOrder.Descending))
     
     
     
     
     

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

Join us on April 2nd for the Power Platform AMA - Copilot Studio Edition
🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,636 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans