Answered

Load a Subset of Data into a Collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Community,

I am struggling to find a solution to something that I thought should be fairly straight-forward. I have a SharePoint list with 3 columns:

Product
Component
Weight

In the app that I am building, the user will select first the Product they are working on. Based on the product, I need a collection that will have a list of the components and their weights. So far, I have been able to make a collection that has a list of the components (e.g. Column 1; Rows 1-10 in the collection is the correct list of filtered components by product), and a list of weights (e.g. Column 2; Rows 11-20 in the collection is the correct list of filtered weights by product). However, I cannot get these two columns to relate to each other.

This is how I am doing this so far:

ClearCollect(Collection_ComponentScore,Filter(SP_ComponentsByGroup,Group=Var_Group.Name).Component,Filter(SP_ComponentsByGroup,Group=Var_Group.Name).Weight)

Can someone please shed some light on how I can set up my collection?

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,
I think this is what you are trying to do
ClearCollect( Collection_ComponentScore, ShowColumns( Filter( SP_ComponentsByGroup, Group=Var_Group.Name ), "Product", "Component", "Weight" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much @WarrenBelz ! That is exactly what I needed!
WarrenBelz 156,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,
No problems - happy to assist.