We investigated the behavior of the With function when used with the Items property (data source) of the Gallery in the Canvas application.
- What we want to check this time
- Case 1 : Assigning the result of a Filter to a variable of the With function
- Case 2: When the value used for the conditional expression of Filter is put into a variable of the With function
- Case 3: Assigning a variable that is not used in any Filter expression in the With function
- Extra: If you use variables declared in UpdateContext or Formulas, the delayed read function will work.
- Related articles.
What we want to check this time
In this article, we will check the behaviour of this gallery when the With function is used for the Items property.
Case 1 : Assigning the result of a Filter to a variable of the With function
First, when assigning the result of the Filter to a variable that is declared in the With function and displayed in the gallery.
So far, it is easy to understand.
Case 2: When the value used for the conditional expression of Filter is put into a variable of the With function
Then consider the case where the variable to be declared in the With function is assigned a value to be used in a Filter expression.
Case 3: Assigning a variable that is not used in any Filter expression in the With function
Finally, consider the case where the With function assigns a variable that is not related to the Filter expression at all.
The results so far show that using the With function for the Items property of the gallery will result in a behavior where the gallery’s delayed loading function will not work and only a limited number of items in the data rows can be displayed.
It is difficult to understand because there is no warning, but it is recommended to refrain from using the With function for galleries.
Extra: If you use variables declared in UpdateContext or Formulas, the delayed read function will work.
