Announcements
"I’m building a Power App that allows employees to order promotional items. The app uses two SharePoint lists: one for inventory (Inventory) and another for orders (Orders). Selected items are stored in a collection named colCart.
Inventory
Orders
colCart
The app successfully adds items from colCart to the Orders list, but I encounter an error when trying to subtract the Quantity in colCart from Inventory.Quantity_Available in the Inventory list. The error message is:
Quantity
Inventory.Quantity_Available
'Error when trying to retrieve data from the network: Fetching items failed. Possible invalid string in filter query.'
Here’s the logic I’m using in the ForAll loop to update Inventory.Quantity_Available:
ForAll
ForAll( colCart, Patch( Inventory, LookUp(Inventory, ID = ThisRecord.ID), { Quantity_Available: LookUp(Inventory, ID = ThisRecord.ID).Quantity_Available - ThisRecord.Quantity } ) )
The ID column in Inventory and colCart are numeric and match. I can get the code to work if I use a static quantity. What could be causing this error, and how can I correctly update the Quantity_Available column in the Inventory list?"
ID
Quantity_Available
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 243 Super User 2026 Season 2
WarrenBelz 190 Most Valuable Professional
Mohsin Ali 135