Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

Delegation limit IN ComboBox with Dataverse entities?

(0) ShareShare
ReportReport
Posted on by

Hi all,

 

Recently I have been using the trick to change my 'data row limit' to 1 to check for 'hidden' delegation issues. I then discovered that my Dataverse entities only show one record when I use them for a ComboBox. See the following examples:

 

felixpwc_0-1684258570748.png

felixpwc_1-1684258598850.png

 

It happens with system tables and custom tables and it happens in all applications. Does anybody know why this occurs and if it affects my users search capabilities?

 

Categories:
  • Community Power Platform Member Profile Picture
    on at
    Re: Delegation limit IN ComboBox with Dataverse entities?

    Hi @v-xiaochen-msft ,

    I see. So setting the data row limit will limit the VISIBILITY of the rows SHOWN in a ComboBox. Such as:

    felixpwc_0-1684754010355.png

    But it will not impede the SEARCH capabilities since I can still search for other records in that set in the ComboBox:

    felixpwc_1-1684754091338.png

    While with a delegation warning such as with Sharepoint it is not possible to search for the other records. Clear, thank you!

  • Verified answer
    v-xiaochen-msft Profile Picture
    on at
    Re: Delegation limit IN ComboBox with Dataverse entities?

    Hi @Anonymous ,

     

    This seems to be affected by the data source.

    I set data row limit to 3.

    SharePoint cannot work:

    vxiaochenmsft_0-1684720803504.png

    vxiaochenmsft_1-1684720900458.png

    vxiaochenmsft_2-1684720913959.png

    vxiaochenmsft_3-1684720960948.png

     

    Dataverse works-

    vxiaochenmsft_4-1684720983217.png

    vxiaochenmsft_5-1684721031268.png

    vxiaochenmsft_6-1684721038851.png

    vxiaochenmsft_7-1684721052238.png

     

    vxiaochenmsft_8-1684721077427.png

    I turned on 'allow search' setting for both combo box controls.

    The combo box for sharepoint will pop up a warning about the delegation.

    vxiaochenmsft_9-1684721215845.png

    If I turn off it, the warning will disappear.

     

    Hope it helps.

     

    Best Regards,

    Wearsky

  • Community Power Platform Member Profile Picture
    on at
    Re: Delegation limit IN ComboBox with Dataverse entities?

    Hi @v-xiaochen-msft , I understand the settings have an effect.

    My question would be rather: will it only search in the first 2000 records when users search in the combobox and the limit is set to 2000?

  • v-xiaochen-msft Profile Picture
    on at
    Re: Delegation limit IN ComboBox with Dataverse entities?

    Hi @Anonymous ,

     

    1\ It will affect users search capabilities.

    2\ If you set the 'data row limit' to 1, the combo box returns up to one record.

    If you set the 'data row limit' to 3, the combo box returns up to three records.

    The amount of data returned by the combo box is affected by this setting.

     

    Best Regards,

    Wearsky

  • Community Power Platform Member Profile Picture
    on at
    Re: Delegation limit IN ComboBox with Dataverse entities?

    Hi Wearsky,

     

    Thank you for your response.

     

    So this is not something that will affect users search capabilities? Or will it?

     

    What do you mean with under ‘delegation control’?

  • v-xiaochen-msft Profile Picture
    on at
    Re: Delegation limit IN ComboBox with Dataverse entities?

    Hi @Anonymous ,

     

    This is an issue with the combo box control.

    The combo box is under delegation control.

    vxiaochenmsft_0-1684293315752.png

    vxiaochenmsft_1-1684293326841.png

    vxiaochenmsft_2-1684293379517.png

    You can see the difference between these 2 controls.

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics