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?
Solved! Go to Solution.
I managed to work it out! The formula I needed was Items=Distinct(Sort('Business Expenses',Source),Source). Easy when you know how.
I managed to work it out! The formula I needed was Items=Distinct(Sort('Business Expenses',Source),Source). Easy when you know how.
User | Count |
---|---|
196 | |
124 | |
88 | |
49 | |
42 |
User | Count |
---|---|
285 | |
162 | |
138 | |
77 | |
73 |