Power Platform Community Forum Thread Details

Hi Everyone

I am trying to automate onboarding tasks that uses both PA and PA Desktop.

The flow is working but it is not completed yet. I am trying to find out how do I use the PowerShell script in Power Automate Desktop to create an Exchange Office 365 mailbox based on the value on the Excel spreadsheet.

I tried to googling on how to write the scripts but to no avail. Can someone point me to the correct direction please?

Power Automate flow:

Power Automate Desktop flow:

Categories:

General topics

Hi @nicklim

For running powershell script via power automate desktop, use run powershell script action

For powershell script, i found one sample code from ChatGPT 😅

May be you can give a try

# Connect to Exchange Online or Exchange Server
$UserCredential = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session

# Set the mailbox parameters
$Name = "John Smith"
$EmailAddress = "john.smith@contoso.com"
$Password = ConvertTo-SecureString "P@ssw0rd123" -AsPlainText -Force

# Create the mailbox
New-Mailbox -Name $Name -Alias $EmailAddress -UserPrincipalName $EmailAddress -Password $Password -ResetPasswordOnNextLogon $false

# Disconnect from Exchange
Remove-PSSession $Session

Here for the place you need variables, you can replace that with variables from power automate

Let me know if you have any questions 🙂

Mark it as solution if it resolves your query