Patching to a Sharepoint List

(0) Share

Report

Posted on by as733y

224

Hello,

I'm creating an app that has a set list of items (chips, soda, etc) that is used to keep track of how many of each item is used and needs to be replenished.

I am trying to patch the collection back to the data source (sharepoint list). I need to update the "Needed" column in the sharepoint list with the amount needed, so as the app is used, the data source would be sorted by the items used most.

Below is what I have, and I'm pretty sure it's correct, but I'm not sure how to get the sum function to work. I feel like I'm super close, but can't figure out the formating for the sum function?

Patch('Stock List', First(Filter('Stock List', Title=BrowseGallery2.Selected.StockColStock && StockType=BrowseGallery2.Selected.StockTypeColStock)), {Needed: Sum(Needed,TotalNeeded)})

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Consider removing the "First/filter" part of your formula, that's a performance hit you don't need to take.

Patch('Stock List', LookUp('Stock List, Title = BrowseGallery2.Selected.StockColStock && StockType=BrowseGallery2.Selected.StockTypeColStock)........

What error are you getting with your Sum() function?
as733y 224 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @zmorek ,

Do you know why this ForAll function isn't patching all my items in my collection?

ForAll(ColTotal,Patch('Stock List', LookUp('Stock List',Title=BrowseGallery2.Selected.StockColStock && StockType=BrowseGallery2.Selected.StockTypeColStock),{Needed: TotalNeeded}))