You are here:
< Back

How to use Power Automate and Wallboard together

 

In this article, we will go through some steps that you need if you want to make an automated system that uploads your SharePoint list data, Microsoft Teams messages to our system, then you can work with your data on Wallboard.

 

(IMPORTANT! Some components only available with pro license)

 

Contents:

  • SharePoint list data upload to as internal datasource
  • Microsoft Teams messages upload with message trigger to the wallboard as internal datasource.
  • Microsoft Teams messages upload with a keyword to the wallboard as an internal datasource.

 

SharePoint List Upload 

Needed Components 

  • SharePoint – When an item is created or modified 
  • SharePoint – Get Items 
  • 2x Variable – Initialize variable 
  • Control – Apply to each 
  • Variable – Set variable 
  • Variable – Append to array variable 
  • HTTP – HTTP 

Set up your flow 

SharePoint – When an item is created or modified 

Need to select your Site Address and your list’s name! 

This will trigger your flow. 

SharePoint – Get Items 

Need to select your Site Address, your List Name, the Limit Entries to Folder, and the included nested items. 

2x Variable – Initialize variable 

Here we make an Array and an Object variable. 

We will store all the data here. 

Control – Apply to each 

We need to go through all the values we have. 

Inside the Apply to each 

We set our data  

and we append it to the array. 

HTTP – HTTP 

Here you need to setup your HTTP 

You will set your method to POST, setup your URI with your chosen server 
(e.g. https://yourChoosedServer.wallboard.info/public-api/integration/webhooks) 

In the headers, you need to give 

  • content-type → application/json 
  • x-webhook-apikey → your API key (API key) 
  • You need to fill the body with your event_id and your data

MS Teams message trigger with a simple message

Needed Components

  • MS Teams – When a new channel message is added
  • Variable – Initialize variable
  • Variable – Set variable
  • HTTP – HTTP

Set up your flow

SharePoint – When a new channel message is added

You need to select the Team and the channel for your trigger.

Variable – Initialize variable

Variable – Set variable

HTTP – HTTP 

Here you need to setup your HTTP 

You will set your method to POST, setup your URI with your chosen server 
(e.g. https://yourChoosedServer.wallboard.info/public-api/integration/webhooks) 

In the headers, you need to give 

  • content-type   application/json 
  • x-webhook-apikey → your API key (API key) 
  • You need to fill the body with your event_id and your data

Our basic internal datasource looks like this

and we use the Insert to internal datasource array webhook.

MS Teams message trigger with a keyword

Needed Components

  • MS Teams – When keywords are mentioned
  • MS Teams – Get messages
  • Variable – Initialize variable
  • 2x Control – Apply to each
  • Control – Condition
  • Variable – Set variable
  • HTTP – HTTP

Set up your flow

MS Teams – When keywords are mention

Need to select the message type, the keywords to search for, and the team

MS Teams – Get messages

Select your Team and the channel

This will give us back all the messages in the channel.

Variable – Initialize variable

2x Control – Apply to each

We need to go through all the message IDs with the keywords message ID to find the correct one.

Control – Condition

We match the IDs here (All message ID and the mentioned message ID)

If the Condition is Yes (true)

Variable – Set variable

HTTP – HTTP 

Here you need to setup your HTTP 

You will set your method to POST, setup your URI with your chosen server 
(e.g. https://yourChoosedServer.wallboard.info/public-api/integration/webhooks) 

In the headers, you need to give 

  • content-type  → application/json 
  • x-webhook-apikey → your API key (API key)
  • You need to fill the body with your event_id, data, keySelector, index

Our basic internal datasource looks like this

and we use the Insert to internal datasource array webhook.