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
Dual Super User
Dual 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
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,890)