Hi @carrie-anne27
For this 'Items': Office365Users.SearchUser({searchTerm:'cmb_1_Cost Driver'.SearchText})
How many records are you expecting to find?
But then you say you are using a Table as the DataSource. A DataSource to what, the gallery?
The delegation limit is 500, or 2000 depending on the source and what Settings, you have updated to delegate and/or if the Search is delegatable in general.
So you have a gallery that is listing records. They select that and you said the form items is set to gl_CPR_Gallery.Selected.
How does that Gallery drive the items search you have on the form? Where does this searchTerm come from?
Does it really return back that many records that start with A?
To me it sounds like you are pulling back too many records and/or possibly not actually filtering properly.
Can you take your code for the ComboBox, put it on a button. Then hardcode the search filter for Office365User connector, with a value that you would have received from the Gallery. See how many records it returns. If its returning thousands I believe you an issue. I truly am not fully sure of what query you would want to find thousands of people for.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
