Skip to main content

In our organization, we are trying to standardize group membership based on Department and Job Title. I’m also setting up our Onboarding module to automate as much of the setup in Azure/MS365 as possible. For instance, if we bring on a new IT employee, I want the workflow to add this employee to the relevant IT security and MS365 groups in Azure.

I’m finding that in my Onboarding workflow there is no way to filter the requests by the department or job title of the new employee. The Condition node doesn’t allow to filter by Onboarding fields, just by the ticket fields, and the tickets themselves are usually assigned to IT or HR. 

Has anyone else had any luck using the Workflow Automator, along with the Azure AD - Orch app, to build the user account and add to security groups based on a new employee’s Department membership or Job Title?

I figured this out by building a table of Custom Objects linking job titles, departments, and security groups. It works great!


We don’t use the onboarding module we use a custom workflow for onboarding.

On the Service Request form for a new hire, we have mandatory fields for Job Title (selects from Custom Table of Job Titles) prevents users from typing in whatever they want.  Also requires Department which we have an in custom table.

Using that information we have workflow objects review those and add you to necessary groups. If employee go into Employee group, Consultants to Consultants group, IT to some admin functions, etc.