Unanswered

Problem using LAST function to generate unique ref no

(0) Share

Report

Posted on by jb007

I have successfully been using the LAST function to generate a unique ref number for my sharepoint list. Formula as following

If(SharePointForm1.Mode = New,Text(Last(ContractsNew.ID).ID + 70001),Parent.Default)

I struck a problem when my list exceeded 500 items.

My Unique ref Number no longer reflected the last ID but got stuck on 70501 … As if LAST has a limitation of 500 items.

Has anyone struck this issue and is there a workaround?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

How are you populating ContractsNew, in other words, is it populated directly from the data source? Have you tried populating that in a collection and then using it in the LAST function?

Was this reply helpful? Yes No
Verified answer

PaulD1 2,914 on at

Like (2)

Report

You are hitting the infamous delegation limits. SP is sending back the first 500 items from your list and then PA is grabbing the last one, so once you have 500 records your ID will never increment.

You can go into Settings and change the limit (up to 2000) though this is just kicking the can down the road and not addressing the poor performance that results from SP sending lots of records to PA when you only need 1.

Try wrapping your ContractsNew in a SortByColumns and sort by ID descending and get the First rather than the Last item.

The sort should be delegable and occur in SharePoint and the connector should be able to fetch just the one (first) record.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Have you set the data row limit in your app to 2000? Default is 500 so maybe that is why?
File --> Settings --> enter 2000 in data row value field

If you are referencing straight from a SP list, try putting this into a label to see/get the LAST ID:

First(SortByColumns(yourSPList, "ID", Descending)).ID

EDIT: what @PaulD1 said, he beat me too it lol

Was this reply helpful? Yes No
jb007 49 on at

Like (0)

Report

Thanks Eelman … Its all logical when the solution is presented

Was this reply helpful? Yes No