Answered

Filter and collect SPList with a custom textinput number

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I've been stuck on this for days, I'm looking to collect a SPList Product Gallery, with a quantity text box into a collection, and then I patch the order into a different SPList.

I'm unable to collect quantity box, I've been trying filter and if functions, but I haven't managed to get it right.

SPList = ProductsGallery

I tried the following syntax

ForAll(OrderGallery.AllItems, If(!IsBlank(OrderQuantity.Text),Collect(OrdersCollection, {Quantity:Value(OrderQuantity.Text)},"")))

ForAll(ProductsGallery.AllItems, Filter( ProductsGallery, OrderQuantity.Text > 0 ), Collect( OrderCollection, { PLI: PLI.Text, Quantity: OrderQuantity.Text } ) )

appreciate any tips and help. thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You might consider the following for your formula:

ForAll( Filter(ProductsGallery.AllItems, Value(OrderQuantity.Text)>0, Collect(OrderQuantity, {PLI: PLI.Text, Quantity: Value(OrderQuantity.Text)}) )

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes - thanks for the reply.
Unfortunately, this also didn't work.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Always check for syntax from replies on this forum...we free-hand type the formulas and often miss parenthesis or commas.

As was the case here...

Formula should be:

ForAll( Filter(ProductsGallery.AllItems, Value(OrderQuantity.Text)>0), Collect(OrderQuantity, {PLI: PLI.Text, Quantity: Value(OrderQuantity.Text)}) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes Wow, it was just that 1 missing paranthesis . I'm still very new to this, always aware of how much I still have to learn.
Thanks for helping out.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Great!! If that worked then please check off on Accept Solution so that others can find these answers quickly.

Was this reply helpful? Yes No