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

Here is the article we found this time.

The conclusion seems to be that AddColumns cannot be delegated.

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.

コメント

Copied title and URL