Combo box list with table dataverse

[CarlosN]

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.

[dpoggemann]

Hi @CarlosN ,

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

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

Thanks,

Drew

[CarlosN]

Hi,
It is set to 2000 ...

[dpoggemann]

Hi @CarlosN ,

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

Thanks,

Drew

[CarlosN]

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

[dpoggemann]

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

[CarlosN]

this is my code used in combo box

Sort(AxTable1s.Nombre; "cr208_ID";Descending)

[Prakash4691]

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

Hi @CarlosN ,

Did any of our options help you solve this? 

Thanks,

Drew

[v-qiaqi-msft]

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