cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlosN
Helper IV
Helper IV

Combo box list with table dataverse

Hi,
I have a table (dataverse) with more than 3000 records, I am adding a new record using a pacht, and when I try to find the record in a combo box list this new record does not appear.

10 REPLIES 10
dpoggemann
Super User
Super User

Hi @CarlosN ,

 

Please check your row limit for the Power App in Settings when delegation is not supported.

Screen Shot 2021-09-26 at 10.27.26 AM.png

 

Hope this helps.  Please accept if answers your question or Like if helps in any way.


Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
CarlosN
Helper IV
Helper IV

Hi,
It is set to 2000 ...

dpoggemann
Super User
Super User

Hi @CarlosN ,

 

Are you trying to increase or verify the query supports delegation?

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
CarlosN
Helper IV
Helper IV

I need to select the new record created, but it does not appear in the combo box

dpoggemann
Super User
Super User

Understand.  Please re-launch app and see if returned.  If so, then it is not over record limit and I would updatecontext on the component after patch.  If it does not return then you are over limit of rows to the front end and you will need to modify query or up your limit.  

thanks,

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
CarlosN
Helper IV
Helper IV

this is my code used in combo box

Sort(AxTable1s.Nombre; "cr208_ID";Descending)
Prakash4691
Solution Specialist
Solution Specialist

@CarlosN 

 

Where you able to see more than 3000 records in combo box? As per your comment, mentioned as 2000 rows limit for delegation. Make sure not to use non-delegable function while filtering in items property of combo box.

 

Try to refresh the datasource after patch or use clearcollect function. Refer the clearcollect variable in items property of combo box.

 

If possible, provide if any formula has been used to filter items in combo box.

 

If it answers your question, kindly give kudo and accept it as solution.

 

 

Regards,

Prakash

dpoggemann
Super User
Super User

Hi @CarlosN ,

 

Did any of our options help you solve this? 

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
v-qiaqi-msft
Community Support
Community Support

Hi @CarlosN,

Have you solved your problem?

Do you want to populate the Combo Box with more than 3000 items?

Could you please tell me that how you adding new records to your Dataverse?

 

As @Prakash4691 said, we could use a delegable function to refer to the data source data in the Combo Box.

You should transfer your cr208_ID data into a collection and refresh it every time you adding a new record.

 

Not sure how you save data to your Dataverse table, Patch() or SubmitForm()? No matter which one you use, please add the following ClearCollect() formula to your Patch() or SubmitForm():

Patch();;// Add your Patch() or SubmitForm() function here
ClearCollect(combolimit;Sort(AxTable1s.Nombre; "cr208_ID";Descending))

 

Then set the Items property of your Combo Box as below:

combolimit
Best Regards,
Qi

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.

Users online (3,373)