web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / using Clearcollect for...
Power Apps
Answered

using Clearcollect for combobox person variable, Searching is not working

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

My ultimate goal is to make

1. combobox dropdown menu from a sharepoint list called "DataCenter_EscortBy"

- This list contains two columns : "Guest Of" and Available. Person and text variable respectively.

- Available column contains "Yes" for all records

 

2. Create a new record in another sharepoint list called "DataCenter_GuestLog"

- I will use the variable chosen in the combobox and patch it to a column called "EscortBy" in this sharepoint list.

 

What I figured out is that simply using 

 

Choices(DataCenter_EscortBy.'Guest Of')

 

Doesn't allow me to have the options I want, but instead, pull up all individuals in AD.

 

What I did is that i made a table variable by using ClearCollect when App is Onstart

 

ClearCollect(EscortBy,Filter(DataCenter_EscortBy,Available="yes"));

ClearCollect(ColEscortBy, ForAll(EscortBy As a,a.'Guest Of'));

 

 

Then I simply did the following in the combobox

 

Item = ColEscortBy

 

 

Everything works fine, but as there are too many people,

I have to make searching available.

 

I changed isSearchable to True,

but the searching does not work properly.

 

I need searching work by both first and last name.

 

How do I make this possible? 

Thanks!

Categories:
I have the same question (0)
  • Verified answer
    v-mingkz-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

    Do you want to filter items of Combo box by searching the first Name or LastName of Person.

    I did some test according to your description.

    1. Use ClearCollect create a collection.

    2. Set the Items Property of ComboBox as: 

    ColEscortBy

    3. Set the IsSearchable property as: true.

    All of the above functions work.

     

    I think the problem might be with your Searchfield property of Combo box.

    Do you set it as DisplayName?

    vmingkzmsft_0-1688714027976.png

     

    Best Regards,

    Kyrie

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard