Home >Tips >Power Automate >Monthly Projects Report kalmstrom.com site map icon Site map  

Monthly Projects Report

A SharePoint Flows tutorial by Peter Kalmström

Flow iconManagers often ask for various kinds of periodical reports, and it is of course convenient to let a flow generate them.

In the demo below, Peter Kalmström, CEO and Systems Designer of kalmstrom.com Business Solutions, shows how to create a flow that generates a monthly e-mail with information about total number of projects with an approved budget and the total sums of the approved budgets. 

Peter uses two kinds of variable actions in this flow: Initialize variable and Increment variable. The Increment variable actions adds to the Initialize variable actions and count the number of projects and the sum of the approved budgets in an Apply to each action.

When you create flows that send e-mails, it is a good idea to put yourself as the receiver first, so that you can test the flow without disturbing other people. When the flow runs as it should, you can edit the flow and change the receiver of the e-mail.

Microsoft flow generated e-mail

Steps to create a flow that sends a monthly projects report

  1. Start with a Schedueld blank flow and set the frequency to 1 month and the time when you want the flow to start.
  2. In the trigger, set the time zone under advanced options.
  3. Add the action Variables, Initialize variable. Set the Name to TotalNumberOfProjects and the Type to Integer. Leave the Value field blank, as this value will be calculated by an Increment variable action.
  4. Add the action Variables, Initialize variable. Set the Name to TotalApprovedBudget and the Type to Float. Leave the Value field blank, as this value will be calculated by an Increment variable.
  5. Add the action SharePoint, Get items and select the Projects list site and the Projects list.
  6. Add the action Apply to each and set the output to the dynamic content value.
  7. Add the action Variables, Increment variable for the Apply to each. At Name, select the variable TotalNumberOfProjects. Set the Value to 1.
  8. Add the action Variables, Increment variable for the Apply to each. At Name, select the variable TotalApprovedBudget. Set the Value to the dynamic content Approved Budget.
  9. Add the action Office 365 Outlook, Send an email (V2) and fill out the receiver e-mail address and the subject. For the body, write some explaining text and add the dynamic contents TotalNumberOfProjects  and TotalApprovedBudget.
  10. Save the flow.
  11. Recurrence flows can be tested via the Test button in the editor or via the Run command on the My flows page. Both open the same right panel where you can run the flow.


Make the report good looking with HTML code in the body: https://www.kalmstrom.com/Tips/SharePoint-Flows/Flow-E-mail-Formatting.htm 


Learn more






back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved