Answered

Anticipating Power Apps Delegation Behavior for Canvas App

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am using an old Power Apps canvas app template, "Shoutouts App" and I have fixed all the errors inherent with the template and made some customizations. Now I want to make sure I understand the Power Apps delegation implications and how the Activity Feed will work once there are >500 records or >5000 items in the ShoutoutsData SP list.

The search box in the header is txtSearchActivityFeed, which searches users and is referenced in the Activity Feed's gallery Items code. Since there are no delegation warnings in the gallery's Items code or any other place, I am expecting the Activity Feed gallery to display 100 records at a time and then increase to the next 100, etc. However, once there are >500 items in the SP list, will my txtSearchActivityFeed user search be limited to the first 500 records SP returns to Power Apps? Are there any other considerations that I need to be aware of once there are thousands of records in the SP list?

Shoutouts App Delegation graphic.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

The formula you have is delegable, so you will be able to get the most recent x number of records (where x is the limit of your app settings).

You will only be missing items that are after that limit and time (and since you sort descending, those will be older ones).

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes - Thank you for your quick response. Since in Settings I have the data row limit for non-delegable tasks set to 500, then all searches will return results from the most recent 500 records, correct? If I increase that number from 500 - 2k, it is my understanding that it will impact performance. Do you recommend keeping it at 500?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

So, the record limit and the delegation are two different things. Record limit defines the total number of records that will be returned from any datasource.

Delegation refers to the ability to "off load" a query to the datasource to return results.

So, with your formula, if there were 100k records in your datasource, then your filter would still delegate to the datasource and you would get the most recent (again because of the sort - which is delegable) x number of rows (and again, x being the total record limit setting).

So for your scenario, the only reason to increase the record limit would be because you want to show more activity than the current amount. If limiting to the last 500 is sufficient, then there is no need to increase.

I hope that is fairly clear.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes - Thank you for clarifying these points. I really appreciate it!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Any time!

Was this reply helpful? Yes No