Skip to content
English
More support
Contact us
  • There are no suggestions because the search field is empty.

⚙️ Using Microsoft Power Automate

This article demonstrates how to automatically send data from an Excel table in Microsoft Power Automate (Flow) to Key Performance Indicators (KPIs) in ValueStreamer via the REST API. The example shows a simple use case with dynamic values retrieved from an Excel sheet.

🔍 Contents

  • Prerequisites
  • Flow Process Overview
  • Example HTTP Request Body
  • Result in ValueStreamer
  • Tips & Best Practices
  • FAQ

📋 Prerequisites

  • Access to Microsoft Power Automate (including Premium connector for HTTP requests)

  • Access to the ValueStreamer REST API (API user, credentials, module versions)

  • Existing KPI IDs (can be retrieved via Postman or API calls)

ℹ️ Note: Any changes made via the API are logged under API-USER in the change log.

🔄 Flow Process Overview

1. Trigger (Recurrence)

The flow starts automatically every day at 1:00 AM UTC using a Recurrence trigger.

2. Read Excel Table

  • An Excel file stored in OneDrive or SharePoint is opened.

  • All rows from a specific table are read.
    Example table ID: {E9ECB220-E2E0-46DC-B536-CFA12EEC692C}

3. Loop for Each Row

  • A For each loop iterates over every row of the Excel table.

  • Inside this loop, an HTTP request is sent to the ValueStreamer REST API.

4. HTTP PUT Request

  • The Planned and Actual values from the current Excel row are transmitted in the request body.

  • Authentication is performed via HTTP Basic Auth.

  • Content type:

     
    Content-Type: application/vs.v2.0+json

📸 Screenshot – Structure of the Power Automate Flow

📝 Example HTTP Request Body

 {
  "values": [
    {
      "kpiValueId": "d38f2923-d3d1-4c45-955e-cce58f52111d",
      "value": 7777
    },
    {
      "kpiValueId": "e7930247-76bd-4867-8911-cb722cc12348",
      "value": 6666
    }
  ]
}

🎯 Result in ValueStreamer

Once the flow runs successfully, the KPI values are automatically recorded in ValueStreamer.
The “Planned” and “Actual” values are displayed in the relevant KPI dashboard.

📸 Screenshot – Recorded Values in KPI Dashboard

✨ Tips & Best Practices

  • Retrieve IDs automatically via API calls inside the flow rather than maintaining them manually.

  • Start with a small number of test rows.

  • Schedule execution so that no parallel API write operations occur.

  • Document your flows and review them regularly.

❓ FAQ

Can I use data sources other than Excel?
→ Yes, for example SQL databases, SharePoint lists, or other APIs.

How do I find the kpiValueId?
→ By sending a GET request to the corresponding API endpoint (via Postman, Power Automate HTTP action, or another middleware).

Is Basic Auth mandatory?
→ Yes, currently the API only supports HTTP Basic Authentication.

Can I send multiple values at once?
→ Yes, by including multiple objects in the values array.

Does this process also work with other API modules?
→ Yes, only the URL, JSON body, and media type need to be adjusted.