You’re offline. This is a read only version of the page.
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
Share
ReportChoices(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!
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?
Best Regards,
Kyrie
All responses (
Answers (
551
