PowerShell

Ever had a user accidentally delete a critical Power Automate flow? Until May 2022, your only option was to raise a support call with Microsoft — but that all changed when the Restore-AdminFlow cmdlet was released. In this post, I’ll walk you through restoring deleted flows with PowerShell and show you how to build a self-service solution using Azure Runbooks, Power Automate, and Power Apps. There are native actions in Power Automate for adminstering flows but there is no current timescales for releasing an action to restore flows directly. If you were wondering if it was possible to restore flows from Power Automate or Power Apps using the Platform, then I have a solution for you - Azure Runbooks. I have a blog post showing you how I built a Runbook to change the sharing options of SharePoint using Power Automate. ...

Invited an external guest into your Microsoft Team only to find they can’t access any files? You’re not alone — this is one of the most common SharePoint and Teams issues I come across. In this post, I’ll show you exactly why it happens and how your SharePoint admin can fix it, including a PowerShell script for those tricky private channel scenarios. “We can’t get your files. We’re working on getting them back” ...

Ever needed to quickly pull a list of members from your Microsoft 365 Groups and export them? In this quick post, I’ll share a simple PowerShell script using the Get-UnifiedGroup cmdlet that does exactly that — filters your groups and dumps all members into a tidy CSV file. The PowerShell Script Use the Get-UnifiedGroup CMDLet and if your sites are prefixed like mine, filter on the DisplayName. $CSVPath = "C:\Temp\AllGroupMembers.csv" Connect-ExchangeOnline $list=Get-UnifiedGroup -Filter "DisplayName -like 'SitePrefix*'" foreach ($Group in $list) { #Get Group Members and export to CSV Get-UnifiedGroupLinks –Identity $Group.Id –LinkType Members | Select-Object @{Name="Group Name";Expression={$Group.DisplayName}},` @{Name="User Name";Expression={$_.DisplayName}}, PrimarySmtpAddress | Export-CSV $CSVPath -NoTypeInformation -Append } Output The above script will return a CSV. ...

What if you could run PowerShell scripts directly from Power Automate? After attending the Global Automation Bootcamp and seeing demos by Ben Stegink and Jaap Brasser, I was inspired to build a PowerShell Azure Runbook called from Power Automate using the Azure Automation Create Job step. Here’s how I did it. The Problem — SharePoint External Sharing My employer has a policy where all new SharePoint sites are setup with external sharing disabled and the only way to change this setting (as of today) is via the Admin GUI or PowerShell. We have a requirement to change the default setting to existing guests if manager approval has been granted, PowerAutomate has Approvals built in. This is the perfect opportunity for PowerShell to meet PowerAutomate. ...

If you rely on Microsoft Stream for storing meeting recordings, heads up — the default storage location is changing. Historically, recordings would be available via the Stream portal, but for some and soon for all, Stream recordings will be diverted to OneDrive for Business. Details of which are here. Reverting the Storage Location with PowerShell If this happens to affect your business and you wish to revert back to or check the setting of the default storage location for your Stream videos, please try out the following PowerShell. ...