PowerApps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
Expand all | Collapse all

Question about Delegation

  • 1.  Question about Delegation

    Silver Contributor
    Posted 30 days ago
    I have a delegable query and want to perform a non-delegable operation on the result. Does this break delegation for the entire formula?

    Here is my example. This is the items formula for a list box. Due to the contents of the data set, this formula will never return more than 12 results. It is delegable.


    Now, I want to sum a numeric column from these results in a text label:


    Now I have a delegation warning across the whole formula. I can't test this because the data set is currently small, but I don't want to be refactoring this in a year or so once the data has grown beyond 2000 items.

    I'm using Flow to maintain a separate SP list with what is essentially the result of this Sum() operation so I can refer to that if needed, but I'd rather keep to a single source of truth for these values.

    This is an SP list, but will probably end up in Azure SQL for production.

    ------------------------------
    Will Page
    Technical consultant
    +64210436716
    ------------------------------


  • 2.  RE: Question about Delegation

    Posted 27 days ago
    Hello Will,

    The short answer is Yes. Delegation will be broken for the whole formula.  You state your intention to migrate to Azure SQL. There are nice advantages in doing so. For these situations,  I prefer to perform calculations in SQL and create a view over them. This removes burden from PowerApps and allows for delegation.

    Hope this helps. 


    ------------------------------
    Eric Herz
    Data Conversion and ETL Consultant
    Parker CO
    +1 630 864 9417
    ------------------------------



  • 3.  RE: Question about Delegation

    Silver Contributor
    Posted 27 days ago
    It does help, thanks.

    I think in this case I'll work around it by pulling the result of the filter into a collection when the gallery item is selected and run the Sum() over that.

    ------------------------------
    Will Page
    Technical consultant
    +64210436716
    ------------------------------