Announcements
How we can get all SharePoint list items without the last record using get Items ?
using filter query, order by, top count?
Any idea
thanks
double call
first count
second limited
example:
Get your items
Count them
Get the short list items 😄 with your count -1
Dear @PhilippeR ,
Thank you for your solution.
but in my case i set a filter query as shown below:
so the get, also go and get the last row where contain 'LastMix' value.
It gives me the all the record -1 where contain Mix column contain 'LastMix' value.
i need 'get' to fetch all the record in the list without the last record.
thank you dear
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.
David_MA 253 Super User 2026 Season 2
11manish 172 Super User 2026 Season 2
trice602 134 Super User 2026 Season 2
