• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Tachytelic.net

  • Sco Openserver
    • Sco Unix Support
    • SCO Openserver Installation ISOs
    • SCO Openserver Binaries
    • Add a Hard Drive to an Openserver 5 Virtual Machine
    • Install SCO Vision SQL-Retriever ODBC Driver on Windows 10
    • License Expired on Virtual SCO Openserver Installation
    • How to reset the root password on SCO Openserver 5
  • Scripting
    • PowerShell
      • Add leading zeros
      • Check if a File Exists
      • Grep with Powershell
      • Create Environment Variables
      • Test for open Ports
      • Append to a Text File
    • VBScript
      • Check if a File Exists
      • lpad and rpad functions
      • Windows Update E-Mail Notification
  • Office 365
    • Connect to Office 365 with PowerShell
    • Add or remove an email alias using Powershell
    • Change Primary email address of Active Directory user
    • How to hide an AD user from the Global Address List
    • How to hide mail contacts from the Global Address List
    • Change the primary email address for an account with PowerShell
    • Change Primary email address of an AD User
    • Grant a single user access to access to all calendars
    • Forward email to an external address using Powershell
    • Convert shared mailbox to user mailbox with Powershell
  • Get in Touch
  • About Me
    • Privacy Policy

How to generate a chart with Power Automate

February 26, 2021 by Paulie Leave a Comment

I recently discovered QuickChart and it is a fabulous tool for generating charts. It’s really easy to use from both PowerApps and Power Automate. In this post I am going to explain how to use it to generate charts with Power Automate using data from a SharePoint list.

Here is a sample of the SharePoint List:

SharePoint list used as data source for a chart generated in Power Automate

Here are two samples of the Output Charts that are produced:

Sample Doughnut Chart generated by Power Automate and QuickChart.io
Another Sample Chart generated by Power Automate and QuickChart.io

The charts are embedded into an email that produces a summary of the items in the list for that week. So let’s get on with it.

The HTTP action is used to make an API request to QuickChart, so a premium license is required.

The first chart above was created with a compose action and this HTTP Request:

A Power Automate Compose action which builds the HTTP content for a request to QuickChart.io
A HTTP Request from Power Automate to QuickChart.io

So the complete JSON body looks like this when submitted:

{
  "backgroundColor": "white",
  "width": 500,
  "height": 250,
  "format": "png",
  "chart": {
    "type": "doughnut",
    "data": {
      "datasets": [
        {
          "data": [
            4,
            3,
            2
          ]
        }
      ],
      "labels": [
        "John Lilleystone",
        "Paul Murana",
        "Mohammed Islam"
      ]
    },
    "options": {
      "title": {
        "display": true,
        "text": "Issues by Assignee"
      }
    }
  }
}

The easiest way for you to generate the required JSON is to use the chart maker on QuickChart.io.

The most difficult part in this flow is reshaping the data from the SharePoint list, this is obviously highly dependent on what data you are trying to bring out into the chart so it’s difficult for me to explain, but this video should give you a good idea of how you can achieve it.

The other part you may get stuck on is embedding the image as Base64 into the email. I’ve got a separate post on how to embed an image in an email here.

I produced a weekly sales summary for a customer, which goes out to them every Friday:

Sample Bar Chart generated by Power Automate and QuickChart.io

I would be interested in hearing how you get on generating charts with Power Automate. Let me know if you come up with some cool use cases.

Filed Under: Power Platform Tagged With: Power Automate

Power Automate: How to parse a CSV File to create a JSON array

February 19, 2021 by Paulie 6 Comments

There are no built in actions in Power Automate to Parse a CSV File. There are external connectors which can do this for you, but this blog post will cover how to Parse a CSV in Power Automate without the use of any external connectors. The aim is to … [Continue reading] about Power Automate: How to parse a CSV File to create a JSON array

Filed Under: Power Platform Tagged With: Power Automate

How to embed an image into an email with Power Automate

February 17, 2021 by Paulie Leave a Comment

This post explains how to embed images inside an email sent from a Power Automate flow. This is a common requirement and can cause frustration depending on the requirements. Generally, people want to include images stored within SharePoint, and … [Continue reading] about How to embed an image into an email with Power Automate

Filed Under: Power Platform Tagged With: Power Automate

Power Automate – How to extract numbers from a string

February 10, 2021 by Paulie Leave a Comment

Power Automate does not have a function to extract numbers from a string. I've seen this requirement come up a few times in the Power Automate community forums so thought I would post the solution here. Here is an image of the flow: It works by … [Continue reading] about Power Automate – How to extract numbers from a string

Filed Under: Power Platform Tagged With: Power Automate

Super Simple flow to get more than 5000 SharePoint Items

December 9, 2020 by Paulie 4 Comments

I've done a series of blog posts on how to get more than 5000 items from a SharePoint list using Power Automate. While helping someone else out I figured out a way to make it much easier. If you're not interested in knowing how it works, just … [Continue reading] about Super Simple flow to get more than 5000 SharePoint Items

Filed Under: Power Platform Tagged With: Power Apps, Power Automate, SharePoint Online

  • Go to page 1
  • Go to page 2
  • Go to page 3
  • Interim pages omitted …
  • Go to page 31
  • Go to Next Page »

Primary Sidebar

Link to my LinkedIn Profile

Recent Posts

  • How to generate a chart with Power Automate
  • Power Automate: How to parse a CSV File to create a JSON array
  • How to embed an image into an email with Power Automate
  • Power Automate – How to extract numbers from a string
  • Super Simple flow to get more than 5000 SharePoint Items

Recent Comments

  • Kathy on List all Office 365 Global Administrators with Powershell
  • Paulie on Super Simple flow to get more than 5000 SharePoint Items
  • Tom on Super Simple flow to get more than 5000 SharePoint Items
  • Jay on How to install and boot a Dell PowerEdge from a PCIe NVMe drive
  • Paulie on How to install and boot a Dell PowerEdge from a PCIe NVMe drive

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 106 other subscribers.

Go to mobile version