So you have multiple Microsoft Teams Auto Attendants, and before every holiday your help desk is slammed with requests to update the out of office date on all these. There are always 3rd party tools you can buy to help you out, but I like to see what’s possible to create yourself almost for free. We are going to create form users can fill out to update holiday opening hours and greeting for your Auto Attendants.

First we need an App Registration in portal.azure.com. This is to be able to read the audio file users are uploading as a greeting message.

Click ‘New Registration’

Give it a name and click ‘Register’

Take note of the Client ID and Tenant ID, you will need that in the PowerShell script further down.

Click ‘API permissions’, ‘Add a permission’ and ‘Microsoft Graph’.

Click ‘Application permissions’.

Select ‘Files.Read.All’.

Click ‘Grant admin consent…’.

Go to ‘Certificates & secrets’ and click ‘New client secret’. Give it a name and click ‘Add’.

Copy the value of the secret.

Now we need to register an Automation Account.

Click ‘Create’ and enter the needed info and click ‘Create’

Click ‘Go to resource’.

Now we need to import the Teams PowerShell module into the Automation Account, so go to ‘Modules’ and click ‘Add a module’.

Search for ‘Teams’ and click on ‘Microsoft Teams’.

Click ‘Select’.

Select ‘7.1’ as the ‘Runtime version’. This is because PowerShell 5.1 in Azure Automation does not like to read wav files. Click ‘Import’.

Go to ‘Variables’ and click ‘Add a variable’. Give it a name and paste the App Registration secret as the value. Click ‘Create’

Go to ‘Credentials’ and click ‘Add a credential’. Add the username and password of a Teams admin account, then click ‘Create’.

Go to ‘Runbooks’ and click ‘Create a runbook’.

Choose the following settings and click ‘Create’.

Here you paste the PowerShell script you can find below.

Click on ‘Publish’ and ‘Yes’.

Now we need to create a Microsoft Form. Click ‘New Form’.

Create the form based on the screenshots below. We use the display name of the Auto Attendant to find the correct one in the script, so that’s what’s added to field number 1.

Now we need to add some branching.

You can choose to share this openly or with specific people/groups.

The last part of the puzzle is to create a Power Automate flow that is triggered by the form and kicks of Azure Automation.

Go to ‘Create’ and click ‘Automated cloud flow’.

Give it a name and select ‘When a new response is submitted’.

Follow along and create the same actions as in the screenshots below.

Copy this JSON Schema and paste in under ‘Schema’ in the next action.

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": "string"
            },
            "link": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

Now we are done, so let’s test to see everything is working.

This is just one example of what’s possible to create a self-service solution for Microsoft Teams Auto Attendant. Another thing you could create is the possibility to change the weekly recurring opening hours or maybe add a new greeting.