cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mediterraneum
Regular Visitor

delegation &SQl Server

Hi

 

I am new in powerapps and with my firts application I have a combobox. and only i can see few registers.

 

i have seen the problem and i changed the limit 500 to 2000, but I need more.

 

my database is a local database in Microsoft SQL I thought  if have this database I have no problem with the delegattion.

but.... I cant see more registers

 

How can I see all the registers in the combobox?

Thankyou

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you

 

i decided create a collection

 

 

View solution in original post

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

Hi @Mediterraneum 

Could you tell me:

  • Could you please share a bit more about the formula within the Items property of the Combo Box control?
  • Do you use Delegable functions in your formula within the Items property of the Combo Box control?

Based on the issue that you mentioned, I think you have faced a Delegation issue (yellow triangle warning) with the formula you typed within the Items property of the Combo Box control.

More details about the Delegation issue in PowerApps, please check the following article:

Delegation

In addition, there is no official doc mentioned about the records limit in Combo Box control. Some users have faced same issue with you, please check the responses within the following threads:

https://powerusers.microsoft.com/t5/General-Discussion/Drop-down-List-Items-Limites-to-500/td-p/9881...

https://powerusers.microsoft.com/t5/General-Discussion/ComboBox/td-p/75402

In any case, if you want to load more than 500 records within your Combo Box control, you would have to limit yourself to using delegable functions.

Finally, if the problem is still not resolved. I suggest you add a search function so that users can use this function to filter items. Then you can use the filtered results as the items property of the combo box, which can improve the usability of the combo box control.

Maybe these posts are useful to you:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Combobox-limit-how-many-values-is-shown-in-l...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Drop-down-List-Items-Limites-to-500/td-p/988...

Best Regards,

Bof

Hi

 

this is the formula in tne combobox control:

 

Sort('[dbo].[Vendor]';Name;Ascending)

 

I think sort is delegable function

 

But I will read these posts

 

Best regards

@Mediterraneum First things first - this topic would be better for the Building PowerApps channel; it has way more traffic so for basic questions like this you'll get an answer MUCH faster.

 

But, that said, we're all here to help, not to kick you around the community. The PowerApps team is always pushing the delegation bounds but there is still a lot of ground to cover. In the meantime, if you need to run a query that runs in excess of what the delegation limits can achieve, it is possible to offload that operation to PowerAutomate or an Azure Function or something that won't have these delegation limits. Try running the same query from a manually triggered PowerAutomate Flow. If that flow can run the query without hitting a delegation cap, you can just call the flow using a HTTP trigger and HTTP response to get your complete data and return it. Enjoy!

Thank you

 

i decided create a collection

 

 

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (63,812)