Unanswered

Strange issue with Last(SharePointList).ID result

(0) Share

Report

Posted on by PRAVEENZNMD

Hello Team,

I am facing strange issue with Last(SharePointList).ID result. It was working fine till 150 items. I am supposed to receive 151 for Last(SharePointList).ID result, if there are already 150 items in my list. But some times getting very old item ID. For instance getting 100 as Last(SharePointList).ID even though there are 150 items

Please advise

Thanks,

Praveen

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
@PRAVEENZNMD

You are better off using

First(Sort(SharePointList, ID, Descending)).ID

By using the above, you can avoid any future Delegation and/or Data-Row limit issues.

There could be a number of reasons why your original formula isn't working as expected.

EDIT

Note, the above formula will throw a delegation warning but you can ignore this because the formula is getting the First record. If you want to not see that delegation warning (but not remove the delegation issue itself) you can use this formula instead:

With( { wFirst: Sort(SharePointList, ID, Descending) }, First(wFirst).ID )

Was this reply helpful? Yes No
PRAVEENZNMD 96 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous ,

We are still facing issues with Last ID generation. We tried below formula

With(
{
wFirst: Sort(SharePointList, ID, Descending)
},
First(wFirst).ID
)

We got Last ID as 335, when we have item with ID 338. So strange

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

Like
a
(0)

Report
Copy link

Link copied!

@PRAVEENZNMD

That is odd. There's nothing wrong with the formula, it works fine on my lists.

My guess is there's something causing the issue on the SharePoint end such as some sort of permission limitations. Maybe there's an item level restriction on the last 3 items?

Was this reply helpful? Yes No