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.