Combo box and SharePoint autocomplete

[robinthakur]

I have in SharePoint a single line of text column called 'Source' in a list called Business Expenses with 2920 items and a Combo box connected up to it in PowerApps.

I would like to have the user start typing and then it searches and autocompletes with unique values held in the Source text field. 

At the moment I have two issues:

1. Even using distinct (Distinct('Business Expenses',"Source") ) in SearchItems, it's bringing back multiples of the same item when I search. 

2. It's not searching every item in the list, it's missing values. I think this is likely to be a delegation issue and I'm just searching a Single line of Text field? I've raised the limit in settings to 2000 already. 

Anybody got any ideas? 

[robinthakur · Accepted solution]

I managed to work it out! The formula I needed was Items=Distinct(Sort('Business Expenses',Source),Source). Easy when you know how.