Skip to main content
Community site session details

Community site session details

Session Id : 472aqTShomUj2WJlHS7aXU
Power Apps - Building Power Apps
Unanswered

combobox using cds data not showing all records (delegation)

Like (0) ShareShare
ReportReport
Posted on 8 Apr 2020 09:22:45 by 5

Hello guys,

 

We have created an embedded canvas app that is used in our Dynamics environment. In that app we have a combobox that shows records of the account entity. In our Dynamics environment we have 5000+ records. However, in the app only 500 are shown (app row limit). Also when searching only results are shown from that same batch of records.

 

I am aware of the process of delegation. No delegation warning is shown. CDS is a delegable datasource and we made sure that our formulas are delegable as well. Below formula was used to get the items for the combobox:

If(
 cmbTypeRolTRS.Selected.'ZK type' in [
 "95276FEF-C9FA-E711-80F7-3863BB35FF48";
 "0A156558-2A6E-E811-8111-3863BB34CDB0"
 ];
 Filter(
 Accounts;
 'Accounts(Views)'.'Active(exl. Aspirant) Accounts'
 );
 Filter(
 Accounts;
 'Accounts(Views)'.'Active accounts'
 )
 )

We also tried to remove the if and filter functions, but the same behaviour was observed. I have also tried this with the contact table, but it remains the same.

I am not sure why it is behaving like this. I would appreciate some help.

  • TomasG Profile Picture
    255 on 13 Nov 2024 at 09:57:39
    combobox using cds data not showing all records (delegation)
    Hi, 

    we have the same problem. We use Dataverse datasource. The app is without delegation warings. 
    I set app row limit to 1 and all comboboxes shows only 1 record. 

    Has there been any progress on this matter? Did you figure out why the combo box behaves like that?

    Thanks
  • mwbyrtie Profile Picture
    239 on 08 Oct 2020 at 16:48:24
    Re: combobox using cds data not showing all records (delegation)

    Hi @Ibrahim 

     

    I have the same issue, and I have reported it to Microsoft.

     

    I arrived at the same conclusion as you - both the function and the data source are delegable; all records should therefore be retrieved. But unfortunately, this is currently not the case when a IF-condition is wrapped around a FILTER-function in a dropdown, which will limit the retrieved number of retrieved records to about 100.

     

    The funny thing is; If you apply the exact same function to a gallery, all records will be retrieved.

     

    But the fun doesn't stop there - the issue is also present if you do not use any IF- or FILTER-function in a ComboBox (using CDS as a data source). The only difference is, that now you are restricted by the delegation limit that has been defined in your advanced settings (e.g. if you have set the limit to 1, then only 1 record will be shown in among the available options - but you are still allowed to search for the other records and select those).

     

    #YetAnotherBug

     

    mwbyrtie_0-1602175182545.png

     

  • v-yutliu-msft Profile Picture
    on 09 Apr 2020 at 05:44:34
    Re: combobox using cds data not showing all records (delegation)

    Hi @Ibrahim ,

    Since combo box does not have record limit, I think your problem should be about delegation.

    Firstly, could you tell me your filter rule in details?

     Filter(
     Accounts;
     'Accounts(Views)'.'Active(exl. Aspirant) Accounts'
     );
     Filter(
     Accounts;
     'Accounts(Views)'.'Active accounts'
     )

    'Accounts(Views)'.'Active(exl. Aspirant) Accounts' and 'Accounts(Views)'.'Active accounts' are just two column names.

    You need a formula to represent filter rule in the second parameter of Filter function.

    Like this: fieldname=...value

    Please refer this doc to see how to use Filter function:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

     

    Secondly, could you tell me the fields data type that are related to your formula?

    Please refer this doc to see the delegate functions of CDS:

    https://docs.microsoft.com/en-us/connectors/commondataservice/

     

     

    Best regards,

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 our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete