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.
- 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.