Unanswered

combobox using cds data not showing all records (delegation)

(0) Share

Report

Posted on by IMalloul

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.

Categories:

Connecting to Data

Connectors

All responses (3)

Answers (0)

TomasG 253 on at

Like (0)

Report

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 249 on at

Like (1)

Report

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
v-yutliu-msft on at

Like (0)

Report
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,