cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerApper01
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

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

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

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 (37,849)