Announcements
I have Dataverse table Drives.
I have there Purpose column.
I need to find the last (newest) record where Purpose = "Gaspump".
From that particular record I need to return its Created value.
How to accomplish this?
Hi @Finnair,
Please try the code below. The code might vary slightly depending on the column type (choice or text):
First( Sort( Filter( //Change to the correct Dataverse table name if necessary Drives, //Should it be a choice column use Purpose = ChoiceListName.Purpose Purpose = "Gaspump" ), 'Created On', SortOrder.Descending ) ).'Created On'
If this solves your question, would you be so kind as to accept it as a solution.Thanks!
@LaurensM
O-M-G
It works!
Amazing, thanks very much!
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 326 Most Valuable Professional
11manish 168
sannavajjala87 75 Super User 2026 Season 1
