Hey everyone! I'm part of a small organization with about 30 employees, and we've been using Microsoft 365. Lately, I've been bogged down by a lot of manual tasks that I think could be automated to make life a bit easier. Here are some of the tasks I'm looking to streamline:
- Setting or removing automatic replies from email templates, especially since some of our senior users aren't able to manage this themselves.
- Granting and removing mailbox access.
- Onboarding new employees: creating users, assigning licenses, making HTTP requests to our in-house software, setting Exchange custom attributes, and sending welcome emails.
- Offboarding: removing users from groups and disabling accounts.
I'm considering using either PowerAutomate or PowerShell for these tasks but unsure which tool would work best for me. Would PowerAutomate handle everything I need, or would I hit a limit eventually? How would you approach this? Is there an even better solution for automating these tasks?
4 Answers
I’d go with PowerShell any day! While PowerAutomate is fine for simple automation, PowerShell really packs a punch when you need flexibility and control.
I've been using N8N for similar tasks and find it quite user-friendly. It’s free, allowing me to automate things like onboarding when HR tickets come in. It even helps with offboarding and makes the process really quick. The best part is, I’ve been able to set up a bunch of workflows in about two months, and our director is really happy with the outcomes!
PowerShell is a strong contender here, especially because of its error handling and logging capabilities. If you’re new to it, you could use tools like CoPilot to help generate scripts. It can be pretty helpful in getting you started!
I’m working on a similar setup right now. I’ve built a dashboard with Power Apps that triggers various Power Automate flows, including some PowerShell scripts via Azure Automation. Just keep in mind that although Power Automate is great, especially with the Graph API, it doesn’t cover all PowerShell functionalities, especially with tasks like managing mail-enabled security groups. My advice is to use a mix of Power Apps, Power Automate, PowerShell, and Azure Automation where they fit best!
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures