Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 519 Super User 2025 Season 2
Tomac 296 Moderator
abm abm 232 Most Valuable Professional