Skip to main content

Notifications

Community site session details

Community site session details

Session Id : L1YARU2IcKpbu8gFQ1z983
Power Apps - Building Power Apps
Unanswered

The 'Allow Search' feature is not working on a combo box with a data type of 'lookup' in a SharePoint list

Like (0) ShareShare
ReportReport
Posted on 21 Oct 2023 11:31:38 by 6

I have a SharePoint list named 'Skillset Repository' with a column called 'Skills,' which has a data type of 'lookup' and retrieves values from another SharePoint list containing a set of skills. 

When I create an EditForm in PowerApps Canvas for the 'Skillset Repository,' I can fetch and select values for the 'Skills' column, but I'm unable to search for items.

  • RajkumarMS Profile Picture
    6 on 25 Oct 2023 at 13:45:29
    Re: The 'Allow Search' feature is not working on a combo box with a data type of 'lookup' in a SharePoint list

    Hi @realwillwright ,

    Issue is fixed when I try to create a collection out of  sharepoint column :

    ClearCollect(colSkilSet,Choices([@SkillRepository].'Main Skillset'))

    where 'SkillRepository' is my sharepoint list and 'Main Skillset' is my column name (Type - lookup).

     

    I replaced items property of the combo box from

    Choices([@SkillRepository].'Main Skillset')

    to

    colSkilSet

  • realwillwright Profile Picture
    772 Super User 2025 Season 1 on 25 Oct 2023 at 07:50:06
    Re: The 'Allow Search' feature is not working on a combo box with a data type of 'lookup' in a SharePoint list

    You need to set the search fields and turn on searching in the Combobox properties

    realwillwright_1-1698220193835.png

     

    realwillwright_0-1698220153017.png

     

  • RajkumarMS Profile Picture
    6 on 25 Oct 2023 at 06:06:11
    Re: The 'Allow Search' feature is not working on a combo box with a data type of 'lookup' in a SharePoint list

    Hello @realwillwright ,

    I'm already using combo box.

     

     

  • realwillwright Profile Picture
    772 Super User 2025 Season 1 on 23 Oct 2023 at 15:48:49
    Re: The 'Allow Search' feature is not working on a combo box with a data type of 'lookup' in a SharePoint list

    Hi @RajkumarMS 

     

    Do you mean you can't search for the items within the dropdown?

    If so, you will need to use a Combobox control, dropdown boxes don't have the search feature.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
MS.Ragavendar Profile Picture

MS.Ragavendar 27

#2
mmbr1606 Profile Picture

mmbr1606 14 Super User 2025 Season 1

#3
EE-04041031-0 Profile Picture

EE-04041031-0 11

Overall leaderboard