Unanswered

Power Apps Delegation Warning (SharePoint List Backend)

(0) Share

Report

Posted on by ITClown

Hello Guys,

i have Problem which i need to fix. Its about the Delegation. In this Case i get a Delegation Warning the famous yellow warning triangle.

Here some pre information for you:

I have a logfile as a sharepoint list. This logfile acts as a known error Database with the proper solution to different service Requests etc. At the moment this logfile has over 1.000 data entries.

On my power apps which i am using i want to show up on ipad, iphone this logfile for my internal colleagues. They can filter on specific columns which acts like a search function for the error.

Here the code:

As you can see we can Filter in five columns, its working very nice thanks to my lovely colleague chat-gpt 😀

The main problem is i am getting the delegation warning, besides i am using delegable function "startswith".

Power apps error code is the following one:

Delegation warning. the "Startswith" part of this formula may not work properly for large datasets.

So my main question is can i ignore this warning because it says maybe it will not work properly on large datasets or should try test it, to be 100 % sure that i won't make problems in the future.

Thank you in Advance

With Kind regards your

ITClown

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you change the 'StartWith' to
'SAP Auftragsnummer' in Suche_Auftrag.Text

Was this reply helpful? Yes No
ITClown 12 on at

Like
a
(0)

Report
Copy link

Link copied!

At first thank you very much for your reply. I appreciate every support.
Hmm the error warning still occures after your suggested change, but i guess the Filter Function "In" is anyway better than "startswith".
I am starting to think, thats just a MS move to push you forward to get the premium licence with dataverse.
Anyway this warning is confusing.

Was this reply helpful? Yes No
MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

The delegation warning is not related to the premium license. It about containing/limiting how much data is pushed around by the app. See this link : https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Some things are delegable, and others are not. I am still trying to get me head around the concept - so Unfortunately, I cant be much further help at this point in time.

Was this reply helpful? Yes No
ITClown 12 on at

Like
a
(0)

Report
Copy link

Link copied!

As far as i have come now in this case, is that "startswith" is only delegate able with text so i have to cast integers SAP order number and look for equipment into string, but as you know its hard to change the type of column after you created it.
Another thing is that i am not 100% satisfied with the "startswith" filter. We need the "in" filter which fits our goals perfectly.

So my question is there any work around for the 2k limitation like creating list or multiple sharepoint list. If yes i would be glad if you would share your thoughts on this.

Thanks into advance.

Was this reply helpful? Yes No
MissingLink 236 on at

Like
a
(0)

Report
Copy link

Link copied!

I had a similar issue where I needed to filter by dates (which are also non-delegable). The solution was to add another text column and cast the date as a string eg: text(mydate, "yyyymmdd") into the text field.
Now my filter is based on the text column and I no longer get the delegation warnings.
If you are able to add the column into your schema, that would be the simplest solution.

Was this reply helpful? Yes No
ITClown 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Guys,

i could fix the Delegation Warning Problem with a creating a collection. So if i want to Filter my Known errordatabase i dont encounter problems.
But the thing is that collection only save up to 2k Data Entries. Like i mentioned before our Database is growing daily. I need a workaround for the 2k Data Entries Limit on collection.

Any one knows a solution for this problem or Workaround?
I would be so glad.

Was this reply helpful? Yes No