cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Combo box and SharePoint autocomplete

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Combo box and SharePoint autocomplete

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

View solution in original post

1 REPLY 1
Highlighted
Regular Visitor

Re: Combo box and SharePoint autocomplete

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

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,019)