Automize Monthly Report Creation with Power Automate

提供方
Coursera Project Network
在此指导项目中,您将:

Create a SharePoint site and list

Create a Power Automate flow that exports data from the SharePoint list to an Excel table.

Modify the flow to send the report by email.

Clock90 minutes
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

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!

您要培养的技能

  • Power Automate Flow
  • Microsoft Excel
  • SharePoint

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Create a SharePoint Site

  2. Create a SharePoint List

  3. Create a flow that exports data from the SharePoint list

  4. Modify the flow to send the report by email

  5. Test the flow and check the results of each action

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心