Relationship between the AddColumns function and delegation in Power Apps｜DropColumns and ShowColumns also only allow the gallery to display up to 500 items.

When using AddColumns for the gallery, I had been feeling a slight discomfort for some time, so I did some research and found some interesting articles, so here are some notes.

Articles found in this issue
AddColumns cannot be delegated.
No delegation warning is displayed for AddColumns.
Can’t DropColumns and ShowColumns also be delegated?
Cannot be displayed using Dataverse as the data source
Finally.
Related articles.

Articles found in this issue

Here is the article we found this time.

The conclusion seems to be that AddColumns cannot be delegated.

Delegation workaround with AddColumns() and Filter() not showing a warning when it should.

Scenario: There is a list of locations and a list of actions. The "ActionsList" have a single record lookup column ("Loc...

Power Apps Guide - Data - Is the AddColumns function delegable? - Power Apps Guide - Blog

A question that I hear on occasions is - is the AppColumns function delegable? This question often arises when app build...

AddColumns cannot be delegated.

For example, you have an SPO list with 2001 items like this,

If you set the [Data Row Limit] in Power Apps to 2000,

When this list is displayed in the Gallery, all items can be displayed thanks to the Gallery functionality.

However, when AddColumns is used for this list, only 2000 items are displayed and delegation does not appear to be possible.

No delegation warning is displayed for AddColumns.

The main reason for not being aware of this phenomenon is that no delegation warning is displayed for AddColumns.

The first introductory article states that Power Apps Studio’s delegation warning should not be overstated.

Can’t DropColumns and ShowColumns also be delegated?

Other than that, DropColumns also fails to display all the columns in the gallery,

ShowColumns cannot be displayed as well.

Cannot be displayed using Dataverse as the data source

When Dataverse has data like this,

Set [Limit data rows] to 5,

If you display this table in the gallery, it will of course display all the data.

However, using AddColumns for this and,

DropDolumns,

ShowColumns, the data is still only displayed for the number of ‘data row limits’.

Conclusion, even in Dataverse, when AddColumns is used with DropColumns, the gallery will no longer display all data.

Finally.

However, there is no mention anywhere (as far as I know) that delegation is not possible because it ‘cannot be displayed in the gallery’, so it is possible that delegation itself is possible just because it cannot be displayed in the gallery.

However, AddColumns is obviously not delegated as it makes the app run slower.

In any case, when putting these functions into the gallery Items, it will be necessary to assume that all the data will not be displayed and may not be delegated.

Related articles.

Getting the ‘item count’ of SharePoint lists with more than 2000 items in the Power Apps Canvas app.

Because of the ‘data row limit’ and the ‘delayed loading feature of the gallery’, it was difficult to get the number of ...

Visual Guide to Power Apps: Understanding the Relationship Between Delegation and Data Row Limits (500 to 2000 Items)

It has been difficult to understand the two together, the delegation and the data row limit (the default is 500), but it...

Notes for delegation when using "Sort" and "SortByColumns"｜Comparison between SPO and Dataverse

Continuing from the last issue, I researched Sort and SortByColumns and delegation in detail. ※Previous article here. De...

Power Apps "RemoveIf" and "UpdateIf" are NOT delegable function.｜Recommend combined use with "With" or "Filter" function.

I didn't know that "RemoveIf" and "UpdateIf" are not able to delegate to data source and got unexpected results, so here...

How to write a clean Filter function in Power Apps｜Discussion of problems with the way it has been written in the past.

I have learnt how to write neatly when applying Filter to a gallery, and I have made notes on how I have tried and teste...

Power Apps SharePointリストに対して委任できる操作を色々調べてみた｜Dataverseに対して委任できる操作も

委任について詳しく調べる必要が出たので、その調査内容をメモ。委任について本当にざっくりと Power Appsにおける委任（delegation）とは、 FilterやLookUpなどの処理を、Power Apps側ではなくデータベース側