cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RemiChambard3
Advocate IV
Advocate IV

ComboBox not supporting Delegation ?

Hi,

 

I have built a Canvas application connected to a Dataverse table.

 

I've added a ComboBox and set the "Items" property to a filter expression on the table. When I set the value 1 in the "Data rows limit for non-delegable queries" settings, I only get one result in the ComboBox.

 

When I set the same query on the Items property of the Gallery, I get all the data displayed.

 

Is there any issue concerning Delegation with the ComboBox component ? It seems very weird to me.

 

Thanks !

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @RemiChambard3 ,

 

Delegation is only related to data source and function.

 

Please see the example below:

1\ Set "Data rows limit for non-delegable queries" settings to 1.

v-xiaochen-msft_0-1616489538466.png

 

2\ This is my list 'LIST100'.

v-xiaochen-msft_1-1616489565819.png

 

3\ Add a gallery control and set its Items property to:

 

FirstN(LIST100,100)
// FirstN() function is a non-delegable function.

 

 

4\ Add a combo box control and set its Items property to:

 

FirstN(LIST100,100)

 

 

5\ The result is as follows:

v-xiaochen-msft_2-1616489743393.png

 

So, Please re-add a gallery control and refresh the data source.This may be due to the network or other reasons.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

 

 

Hi @v-xiaochen-msft 

 

First of all, thanks for your answer.

 

However, I think you misunderstood my issue. On a screen, I have added a ComboBox and a Gallery. I have set the "Data rows limit for non-delegable queries" settings to 1. I have set the "Items" property for both components to "Filter(MyTable, Field = "Value"). The ComboBox component displays only 1 item (it seems to me that ComboBox doesn't support delegation), whereas the Gallery displays all items as seen in the following screenshot :

 

2021-03-24_10h31_26.png

v-xiaochen-msft
Community Support
Community Support

Hi @RemiChambard3 ,

 

I understand what you mean.

Please refresh your data source.

v-xiaochen-msft_0-1616578787962.png

 

1\ As you can see, I changed the setting to 1.

v-xiaochen-msft_1-1616578828603.png

 

2\ I have 2 records in list.

v-xiaochen-msft_2-1616578866656.png

 

3\ Add a gallery control and set its Items property to:

LIST101

 

4\ The result is as follows:

v-xiaochen-msft_3-1616578935690.png

It will only have one piece of data because I changed the setting.

 

In addition, which data source did you use?

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,718)