MSPowerhouse — Your Strategic IT PartnerMSPowerhouse
All case studies

Defense · Case Study

Automated Distribution List Management Using SuccessFactors and M365

More than 20 M365 distribution lists at QinetiQ were being updated manually based on employee metadata. MSPowerhouse used SuccessFactors as the source of truth and built an automation stack — Power Automate, Azure Automation, PowerShell, SharePoint, Blob Storage, Exchange Online — that updates list membership from HR data automatically.

Client
QinetiQ
Engagement
2023
Industry
Defense
Outcome
20+ Distribution lists automated
Automated Distribution List Management Using SuccessFactors and M365

The challenge

  • 20+ DLs were maintained manually based on changing employee metadata.
  • Membership depended on job code, department, location, supervisor, business unit, and more.
  • Updates were time-consuming and prone to missed changes.

Our approach

  • Used SuccessFactors employee data as the source of truth.
  • Processed data through Power Automate, Azure Automation runbooks, PowerShell, and Blob Storage.
  • Applied rules over employee attributes to determine DL membership.
  • Updated Exchange Online DLs automatically as metadata changed.

Results

20+ DLs
Updated from HR data automatically
Rule-driven
Membership logic
Reduced
Manual admin & errors

Could this be your team next?

Tell us about your environment and we'll come back with a one-page diagnostic in 48 hours.

Get a free assessment