setting a variable is not allowed in "OnStart" App property

(0) Share

Report

Posted on by Calcioscacchi

413

Hi there.

Coming back from vacations, my app gives me an error,

This is the code that I've written in app property:

Set(ID_Last;First(Sort('T9 Segnalazione eventi macchina';Inizio;Descending)).ID);;

"Inizio" is a date/hour time field that you can translate with TimeStart: in my table, I need to check the most recend row in order to close that row (valuing a TimeEnd value) and create a new row with a new TimeStart.

Actually I have more than 5000 rows in my Sharepoint list. But in other apps (which are a copy of this one with the same code and the same columns in their tables) I reached 9000 and more rows.

The row data limit is actually set on 2000:

Can you help? Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!
Have you tried using the SortByColumns function?
Set(ID_Last, First(SortByColumns(Demo, "Created", Descending)).ID)

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
Calcioscacchi 413 on at

Like
a
(0)

Report
Copy link

Link copied!

That seems to work.
Can I ask you the difference?

Was this reply helpful? Yes No
Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!

There are differences on how Sort and SortByColumns handles delegation:
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview#sorting-functions

Was this reply helpful? Yes No
Anchov 1,986 on at

Like
a
(1)

Report
Copy link

Link copied!

If you are asking the difference between the two functions, to be honest, there is a bit of overlap between the functionality but:
1. Sort - You can sort by columns but also can sort with more complex logic \ expressions. For example, if you wanted to add multiple columns together and then sort on the result.
2. SortByColumns - You can only sort on the columns available in your data source.

As seen, both functions are delegable, but there are more restrictions on the Sort function. So if you can get your needed functionality using SortByColumns function, that is the one I would use first.
Source: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sort

Was this reply helpful? Yes No