Workflow to update list item in a different list

6 years ago
28 July 2017
1 reply
3 views

+1

ayampolsky
1 reply

Hello. I need help with Ninetex workflow.

Lets say I have 2 lists: supply inventory and supply requests

Supply inventory would have 3 columns: title, initial quantity, available quantity.

If I need 5 pens, I would create a supply request, choose "pen" from list lookup column, and type 5 for desired quantity. As soon as I save my list item, a workflow should find an item from Supply Inventory with title "pen", subtract 5 from available quantity, and save the item.

If request was rejected, 5 should be added to available quantity amount.

Thank you in advance.

1 reply

Userlevel 5

+14

emha
Scholar
4681 replies
6 years ago
30 July 2017

first you need to get actual inventory value for ordered item from inventory list. use Query list action and filter by ordered item.

configure to return value of available quantity field.

returning of item ID is as well useful - it will be used to write update back to inventory list

next use Math action to add or substract ordered or rejected amount.

and finally update new value back to inventory list.

whereas it is possible to implement it this way, I do not recommend to use sharepoint for these kind of logic at all!

sharepoint is not transactional system!

if two or more requests are being processed at about the same time, you will get wrong inventory levels calculated.

Reply