How can we help?

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
  • SharePoint List data upload and image download.
  • 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

You can get your event_id from your webhook. (Use the Set internal datasource action type)

SharePoint List Upload and image download

Needed Components

  • SharePoint – When an item is created or modified
  • SharePoint – Send an HTTP request to SharePoint
  • SharePoint – Get file content using path
  • OneDrive – Create file
  • 2x Data Operation – Parse JSON
  • Data Operation – Compose
  • 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 – Send an HTTP request to SharePoint

Need to select your Site Address, set the method to GET and Uri path need the be this:

/_api/web/lists(guid’YOUR LIST GUID‘)/items

You can find your list GUID here.

Data Operation – Parse JSON

At this point, you need to run your flow first.

When you got the “Your flow ran successfully.” message, you need to copy the OUTPUTS information.

After this, you add the Parse JSON from the Data Operations, select the HTTP request for items’ body dynamic content.
Click on the Generate from sample and paste here the OUTPUTS texts and click Done.

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.

You need to select the result dynamic content or you can copy this and paste it to the field:

@{body(‘items’)?[‘d’]?[‘results’]}   

(items = The name of your Parse JSON action)

Data Operation – Parse JSON

In this section, we will get our Image data. In the example list, we have a ‘MainPicture’ column, where we upload our images.

We need to select the from the Apply to each the ‘MainPicture’  dynamic content or you can copy this and paste it to the field:

@{items(‘forEachItem’)?[‘MainPicture’]}

(forEachItem = The name of your Apply to each action | ‘MainPicture’ = The name of your column with images)

In the Schema copy-paste this:

{
  “type”: “object”,
  “properties”: {
    “fileName”: {
      “type”: “string”
    },
    “serverRelativeUrl”: {
      “type”: “string”
    },
    “id”: {
      “type”: “string”
    },
    “serverUrl”: {
      “type”: “string”
    },
    “thumbnailRenderer”: {
      “type”: “object”,
      “properties”: {
        “spItemUrl”: {
          “type”: “string”
        },
        “fileVersion”: {
          “type”: “integer”
        },
        “sponsorToken”: {
          “type”: “string”
        }
      }
    },
    “type”: {
      “type”: “string”
    },
    “fieldName”: {
      “type”: “string”
    }
  }
}

SharePoint – Get file content using path

Here we will get the image content.

You can get ‘serverUrl‘ and the ‘serverRelativeUrl‘ from the previous action in the Add dynamic content section.

(The ‘image Item’ is the Parse JSON action’s name)

OneDrive – Create file

This will create the image.

Select your folder where you want to put the image file.

The name of your file should be the fileName from the ‘parse JSON’ action and the file content should be the File content from the Get file content using path action.

(You can find these in the add dynamic content section)

Variable – Set variable

Here you can put your data together.

You can select them from the ‘Add dynamic content’ section or you can add it manually with this:

@{items(‘forEachItem’)?[‘Title’]} , @{items(‘forEachItem’)?[‘Details’]}…etc

(forEachItem = The name of your Apply to each action | ‘MainPicture’ = The name of your column with images)

Variable – Append to array variable

We append the item to an array.

 

Data Operation – Compose

We set our body here for the HTTP request later.

The format structure:

{
“event_id”: “event_id”,
“data”: {
“myListData”: “your Array”
}
}

You can get your event_id from your webhook. (Use the Set internal datasource action type)

 

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 Composed data from the previous section.

If you struggle to build up your flow. You can download it here.

How to Export and Import MS Flow

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

You can get your event_id from your webhook. (use the Insert to internal datasource array action type)

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

You can get your event_id from your webhook. (use the Insert to internal datasource array action type)

Our basic internal datasource looks like this

and we use the Insert to internal datasource array webhook.