M365 Automation using PowerShell in Azure Function
summary
Shows a working automation: Teams Copilot Studio front end → Power Automate orchestration → SharePoint list as ticket store → Azure Function running PowerShell that calls Exchange Online with Managed Identity. Demo runs a message-trace and returns results (demo replies in minutes); modules load via requirements.psd1 and failures surface in Kudu diagnostics. Deployment hiccup from website_run_from_package being set by VS Code is demonstrated and fixed so the function succeeds.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 2:24Agenda
- 4:10On-premise PowerShell challenges
- 12:55Automation demo with Copilot Studio
- 24:37Prerequisites for demo
- 31:50Create Function App in VS Code
- 40:00Configure PowerShell script
- 50:39Managed identity setup
- 1:00:17Deploy and test script
- 1:13:10Debugging logs
- 1:20:29On-premise vs Azure automation
- 1:25:19Automation best practices
- 1:31:50Quiz and wrap-up
related talks
45mDemystifying Microsoft's Cloud Automation products
48mPowerShell in Azure Functions
47mAzure Functions PowerShell: The Missing Manual
47mImplementing ChatOps using Microsoft Power Platform
47mBest practices for automating Azure with PowerShell...
01h 31mAccelerate Business Delivery With AI and DevOps
47mAutomate Problem Solving with PowerShell, Azure Automation, and OMS
51mImprove PowerShell scripting with Azure integration