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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,653)