Back to Automize Monthly Report Creation with Power Automate
Coursera

Automize Monthly Report Creation with Power Automate

Imagine you're working in a large company and part of your job is to send reports to other departments about employee absence from work in the past month. Basically, it is a repetitive and boring manual task that repeats every month and takes a lot of your time. However, you can easily automate it with SharePoint and Power Automate! In this beginner-level guided project "Automize Monthly Report Creation with Power Automate", we will create a SharePoint Site and a SharePoint list with data about employees' annual leave days, sick leave days or days off. All the data will be kept in one place. That data will help us to create the Monthly Employee Absence Report. The Power Automate flow will export data from the SharePoint list and save it in an Excel spreadsheet. Then we will send the table (the report) in an email as an Excel table. The requirement for this project is having a Microsoft Developer Program account, and you will be provided with instructions on how to get it right here. If you are ready to make your and your colleagues’ lives easier by starting to automate manual, time-consuming processes which are hard to track, then this project is for you! Let's get started!

Status: Email Automation
Status: Data Import/Export
BeginnerGuided Project1 hour

Featured reviews

Reviewed Sep 26, 2022

T​he training could have been better if the trainer would have used real life examples.

Reviewed Jan 17, 2023

Please allow us to maximize the screen or let us make zoom - it hearts my eyes because the buttons and actions in power automate is already small.

All reviews

Showing: 9 of 9

Mustapha
Reviewed Jan 18, 2023
Charlene
Reviewed May 5, 2024
Tatyasaheb
Reviewed Sep 27, 2022
David
Reviewed Jun 11, 2025
Marco
Reviewed Mar 20, 2024
ManojKumar
Reviewed Mar 27, 2023
Raj
Reviewed Mar 24, 2023
Kevin
Reviewed Mar 14, 2025
Harsh
Reviewed Feb 26, 2023