Delegation problem-combobox

(0) Share

Report

Posted on by JM-14081323-0

136

Hello,

here is another one on delegation limits. I have records which are added to a table in batches. Everytime is assigned the highest number+1 in BlokCislo column.

Then on another screen I have a combobox with this:

Distinct(
    Filter(
        DelnikPrescasy; 
        Kdy >= Today()
    );
    BlokCislo
)
 
 
Below is a gallery: chosen batch numbers and thus all respected records show up.
 
Sort(
    Filter(
        DelnikPrescasy; 
        BlokCislo in cbxBlokCislo.SelectedItems.Value
    );
    Kdy
)
 
 
How can I make the combobox list delegable? Many thanks J.

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 6,545 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@JM-14081323-0,

A safe pattern is to first delegate the date filter fully to the data source, store that result in a variable using With(), and only then apply Distinct() on the already‑filtered rows. This minimizes delegation impact and avoids pulling unnecessary records.

With(

    {

        _futureRows:

            Filter(

                DelnikPrescasy,

                Kdy >= Today()

            )

    },

    Distinct(

        _futureRows,

        BlokCislo

    )

)

What happens here is that Filter(DelnikPrescasy, Kdy >= Today()) is fully delegable and executes on the server, assuming Kdy is a date column and indexed.

Only the result of that delegable filter is brought client‑side, and Distinct() is applied after that. This does not remove delegation warnings entirely, because Distinct() cannot be delegated, but it significantly reduces the data volume and prevents incorrect results at scale in most real‑world cases.

MultSelect Items

With(

    {

        _selectedBloks:

            ForAll(

                cbxBlokCislo.SelectedItems,

                BlokCislo

            )

    },

    Sort(

        Filter(

            DelnikPrescasy,

            BlokCislo in _selectedBloks

        ),

        Kdy

    )

)

There is an excellent article about delegation from @WarrenBelz kindly refer that as well https://www.practicalpowerapps.com/category/delegation/.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

11manish 1,391 on at

Like (0)

Report
Copy link

Link copied!
You cannot make your ComboBox delegable because Distinct() is not delegable.

The correct and scalable solution is:

Create a separate table for BlokCislo (batch numbers) and bind the ComboBox to that table instead of deriving values from the main table.

Was this reply helpful? Yes No
WarrenBelz 155,052 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JM-14081323-0,

@MS.Ragavendar is completely correct (thanks for the tag and reference) so please mark accordingly.

I will clarify one small thing - you will not get a Delegation warning on that code (Distinct becomes a "hidden" Delegation limitation as the output of the With statement is processed locally), however providing the top filter returns (the Table can be of any size) record numbers under your Data Row Limit, you will receive a complete distinct dataset.

Was this reply helpful? Yes No