Over the coming weeks I am going to be doing Power Automate post to demostrate the ability to automate workloads within Microsoft 365. Today, I am going look at configuring an Approval process for the creation of a Microsoft Teams Channel
Configuring a SharePoint List
I am no expert when it comes to SharePoint but any expert in “Share Pint” as how does love a good drink now and then. So back on topic within your SharePoint Online Site you need to create a new list as shown in the image below.
Give your SharePoint List a name and description for future reference.
As you can see from the below, I have create a number of columns to capture the information I would like to include into the approval process.
| Column Name | Column Type |
| Title | Title used for the Channel Name. |
| Team Name | Name of the Microsoft Team |
| Description | Description of the new Channel |
| Justification | Justification for the request |
Configuring Power Automate
Create a new Flow from the SharePoint List > Automate > Power Automate > See your Flows
Click New > Automated from blank. Provide a Flow name, i.e. “Request – New Microsoft Teams Channel Provisioning”,
Select your Site Address and List Name as shown below.
Modify the Start an approval in line with your requirements, for this post I have included the layout I have created for my own tenant.
We now need a Data Operation in order to gather the Teams ID which is required to identify the Teams where the channel will be created.
first(split(last(split(triggerBody()['webUrl'],'groupId=')),'&tenantId'))
Add connector List teams and no additional
Create Filter array which looks at the Teams List based on the Team Name against the entry in the SharePoint List.
Next step is to create a channel with uses the apply to each array.
We have now completed the flow, so let’s go and create the request. As shown below.
This will now generate a request to create the team channel automatically in the background and as you can see all the new Project Channels have been created.
Regards,
The Author – Blogabout.Cloud
