Request Manager Approval for Multiple Employees in 1 email

zacpolin · 2025-04-29T19:06:29+00:00

There was an error rendering this rich post.

Hello, I'm trying to create a workflow to accomplish an access approval. Any help would be appreciated. Below is my criteria.

Find a list of Admin users and there managers from a dataset. The dataset I have is already filtered down to include this information. There is less than 20 rows of data.
Send an email to their manager requesting them to approve their access.
1. If there are multiple employees under the same manager, that manager should only get 1 email. Multiple tasks would be alright so they could accept/reject on an individual basis but we don't want a manager getting spammed with multiple emails.
Store the results of the response in a dataset.

So Far:

I'm using the query table function to get a list of the admin users and their managers. I'm currently saving the output as an object list

SELECT "Domo User Display Name" DomoUserDisplayName, "Domo Role" DomoRole, "Manager Email" ManagerEmail FROM dataset

I then created a general task to assign a task to the manager but I'm unsure how to assign each manager individually a task for there employee(s) only.

I have Domo IDs and email addresses for both employees and managers in the dataset depending on which is better for the workflow.

Quick Links

Accepted answers

JasonAltenburg

It sounds like you need to iterate through the dataset twice to get what you want.

First pass: Group the results by manager to send a single notification email per manager. Unless personalization is crucial, you can simplify the email content since the manager will be directed into Domo to complete tasks anyway. If you do want to list employees in the email, loop through each manager’s employees and build a concatenated list to include in the message body.

Second pass: Create an individual approval task for each employee, assigning it to the appropriate manager. That way, managers receive just one email but see distinct tasks for each direct report requiring access approval.

All comments

JasonAltenburg

It sounds like you need to iterate through the dataset twice to get what you want.

zacpolin

Hi Jason,

Thank you. This was very helpful and led me to create a working model. I decided I don't need to send an email to the manager with the employees in the message body since they will just be directed into Domo anyways.

I created the below to iterate through the dataset but it sends 1 task/approval email to the manager per employee. Is there a way to create the individual approval task but only notify the manager once? Or is this what you were referring to with the grouping by manager?

DanHendriksen

In your step where you gather employee name and manager, don't you still have the association of employee ID to manager?

While it's possible to aggregate all the requests for one manager and roll them up in to one task, it's going to introduce quite a bit more complexity.

zacpolin

Hi @DanHendriksen, thanks for taking a look at this!

Yes, I still have the association of employee ID to manager in that step.

Understood. I agree that having individual tasks for each employee to manager association is the best approach. I was just hoping not to spam managers with multiple emails all at once since a manager could have multiple employees reporting to them.

i.e. when this process runs I would get 1 email asking me to review my tasks for my employee(s). If I had 10 employees I would get 1 email but still 10 tasks in Domo. The way it's currently built, I would get 10 emails within seconds of each other.

DanHendriksen

You can turn the email notifications off, and just let them check the queue.

DanHendriksen

Or, you can turn email notifications off, and then at the end just send them one email as a step in your workflow that tells them to go check the queue.

zacpolin

Thank you for the ideas @DanHendriksen. That could work, unless it turns off email notifications for everyone else's workflows that contain tasks. I'll review internally. Thanks!

DanHendriksen

Notifications can be configured on a user by user basis.

other categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Data Connections
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Ask questions about Workbench, a secure, client-side solution for uploading your on-premise data to Domo.
Cloud Integrations
Ask questions about Cloud Integrations and Federated Data connection to your data warehouse or lake.
Data & ETL
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
Visualize & Apps
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Dashboards
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
App Studio
Ask questions about building apps in App Studio.
Pro-code Components
Ask questions about pro-code components and Domo Bricks and get answers from Domo peers.
Charting & Analyzer
Ask questions about charting and Analyzer and get answers from Domo peers.
Calculations & Variables (Beast Mode)
Ask questions about using calculated fields and Variables (Beast Modes) in Analyzer.
AI & Data science
Ask questions about DomoAI and get answers from Domo peers.
Domo AI & AI Chat
Ask questions about AI Chat and AI assistants.
Managing AI
Ask questions about managing AI with AI Playground, AI projects, AI models, and more.
Jupyter Workspaces
Ask questions about Jupyter Workspaces, Notebooks, and file share.
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Workflows
Ask questions about Task Center, building automations with Domo Workflows, and executing JavaScript or Python code with Code Engine.
Alerts
Ask questions about managing alerts in Domo and get answers from Domo peers.
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask questions about embedded analytics with Domo Everywhere.
Reporting
Ask questions about Scheduled Reports, Report Builder, and Slideshow Publications.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Navigation & Productivity
Ask questions about navigation, Projects & Tasks, Goals, and Buzz chat.
APIs
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Add-ins & Plugins
Ask questions about plugins, Microsoft add-ins, and other third-party software integrations.
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.

Find more posts tagged with

Admin

Approvals

Workflows