Let me start by explaining the issue i am having.... I have two lists:
ListA: This list has two columns, 1 for Location and 1 for Approvers (Person/Group)
ListB: This list has a bunch of columns, one of which is Location
When an item is submitted in ListB, I want to query ListA, using the Location as a filter. I then want to set the Approvers to a variable and then email this variable. When i do this, my workflow suspends. After searching for the past hour or two, a user mentioned using the 'Get an Item from a Dictionary' action but i cannot figure this out.
Attached is what my variable looks like. Please provide some guidance on what i am doing wrong or another way to accomplish this. Thanks in advance.
Solved! Go to Solution.
So for this I am thinking you can use the Query List Action to get the approvers, pull their "work email" and then email that.
Here is the video for you to watch how I did this. Also, you can import the workflow as well to walk through it. Replace the list with your list and you should be good to go.