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

Customised Form, Dropdown to Combo Box (search)

I have a Venue Directory set up with names of venues as a SharePoint List.

 

I have a customised form that contains a dropdown that is linked to the Venue Directory SP list:

 

Items: Sort('Venue Directory'.Title, "Title")

 

As this list is pretty extensive, I would like to put a search function on the dropdown menu. 

 

I can either change this to a Combo Box function, but I can't seem to work out how to do this. Or I can add in a new Datacard with a Combo Box function and connect it to the data source (again I can't seem to work out how to do this)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Customised Form, Dropdown to Combo Box (search)

I found a work around for this. But thank you!

View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: Customised Form, Dropdown to Combo Box (search)

Hi @jpacettf,

 

I would use a textbox and then filter your dropdown based on it's value.

 

So you create a textbox called txtSearchBox,
..then in your existing venue dropdown, change the items value to:
Sort(Filter('Venue Directory', Startswith(Title, txtSearchBox.Text) ).Title, "Title")

 

Let me know if this works out for you or if you had another idea in mind 🙂

 

Cheers,

@iAm_ManCat


@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Highlighted
Super User III
Super User III

Re: Customised Form, Dropdown to Combo Box (search)


@jpacettf wrote: Or I can add in a new Datacard with a Combo Box function and connect it to the data source (again I can't seem to work out how to do this)

Hi @jpacettf, If you add a new data card with a Combo Box, it should connect to your data source automatically. The way to add a new data card is via EditForm > Fields > (FieldName) > Edit Selection.

 

image.png

Highlighted
Resolver I
Resolver I

Re: Customised Form, Dropdown to Combo Box (search)

Neither of these solutions worked, but thank you.

 

I think the problem lies in that the column I am using is a "LookUp" column in itself which is then using another SharePoint list

Highlighted
Super User III
Super User III

Re: Customised Form, Dropdown to Combo Box (search)

Hi @jpacettf

My example is setup in the same way as you describe. The 'ProjectManager' field is a lookup columns that points to another SharePoint list. Could you describe in more detail how it doesn't work for you?

Highlighted
Resolver I
Resolver I

Re: Customised Form, Dropdown to Combo Box (search)

I found a work around for this. But thank you!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,913)