I’m trying to setup a change management request scenario with three lists but I’m having issues getting the 2nd list to update after the 3rd and final workflow.
After being approved the State column in list 1 wasn’t changing so I added an Update List item step to change the Action of the item in Tier 1 before updating the State and it worked (using Suggestion Topic as the search field) The Tier 1 Input List is now showing the item as DONE when I approve the request in the third workflow.
But it’s still showing the State of the Tier 2 Input list as WT3. I tried adding update Tier 2 list item steps to change the action then the state, also using suggestion topic as the search, but it’s still saying WT3. And it’s disappearing from view for my test account but not my regular account.
I’m confused as to why the same two steps to update the item in Tier 1’s list works but not for Tier 2’s list. I’ve seen some replies mention “When you create item in list 2 keep a lookup column pointing to ID for list 1. So when any changes are made to list 1 search for the item in List 2 with column values as List1_ID.”
But I’m not sure what exactly that entails. Any help would be appreciated.
I used the instructions from this blog as a foundation
Here’s my 3rd workflow which works up until the Update item in Tier 2 Input step.
Paul nailed it. The user approving list 3’s items didn’t have permissions for list 2. Feel free to close the thread.
