Power Platform Community Forum Thread Details

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:

using Clearcollect for combobox person variable, Searching is not working