Patch a collection row multiple times based on number column

(0) Share

Report

Posted on by ciprianpopovici

159

Hello,

I have an inventory app and i want to save articles from invoice to a sharepoint list. I add all the product from one invoice to a collection row by row..If column Quantity for an article (ProductName) is equal to 1 i want to patch that line once, other way i want to patch same article based on that quantity( two times or then, depending on quantity)

Can anybody help me?

Thanks

The collection named col_InvoiceItems look like this:

ProductName	Quantity	ProductPrice
laptop1	2	100
laptop2	1	150
Phone	3	25

See the code bellow for normal patch ...

ForAll(
col_InvoiceItems,
Patch(
ITInventory,
Defaults(ITInventory),
{
'Product': ThisRecord.Productname,
'Price': Value(ThisRecord.ProductPrice)
}
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ciprianpopovici ,

Is this what you are looking for?

https://www.matthewdevaney.com/7-ways-to-use-the-patch-function-in-power-apps-cheat-sheet/#4.-Create-Multiple-New-Records-With-Power-Apps-Patch-Function

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (0)

Report
Hi @ciprianpopovici

You need the ForAll function twice to achieve the functionality.

I have made a test for your reference:

ForAll( col, ForAll( Sequence(Quantity), Patch( '1026', Defaults('1026'), { Title: ProductName, price: ProductPrice } ) ) )

Best Regards,

Levi

Was this reply helpful? Yes No