A week long access audit, now ten minutes of work.
Email Distribution List Audit App
Before
1 week or more
Now
10 minutes
The challenge
Auditing a distribution list meant extracting member details, working out each person's manager, sending every reviewer a customised list and editing the list by hand afterwards.
What we built
Automated extraction of members and manager mapping, feeding a collaborative app where managers approve or remove their own team members directly.
How it runs
- ExtractMember details and manager mapping pulled automatically
- ReviewManagers approve or reject in a shared app
- ApplyDistribution list updated from approved decisions
The result
- 10 min
- Total manual effort
- 100+
- Lists the model can cover
- 0
- Follow up chasing
Built with
- Power Apps
- Power Automate
- SharePoint
- Power Query
Run this in Professional Services
The same Workflow & report automation build, scoped to your sources and your reporting lines.