Answered

App does not pull the last number from the Excel worksheet column

(0) Share

Report

Posted on by Eric_S69

Hello community,

When the App I created is opened I want it to generate a unique follow-up number from an excel worksheet called Complaints on OneDrive. The code for this in Default = Last(Complaints).ID+1

Normally this works fine but at some moments I have the issue that the App generate numbers starting with 1 even when there are already numbers in the worksheet ID column.

Could this be a connectivity issue? How can I stop the App from creating a new number that is already in the column?

Thanks in advance. Eric

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

@Eric_S69

Your problem is that Last() is not delegatable in Excel. Set the Default to First(Sort(Complaints, ID, Descending)).ID+1

First() is also not delegatable but it doesn't matter since Sort() is delegatable.
Eric_S69 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp Thanks a lot. I've changed the formula to your advice.
I trust the issue is resolved now, time will tell. 🤞
Eric_S69 7 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp
I have tested your solution and it didn't solve the issue, it even got worse. Each time the count starts at 99 and added 1, so each new report/number is 100. I have reset the old formula and added a delay in the App, that way the possibility for connection issues is minimized. If you see any other formula solution I'm willing to try them.