Answered

Patching collection to Sharepoint List for inventory management

(0) Share

Report

Posted on by as733y

224

I'm creating an inventory management app and I'm trying to patch certain items in a SharePoint list based on a collection.

Below is the code I'm trying to use, but I get an error trying to reference the Amount in the SharePoint list.

How can I reference the Amount from the SharePoint list, so the Patch code works correctly?

ForAll(colCartFinal As aRecord,Patch('Uniform Inventory',LookUp('Uniform Inventory',Title=aRecord.Product && Sizes=aRecord.Size),{Amount:Value(Amount-aRecord.TotalNeeded)}))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @as733y ，

Could you please show me the error message?

Please check the value of

Amount-aRecord.TotalNeeded

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @as733y ,

Assuming TotalNeeded is numeric, try this

Patch( 'Uniform Inventory', ForAll( colCartFinal As aRecord, With( { _SPItem: LookUp( 'Uniform Inventory', Title = aRecord.Product && Sizes = aRecord.Size ) }, { ID: _SPItem.ID, Amount: _SPItem.Amount - aRecord.TotalNeeded } ) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
as733y 224 on at

Like (0)

Report
Copy link

Link copied!
Thank you @WarrenBelz! It appears to be working.

Can you please explain the ID part of the code? I think I understand everything else in the With function
ID: _SPItem.ID,

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @as733y ,

The With() function simply retrieves the full target record and then two field values are used in the Patch - the ID as this ensures the correct record is Patched in each itineration of the ForAll (which in the structure I have posted actually makes a Table and "bulk patches" it all at once) and the Amount - "pre-fetching" it is far better than trying to patch a field using its existing value directly in the calculation.

Was this reply helpful? Yes No