Announcements
My intention is to get the multiple exact match items(from SP list).
The orderNo separated by a space in a search box maybe more than 100.
The simplest case is as below. Please guide. Thank you
@zhuhaiyin - one example:
Filter( 'Your List', 'Order No' in Filter( Split( TextInput1.Text, " " ), Len(Value) > 0 ) )
Please note that the in function is not delegable with SharePoint.
But my list is more than 2000 items, maybe there is no way to achieve this perfectly in powerapps.
Thank you all the same.
@zhuhaiyin - even if your list contains over 2000 items, if you can reduce the number of rows in your query using the delegable Filter function to return rows you can be certain will output less than 2000 rows, you can then execute any non-delegable functions on that prefiltered subset. I will be happy to provide you with an example if that solution is workable for you.
An alternative option is move your data source to Dataverse if you have premium because the In function is delegable with that db. Another very fast option is to apply your filters in Power Automate, and then return the filtered results back to your Power App using the Respond to a Power App or Flow action.
Thank you, they are all very good alternatives, and I will try them out.
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 914
11manish 627
Valantis 598
