cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FreddieV
Resolver I
Resolver I

Combo box to search own column?

I am wondering if it's possible to use a combo box to search data in a column, rather than allowing free text info.

 

I have the following form, where I want the combo box for Document Number (BC Number) to search the data already in the underlying SharePoint list.

 

form-fields.png

 

Below is the Sharepoint list, with the column, circled in red that I want the field to draw in its data from.

 

Underlying data.png

 

Is this possible?

3 REPLIES 3
gabibalaban
Super User
Super User

@FreddieV ,

Well, if you need all documents in the list there might be a problem to obtain what you want (when we are talking about more than 500 items in the list).

If you can filter (like status = "Pending" or Created in last 30 days) the documents and can the filter results under 500 items , you can set Items property of combobox to: 

Distinct(Filter(YourDataSource, condition above))

And in Gallery use among other conditions you might have use: 

'Document Number'=ComboBox1.Selected.Result

Hope it helps !

@gabibalaban 

Thanks for your reply. However, I am not using a gallery, this is an app with fields created from underlying SharePoint list columns. Do you have to use a gallery to do what I want then?

Well no, it is not necesarry to use a Gallery. It was only a supposition. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,239)