cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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:
ForAll(WidgetIDList,Collect(myWidgetCollection,Filter(WidgetSharePointList,WidgetID=Result)))


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?

0 REPLIES 0

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

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

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (59,216)