top of page
Writer's pictureDataZoe

Keeping up with the Power BI Blog with Power Automate

Before I joined the Power BI product group, I had a friend show me how to have the Power BI blogs show up in a Teams channel. You can have it email you or add it a Slack channel, etc, whatever Power Automate supports and works for you.


So how is this set up?



1)Create a channel in Teams, if you want to use a new channel. If you want it in an existing one or output somewhere else, skip this!


2)Go to Power Automate, make.powerautomate.com and create a new Flow. Pick New automated cloud flow.


3) Edit the RSS trigger for When a feed item is published


4) Add the Teams for Post message in a chat or channel (or where you want it to go!)

  • Post As: Flow bog

  • Post In: Channel

  • Team: The team you want it to land in

  • Channel: Pick the channel you want it to land in

  • Message: Craft how you want it to show. I used this format using the Feed title and Feed summary and build the URL with the primary link.


You can even have it go to multiple places.


Now you can save it and turn it on!


Code view for RSS

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "feedUrl": "https://powerbi.microsoft.com/en-us/blog/feed/",
      "sinceProperty": "PublishDate"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_rss",
      "connection": "shared_rss",
      "operationId": "OnNewFeed"
    }
  },
  "recurrence": {
    "frequency": "Minute",
    "interval": 5
  },
  "splitOn": "@triggerOutputs()?['body/value']",
  "metadata": {
    "operationMetadataId": "<GUID for yours>"
  }
}

Code view for Teams posting

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "poster": "Flow bot",
      "location": "Channel",
      "body/recipient/groupId": "<GUID for yours>",
      "body/recipient/channelId": "<will be different for you>",
      "body/messageBody": "<p><strong>Power BI blog update - @{triggerOutputs()?['body/title']}</strong></p><span style=\"color: #777777;\">Summary</span><br />@{triggerOutputs()?['body/summary']}</p><p><a href=\"@{triggerOutputs()?['body/primaryLink']}\">Click here to read more.</a></p>"
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_teams",
      "connection": "shared_teams",
      "operationId": "PostMessageToConversation"
    }
  },
  "runAfter": {},
  "metadata": {
    "operationMetadataId": "<GUID for yours>"
  }
}

84 views0 comments

Recent Posts

See All

Comments


bottom of page