I am Shadrack Inusah, a graduate Gold Microsoft Learn Student Ambassador from Accra-Ghana, a software developer enthusiast with community building experience and a member of the Microsoft Learn Student Ambassadors Low Code No Code League. I Love to help student learn and build together to solve a technical world problem. Create awesome stuff in M365 and Power Platform. I'm a Power Addict and Mentor students for the MLSA program in Africa.
In my first blog, I will be taking you through the creation of an approval request flow in Power Automate when a form filled and send an adaptive card to Teams for approval. After approval, the data then updates in real-time excel online. All this happens with just a click and no demanding work is needed to execute this flow. This will be in two parts; the final part will be submitting approvals with or without attachments using a condition.
To begin with you will need a Microsoft 365 account which will give you access to all the business applications and developer tools. You can sign up for a Free Microsoft 365 E5 instant sandbox or watch a video I made on that.
When all is set, head to teams, and create a channel where the adaptive cards will be sent to for approvals and add all who the request are to be assigned to, to the teams channel. New to Microsoft Teams, then head here to read on creating a channel in teams.
Here, I created a Team called "APPROVAL TEST" and later created a channel called "Approvals1".
Teams channel to display adaptive card for approval
After you are done with your Teams setup, next thing to do is to create a MS Form through which the request will be made from.
Customize the form to suit your request details. I created a form called "Approval form" which I will be using also in the blog.
Next is the creating of the flow in Power Automate to receive the response from the form and process it for approval in Teams using Teams Adaptive card.
This will be done in few steps;
1. Click the "Create" link on the left pane of the Power Automate home.
2. Click "Automated cloud flow" (Automated cloud flow Triggered by a designated event) from the next page.
3. From the popup mini window, give your Flow a name and choose your flow's trigger. Here we will select "When a new response is submitted" (Microsoft Forms). This operation triggers a flow when a new response is submitted.
Click create after that.
4. In this step, select the following:
Form ID - Approval form (MS form created)
Response Id - Response Id (Select from the Dynamic content popup)
5. Add a new action, search for "create and approval" and click on it.
Approval type - "Approve/Reject - Everyone must approve" (Select what suit your approval request)
Title - "NEW APPROVAL REQUEST" (Your preferred title here)