Announcements
Hi,
I am working on an app and i am trying to find the first entry and last entry of a Work Order.
I know how to get the first and last entry from the list, although i am struggling to get the first and last entry based on a work order ID.Hope this makes sense. Cheers
Perform the First/Last on the Filter of the datasource? E.g.
First(Filter(MyDataSource, ID = DesiredID))
Can you post a bit more detail?
Hi @gman91 ,
Do you want to sort the table according to work order ID and find the first, last record?
Try this formula:
First(Sort(tablename,order ID))
Last(Sort(tablename,order ID))
Best regards,
Community Support Team _ Phoebe Liu
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 530
WarrenBelz 459 Most Valuable Professional
Haque 314
