Serachable dropdown with checkboxes for multiselect result

[JimmyWork]

Hi

I wonder if it's possibel to create a searchable dropdown where you can select the results by ticking a checkbox, should be able to select multiple items from the search.

Im trying to search the ID field of a SharePoint list. So if i search for example 11 i will get the result of all ID's thats starts with 11 and i can then select multiple items and save the result

[_douglasromao]

Hi @JimmyWork ,

I think you will need to use two components to make it work, the first one would be a text box where you can type what you are searching for and the second one would be a gallery with the filtered values, using a checkbox inside this Gallery to be the marked/unmarked values. Something like this:

In this case, I'm filtering the results on the Gallery based on what the user typed on the text box.

Regards,

Douglas Romão

[JimmyWork]

@_douglasromao Thank you this works fine but nptfor the ID field in SharePoint

[_douglasromao]

@JimmyWork you can use the following formula as the Items source for your Gallery:

Filter(YourDataSource, YourTextBox.Text in Text(ID))

[JimmyWork]

@_douglasromao Thank you very much. It works but i do get a delegation warning and when the list reaches more then 5000 items i guess it wont work so good?

And im not able to select anything, guess i need a combobox and select the items ID i want then get that data out and stored.

What i basicly want is to select items based on the ID. This way im creating a relation  beetwen the items.  Select all items that are similiare and connect them in one item

[_douglasromao · Accepted solution]

@JimmyWork this is a default warning just to let you know about the possible side effects by using large data sets, but it's a default message.

Regarding filtering by ID, that formula that I mentioned to you`will filter using the ID column, and then you can add it yo a gallery with some comboboxes inside to make the selection if you want.

[JimmyWork]

@_douglasromao 

Can't seemt o get it to work using Filter('Teams Flow Test'; SearchBox.Text in Text(ID))

I get Gallary excpected Record

Never mind this was powerapps stuck, fixed after reloading 🙂