Power Platform Community Forum Thread Details

Hello, I am trying to create a workflow that will allow for my employees to send a request for inventory supplies (on a Microsoft list) that will automatically subtract that value from my inventory list, also on a Microsoft list. I have attached below what all I currently have; my question is why is it not working/ what am I doing wrong? Please let me know what I should do to resolve this!

Categories:

Building flows

Hi there!

Here's a working flow. I have a simple List with Title and Quantity.

My form allows for multiple selections (and assumes quantity of 1 for the demo).

My flow

My compose is the question output and I am using this expression:

json(outputs('Get_response_details')?['body/rdb76adcc28024aa5a9856f31982f1764'])
 
That's going to give me the array of each item selected.
 
Next I've manually added an apply to each and used the body of the compose.
 
Next my Get items is filtering on the apply to each item.
 
Next my update item has two expressions:
 
ID:  
first(body('Get_items')?['value'])?['ID']
 
Quantity:sub(
    int(first(body('Get_items')?['value'])?['Quantity']),
    1
)
 
As the old saying goes, works in testing!