cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MatthewB
Level: Power Up

PowerApp Custom SharePoint Form Combobox Search

Hi,

 

I am working to create a custom PowerApp form for a couple SharePoint lists. I've run into an issue where one of my fields on my backend list is a lookup, but the values in the lookup are not easy for users to find. For example, one of the items might be "William A. Richard Conference Building"; users will be looking for "Conference Building" and not know the building is named after "William A. Richard".

 

The problem is that the default combobox for lookup fields allows searching but only alphabetically. What I want is the search behavior of a person lookup combobox, where search is anywhere in the string--so users could search for "Conference" and find "William A. Richard Conference Building".

 

I've found that I can add a custom card with a new combobox and a datasource referencing the lookup list and search works as I need. However, I am getting "A value must be provided for the item" error when submitting the form and can't figure out why.

 

To summarize:

 - I am looking for a combobox enabling searching a list anywhere in the list item strings

 - I have a workaround, but am getting an error "A value must be provided for the item" and could use pointers to troubleshoot

 

Thanks!

3 REPLIES 3
MatthewB
Level: Power Up

Re: PowerApp Custom SharePoint Form Combobox Search

More information:

 

I confirmed that the search behavior on the combobox is different depending on whether the Items attribute of the combobox control is:
Choices('Employee Master List'.Location)  <-- this is the default

 -or-
'Buildings'  <-- this is my list as a new datasource in the PowerApp, which is the lookup on the Location field for 'Employee Master List'

 

If I use choices, the search is alphabetical only. If I use the buildings datasource, search is anywhere in the list.

krywar
Level: Powered On

Re: PowerApp Custom SharePoint Form Combobox Search

Hi Matthew:

 

I am running into this same requirement.  Did you determine a way to utilize both the search-friendly datasource and sync back to the lookup column.  Having difficulty with the latter portion right now.

 

Regards,

Mark

Matt_Hong
Level: Powered On

Re: PowerApp Custom SharePoint Form Combobox Search

@MatthewB- Did you find a solution to this issue?  I'm running into this exact same issue.  I would like a true search in this combobox from SharePoint, but it only pulls items from the start of each item.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, August 21st at 8am PDT

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 34 members 4,229 guests
Please welcome our newest community members: