delegation &SQl Server

(0) Share

Report

Posted on by Mediterraneum

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

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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-list-force-user-to/td-p/498074

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

Best Regards,

Bof

Was this reply helpful? Yes No
Mediterraneum 17 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Verified answer

Mediterraneum 17 on at

Like (0)

Report
Copy link

Link copied!

Thank you

i decided create a collection

Was this reply helpful? Yes No