Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

PowerApp Filter "Is In Collection" ... Or other ideas

I'm looking for ideas to improve performance of a Collect call to Sharepoint in my PowerApp.
Here are the basics:


I have a SharePoint list full of Widgets and their details. The key column used for lookups is WidgetID, which originates from a barcode that are on my physical Widgets.


My app users have these Widgets with barcodes in front of them; they could have 1 or as many as 20.

They use a barcode scanner to scan in all of their WidgetIDs into text input control, then press "Find Widgets" to look up details on all those Widgets.

The Find Widgets button uses the SPLIT function to turn the string of all WidgetIDs into a collection of WidgetIDs:

ClearCollect(WidgetIDList,Split(Input_WidgetBarcodes.Text)," ")

Then it loops through this list and makes calls to SharePoint to get widget details:

This works OK, but it just isn't particularly quick, probably because I'm making anywhere from 1-20 calls to SharePoint.

Is there a smarter/faster way to do this in a single call?

Is there some way to write a Filter function that says "Return rows from Sharepoint where WidgetID the is in WidgetIDList? Almost like an "inner join" on the two data sources?


Helpful resources

User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (75,191)