Workflow Automation CoE > Flows > Go back to hierarchical lookup
Goal
In this Workflow Automation Center of Excellence article, you’ll learn to use “Go back to” flow logic with a flow variable to iterate up a hierarchy until a defined condition is met.
Technology and Use Case
This article is an addition to an older article about hierarchical lookup with the do the following until flow logic. With the introduction of the new go back to flow logic, we have a new way to loop in flows until we reach a record that matches our defined condition. We will only look at the updated looping design pattern and the other lessons learned in the previous article still apply:
- Use decision tables
- Be sure to cover edge cases
- Create subflows to re-use logic in various scenarios
Workflow Studio is our central low-code workflow automation technology, where we build flows, playbooks, and decision tables. We’ll use the go back to flow logic and a flow variable which we can set with the corresponding flow action.
For this use case, we ultimately want to create an approval for a catalog item, where the approver is the first user up the management chain [sys_user.manager] with a title containing “VP”.
This flow logic pattern can also be used to look up other parent-child record relationships, for example looking up:
- Cost center [cmn_cost_center] parent records with a certain Manager or Location
- Looking up location [cmn_location] parent records until you reach the region or state level
- Looking up group [sys_user_group] parent records
- Looking up department [cmn_department] parent records
- Etc.
Instructions
First, we’ll look at the users in our example scenario. As you can see, we have multiple layers of users that each have a manager until we reach John Retak, whose title is “VP, Finance and Securities”.
Build the subflow
These are the steps to follow to build this subflow.
- Create a reference flow variable on the User table
- Initiate the flow variable from the subflow inputs
- Use an if branch to check if the manager fits the title condition.
- If yes, assign the manager to the subflow output.
- If not, update the flow variable with the manager’s manager.
- Go back to the if condition to repeat.
Step 1: Create the flow variable
To create a flow variable, click on the three dots in the top right corner. Click on ‘Flow Variables’ to open the modal.
Click on the plus in the top right of the modal to add a flow variable. Configure it to be a Reference/Record on the User table.
Step 2: Initiate the flow variable
Add a new flow logic step “Set Flow Variables” in your flow. Click on the plus in the top right corner of the step to add a new row. Choose the flow variable you created from the drop-down on the left. With data pill dot-walking, set it to the current user’s manager. In our example, this is Subflow - Inputs -> Start User -> Manager.
Step 3: Use If logic to check if the title matches
As the next step, add a new flow logic step “If” with a condition to check if the next manager’s title contains the title we’re looking for from the subflow inputs.
Step 4: Assign subflow output
If the condition is met, we populate the output with the flow variable.
Step 5: Else set the flow variable
If the condition is not met, we will overwrite the flow variable with the next manager, one level up.
Step 6: Loop back to the if condition check
Lastly, we’re looping back to the if step to see if the next manager stored in the flow variable will satisfy the condition.
Step 7: Test the subflow
Now, we'll test this subflow for one of our test users. We can see that the first (and second) iteration did not satisfy the condition, but the third loop did.
Check for more edge cases
What if none of the managers in the upstream management chain has a VP title? One way to catch this and make sure we don’t loop endlessly is to add a condition to check if there even is a next manager. Here you can either just end the flow and not provide an output or assign a fallback (approval) user. Optionally, use a decision table to determine the fallback user as described in the previous article.
Conclusion
Let’s review our flow once more. We have a start user and title to look for. If the title of the start user’s manager matches the condition, we’re good to go and the flow is done. Otherwise, we’ll update the flow variable with the next manager in the hierarchy, check if there even is one and if yes, loop back to check for the title again.
Center of Excellence Navigation
Hello @Lisa Holenstein
I've been trying to get the subflow to work, but I keep getting the error: 'Max iteration limit exceeded.'
I might have messed something up in the flow—could you help me troubleshoot it? Thanks
