Announcements
Good day, My issue is the following :I have an app in which people can create and manage Claims, the Data sources of this app are SharePoint List. Each claims is assigned an ID based on the latest SharePoint ID + 1, however due to the fact that you can only pull 2000 rows max from SharePoint everything after a certain point become the same claim number.My plan was to first filter the Sharepoint List by ID in order to have the latest ID on top of the list to allow PowerApps to read it without having to pull 2000+ rows to find the latest ID. I just can't seem to make it work for some reason.Find attached the portion of the code that is currently working but cause issues with the claim number every time we reach 2000+ rows."main" is the name of the SharePoint List I need to filter.The red square shows which part of the code needs to be amended with the "filter" or "sort" or "sortbycolumns".
Try this instead of filter:
First(Sort(main, ID, Descending)).ID + 1
If you need additional help please tag me in your reply and please like my reply.If my reply provided you with a solution, pleased mark it as a solution ✔️!Best regards,Gonçalo NogueiraCheck my LinkedIn!Buy me a coffee!Check my User Group (pt-PT)!Last Post on CommunityMy website!
It is indeed working, thank you for your help, I've been struggling with this for some time now.
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 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211
