Delegation issue

(0) Share

Report

Posted on by hpc1

Hi,

I made the following filter for a gallery to find corresponding items in two datasets:

Sort(Filter(Absenzenuebersicht;Nachname in colTeamLernende.surname And Vorname in colTeamLernende.givenName And Datum=DatePickerAÜ.SelectedDate);Nachname)

This works fine but "in" and also "And" produce delegation warnings. Is there any other way to get the same result but with no delegation warning?

Thanks,

hpc

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hpc1

It depends on how many items are in your datasets.

Was this reply helpful? Yes No
hpc1 64 on at

Like
a
(0)

Report
Copy link

Link copied!

There will be more than 2000 items in the SharePoint list "Absenzenuebersicht".

Was this reply helpful? Yes No
shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

Could there be more than 2000 records for one day?
If not, you could use Collect to first get all records for that day and apply the rest of the filter on that collection to get the items you need in your gallery.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hpc1

See https://www.practicalpowerapps.com/delegation/power-apps-delegation-sharepoint/ for dealing with delegation issues in SharePoint. The "in" operator and the Search() function are not delegatable in SharePoint. StartsWith() is delegatable and works with Filter().

Was this reply helpful? Yes No
hpc1 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your answer. I'm somehow stuck. How can I get the same result with StartsWith() as I got with in?

Was this reply helpful? Yes No
hpc1 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for answering. As far as I understand PowerApps will just collect the max of 2000 records from SharePoint regardless of a date filter.
I tested it by setting the delegation limit to 1 and got just one record in my collection.

Was this reply helpful? Yes No
Verified answer

shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

The delegation limit will apply after filtering, so if the date is sufficient to get less than 2000 results, that would be the preferred solution.

The Startswith solution only applies to string comparisons, so unfortunately you can not use that.

Was this reply helpful? Yes No
hpc1 64 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. That helped me a lot.

Was this reply helpful? Yes No