calculate and update column value of another list when item created

(0) Share

Report

Posted on by YAYA

105

Hi,

I am working on IT Asset Management System, I have two sharePoint lists, one for IT asset to assign materials, and the other one for materials categories and the quantity of each.

my issue here when I create a new item in IT asset list in PowerApps, I need to update materials quantity as well.

lets say I have 30 Laptops in materials list, So when I assign a new laptop in IT asset list, in Materials list I want to update the quantity value of the laptops from 30 to 29.

What is the best approach to do so.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @YAYA ,

You did not provide any code, so I assume you have not attempted any yet and will give a syntax guidance answer.

You would have a "linking" common field between the lists, so I will call that Category for the moment. You would also have a Quantity field in Materials.

So if you assigned a Category item in Assets, you would do something like this

Patch( Materials, {Category:AssetCategoryField}, {Quantity:Quantity-1} )

All the values above naturally will depend on your lists and where you are running it from.

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.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @YAYA ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
Verified answer

YAYA 105 on at

Like (0)

Report

Hi @WarrenBelz
sorry for my delay reply as i was on vacation, i have solved the issue by power automate , in powerapps once you click the button the flow kick off, i have tried your solution but some how is not calculated right, thank you for your help

Was this reply helpful? Yes No