Unanswered

Error in Powerapps

(0) Share

Report

Posted on by SMittler

Hi,

I developed a Canvas App which is supposed to track incidents on a shopfloor and save them in a sharepoint list. Unfortunetly, we discoverd, that there seems to be a problem with more than 5000 items in the list. Non delegateable function? I don´t know! Please don´t judge me wrong, I am really a beginner.

On my start screen I have a gallery which should show the last 30 itmes filtered by the created column. See formular below.

FirstN(Sort('Schichtbuch FBR01';Created;Descending);30)

As well I have a edit screen to create new items and a detail screen to show up the 30 items from the browse screen in detail.

Can someone help and propose solutions or possible failures.

Thanks,

Sebastian

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SMittler ,

will you pls elaborate more . what is ur query ?

Thanks,
Chitrakant27

Was this reply helpful? Yes No
SMittler 10 on at

Like (0)

Report
Copy link

Link copied!

Well, is the formel I used delegatable or not. If not can you provide different solution?

Was this reply helpful? Yes No
WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @SMittler ,

If you want to get rid of the Delegation warning

With( { wList: Sort( 'Schichtbuch FBR01'; Created; Descending ) }; FirstN(wList;30) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No