Matching collection values to Sharepoint List ID and reduce related id row by collection value

(0) Share

Report

Posted on by EitanKGCS

Hi all,

I have been trying to find a way to update a SharePoint list with stock from a collection on PowerApps.

For further explanation, I have created a shopping cart app that has a shopping basket collection.

The first thing I do is patch it into an orders SP List to create an order history of all the customer details and the items ordered.

I would like to then take all respective items put in the basket and reduce the quantity of the items on a separate stock list.

The collection already has an ID that matches the ID from the stock list. So theoretically it should be simple enough to match the Collection ProductID with the Sharepoint ID and then reduce the SP quantity by the collection quantity. However, I can't seem to get the types to match. I have been trying Foralls, Patch's and lookups but can't seem to get rid of 'incomparable types' and 'invalid argument' errors.

Any help would be greatly appreciated!

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

VincentGiovanni on at

Like (0)

Report
Copy link

Link copied!

Did you find a solution to this? I´m struggling aswell with this...

Was this reply helpful? Yes No
EitanKGCS 46 on at

Like (1)

Report
Copy link

Link copied!
Hi Vincent,

Actually, I did! After staring at my formulas for hours on end I eventually came up with a solution:

Adding an 'as' function really helps to identify the value you are trying to deduct.

The formula matches the unique identifier between your collection and your SP list and then deducts by the value in your collection for each record in your collection.

ForAll( colShoppingCart As Basket, UpdateIf( 'Merchandise Stock List_1', ID = Basket.ProductID, { Quantity: Value( LookUp( 'Merchandise Stock List_1', ID = Basket.ProductID ).Quantity ) - Basket.QTY } ) );

Good luck and I hope this helps!

Was this reply helpful? Yes No