Forum Discussion

Sadok_Hadji's avatar
Sadok_Hadji
Copper Contributor
Jun 01, 2020

SharePoint Online Lookup Dropdown Autocomplete/Combobox

Hi All,   I have a list in Sharepoint Online, which has a lookup to an other list. No matter what, on the form it will always render as a dropdown value. When this list of values becomes huge, it's...
RobElliott's avatar
RobElliott
Silver Contributor

Sadok_Hadji I'd use Power Apps where you can have a text box where you start entering  a name and the gallery gets filtered as you type. That's what I did in my ISO Airports Database app which has many thousands of items in a SharePoint list; you start typing the name of the country and the gallery gets filtered automatically with airports in the country with those starting letters. In my app you can also start typing the name of an airprt and the same thing happens.

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

FabioCartolano's avatar
FabioCartolano
Copper Contributor
Mar 12, 2021
Hi RobElliott, may I ask you some suggestions on how to realise a Power pp like yours? I'm quite new to Sharepoint and would like to make something similar, is there a tutorial maybe?
Thanks,
Fabio
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Mar 12, 2021

    FabioCartolano the best way you can learn Power Apps is to follow the videos on YouTube by Shane Young.  He's a really great teacher and very easy to understand. That's what I did - and still do! - and they've helped me to build some really good apps.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

      • sbayer's avatar
        sbayer
        Copper Contributor
        May 17, 2021

        Hi everybody!

        Is there some kind of autocomplete / intellisense available for MS Lists right now?
        In my case I have a lookup field that lists all the elements by the "Title"  column.

        I am able to filter this field by typing the first letters of the respective title.

        But if I try to write a word that is "contained" within the "Title" at any other then the first position of the string, I get an loading ring animation forever...

         

        Also, if I click on "Weitere Ergebnisse" (more results) a second loading animation ring appears forever...

        For me it seems the intellisense filter only works on "StartsWith" conditions... 

         

        Is this a bug / feature or am I wrong? 🙂

Resources