Announcements
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
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
@_douglasromao Thank you this works fine but nptfor the ID field in SharePoint
@JimmyWork you can use the following formula as the Items source for your Gallery:
Filter(YourDataSource, YourTextBox.Text in Text(ID))
@_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
@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.
@_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 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 834
Valantis 533
Haque 410