web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Last ID Number Based o...

Power Apps

Answered

Last ID Number Based on Sharepoint List ID Column it's not Working

(0) Share

Report

Report

Posted on by WendeReisss

253

Hi Guys. I need help:

I have the follow formula in my text property of "Text Input" field:

Text property: Last(InboundList).ID+1

So my Sharepoint list has 658 lines and the last ID is 658, but my Power Apps Text input with the formula above (last ID) stopping working (freeze) in ID 637. It's happend after I done I new publish and I don't now if is a Power Apps bug, or some error after a certain quantity of ID using this formula happen. Please, see cover photo to understand better my explanation.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

EddieE 4,643 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@WendeReisss

I'd say there have been some deleted items from your list and your app is only returning the default number of rows, which is 500. You can set this to a Max of 2,000 by going to settings and changing the Data row limit to 2000.

However, for your situation, you'd be better off using a different formula, ie

First( Sort(InboundList, ID, SortOrder.Descending)).ID+1

Using this formula, you don't need to adjust the Data row limit because it will always get the last ID, no matter the List size.

Was this reply helpful? Yes No
WendeReisss 253 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect!!!

I've used the formula you wrote and it worked well.

Thank you so much my friend.

Was this reply helpful? Yes No

Join the conversation