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?
Solved! Go to Solution.
Could you tell me:
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:
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:
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:
this is the formula in tne combobox control:
I think sort is delegable function
But I will read these posts
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!
Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Did you miss the call?? Check out the Power Apps Community Call here!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.