Microsoft Power Automate flow: Push an adaptive card to a Teams channel
Ultimately I built this flow after studying this blog article. The bugaboo is that the flow requires your Site Pages Library ID, which isn't easily accessible.
- Navigate to your Site Pages.
- Click Automate > Power Automate > Create a flow. Microsoft suggests some templates, so look for a flow that connects SharePoint and Teams. The specific one that gives me what I need is currently titled "Post a message to Microsoft Teams for a selected file." This starts the process for setting up the flow, but we're not actually going to use this flow template. Follow the buttons until you get to the flow itself. From here you can copy the Library Name because it's automatically populated. Or you can keep using this template, but make some changes based on below.
- Build the flow. There are three flow steps you need (see screenshot):
- For a selected file
- Get file properties
- Post adaptive car in a chat or channel
- Save, turn on your flow, and test it. I created a private Team where I do all my SharePoint testing, so it might be wise to grab the Site Pages Library ID for a place like that to push your first few adaptive cards.
- Copy your flow as many time as you need to push to different channels or Teams.
For a selected file
Choose the site where you will be pushing pages from and paste in the Library ID you copied from step 2.
Get file properties
Choose the same site and enter the same Library ID as above. Additionally this stage asks for an Id. Choose entity.FileId.
Post adaptive card in a chat or channel
This is where you can play. It's also where I found it most challenging. Microsoft offers samples here and a place to play around here. However, here are my settings:
- Post as: Flow bot
- Post in: Channel
- Team: [select the destination Team that you have access to]
- Channel: [select the channel]
- Adaptive card: [paste in the JSON payload from the designer] I gave you my code below, but you'll need to futz a bit. Refer back to the blog article I mentioned above because it explains how you need to use dynamic content fields. My design pulls in Topic Header, Title, First Published Date, Banner Image URL, Description, and Link to Item.
{
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"type": "AdaptiveCard",
"version": "1.3",
"body": [
{
"type": "ColumnSet",
"columns": [
{
"type": "Column",
"items": [
{
"type": "TextBlock",
"text": "@{body('Get_file_properties')?['OData__TopicHeader']}",
"wrap": true,
"fontType": "Default",
"size": "Medium",
"color": "Accent",
"weight": "Default"
},
{
"type": "TextBlock",
"text": "@{body('Get_file_properties')?['Title']}",
"weight": "Bolder",
"size": "ExtraLarge",
"spacing": "None",
"wrap": true,
"color": "Default",
"fontType": "Default"
},
{
"type": "TextBlock",
"text": "@{body('Get_file_properties')?['FirstPublishedDate']}",
"spacing": "None",
"wrap": true,
"fontType": "Default",
"size": "Medium",
"weight": "Default",
"color": "Default",
"isSubtle": true
}
],
"width": 3
},
{
"type": "Column",
"width": 1,
"items": [
{
"type": "Image",
"url": "@{body('Get_file_properties')?['BannerImageUrl']}",
"altText": "decorative banner image"
}
]
}
]
},
{
"type": "ColumnSet",
"columns": [
{
"type": "Column",
"width": "stretch",
"items": [
{
"type": "TextBlock",
"text": "@{body('Get_file_properties')?['Description']}",
"wrap": true,
"maxLines": 4,
"spacing": "None",
"fontType": "Default",
"size": "Medium",
"weight": "Default",
"color": "Default"
}
]
}
],
"spacing": "Large",
"separator": true
}
],
"actions": [
{
"type": "Action.OpenUrl",
"title": "Read more",
"url": "@{body('Get_file_properties')?['{Link}']}"
}
]
}
