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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,077)