Answered

Add multiple items from SP list to collection

(0) Share

Report

Posted on by drossi90

188

I have a gallery where I add items to a shopping cart style collection. The code to add the item from the gallery to the collection is:

If(
 IsBlank(LookUp(colQuote, PID = ThisItem.ID)),

Collect(colQuote,
 {
PID:ThisItem.ID, 
Product:ThisItem.Title,
Price:Value(ThisItem.PriceExVAT),
HMCode:ThisItem.HMCode,
Category:ThisItem.Category,
ProductQuantity:1,
SubTotal: Value(ThisItem.PriceExVAT) * 1
}));

However, I also want to able to add multiple items to a collection with one click. So I've created buttons with a + icon to do this OnSelect.

Instead of hard coding it to the OnSelect, I want to store these items in a SPList "BoilerFittingsPack" and then depending on which of the three buttons is clicked (buttons would filter the Category) and add all items within that category to the collection.

The BoilerFittingsPack schema would be similar as the code above with same column names.

How would I go about this to achieve it?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @drossi90 ,

I am not sure about how your buttons, but a checkbox would work like this

If( IsBlank(LookUp(colQuote, PID = aCol.ID)), ForAll( Filter( GalleryName.AllItems, CheckboxName.Value ) As aCol, Collect( colQuote, { PID: aCol.ID, Product: aCol.Title, Price: Value(aCol.PriceExVAT), HMCode: aCol.HMCode, Category: aCol.Category, ProductQuantity: 1, SubTotal: Value(aCol.PriceExVAT)*1 } ) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Warren. Can you talk me through what aCol is doing so I understand it please?

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @drossi90 ,

The As statement is simply a disambiguation operator - you can call aCol whatever you want. It is useful when you have the same field names in the source and destination.

Was this reply helpful? Yes No
drossi90 188 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @WarrenBelz every day is a school day.

I've went with your suggestion and modified slightly to the below. Works perfectly. Thanks again.

If( IsBlank( LookUp(colQuote,Category = "System Pack")), ForAll( Filter( BoilerFittingsPack,Category="System Pack") As BoilerFittings, Collect( colQuote, {PID:BoilerFittings.ID, Product:BoilerFittings.Title, Price:Value(BoilerFittings.PriceExVAT), HMCode:BoilerFittings.HMCode, Category:BoilerFittings.Category, ProductQuantity:BoilerFittings.ProductQuantity, SubTotal:Value(BoilerFittings.PriceExVAT)*Value(BoilerFittings.ProductQuantity)})))

Was this reply helpful? Yes No