cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sutekh666
Helper II
Helper II

Updating a field in a list when an item is added in a different list

Afternoon

 

What I'm trying to do is that when a user adds an item to a list called Test Issued Stock the flow recognises that item in a list called Test inventory and reduces a number field called 'Quantity' by 1. As a first step I've been trying to get the correct item to update in the Test inventory list by changing the 'Quantity' field in Test Issued Stock. The flow is running but it's not updating the field. I picked the 'Product Name' fields in both lists to use in the condition which I thought would identify the correct list item. Is this the wrong approach? All help appreciated!

 

 

UpdateitemTwoLists.png

1 ACCEPTED SOLUTION

Accepted Solutions
sudharsan1985
Super User
Super User

@Sutekh666 

Whenever trying to get an item from another list when triggering from a different list, you should not use Get Item. Since you need to pass the ID to the Get item action the ID on both the lists doesn't match and its not recommended to use that approach. Try to use Get items with a common field and then update the item based on the output.

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

View solution in original post

2 REPLIES 2
sudharsan1985
Super User
Super User

@Sutekh666 

Whenever trying to get an item from another list when triggering from a different list, you should not use Get Item. Since you need to pass the ID to the Get item action the ID on both the lists doesn't match and its not recommended to use that approach. Try to use Get items with a common field and then update the item based on the output.

 

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

View solution in original post

Sutekh666
Helper II
Helper II

Thanks @sudharsan1985 ! That worked

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (53,830)