Flow - Send a message to a team channel when a Powell Intranet Ads is published

Powell Software Power Automate samples

Powell Software Power Automate samples are provided as a guide to understand how to connect Powell Products with Microsoft 365 features and let you easily modify them to your personal needs.  Powell Software Power Automate samples are not part of the Powell Software products & service level agreements associated with the licences (no support), it is a free add-on.

Introduction

the flow will allow you to publish a card in a team channel when you will publish a Powell Ads message from a SharePoint site.

mceclip2.png

Requirements

Note

depending the configuration of the Ads list you can have the follwing error message when you will save your flow after adding all the configurations

mceclip0.png

This is why the description field is mandatory in the content type. You need to remove the mandatory field option (Power Automate constrainte)

  • in site content, go to the Ads list > list settings
  • edit the column description and set the require option to "No"

mceclip1.png  

Configuration

Step 0:  edit the flow

  • in "my flows" section, edit the flow

mceclip3.png

  • in the detail page, click edit again

mceclip1.png

Step 1:  set the connexions

To be able to use the flow you will need to initiate multiple connexions:

  • one for SharePoint to get access to the list

mceclip2.png

  • one for SharePoint to get access to the list item details

mceclip2.png

  • two to transform the item contents

mceclip4.png

  • one for Microsoft Teams to be able to post a card into your desired channel

mceclip3.png

 

Step 2:  set the source & target of the flow

after setting the different connections, we will configuring the flow itself by setting the SharePoint Site Ads list as the content source. You will need to set the site address & the list name in the SharePoint box. 

mceclip0.png

if you do not find the Ads list in the picker you can still use the list id (TIPS - How to find a list id in SharePoint)

 

and we will set the team channel destination for the card notification

mceclip0.png

to know how to find the team channel id and team id, you can follow this article

 

Test

You have set the connexions, configured the connexions and set your SharePoint source & Team channel destination. Your flow is now complete and you are ready to test it.

Just before testing it, do not forget to activate the flow by turn it on in the top action bar in the flow resume page

mceclip1.png

You can test the flow by creating a new Ad in your SharePoint site & see after few seconds if a card will be published in the targeted team channel.

 

 

Was this article helpful?
0 out of 0 found this helpful