Imagine working in a car rental company that manually tracks which cars are rented out and which ones are ready for rental. As employees, we are responsible for informing all other employees about available cars each day and we are performing a repetitive process each day: we have to open SharePoint, find a site and Excel file, download the file, open it in Excel, filter out available cars, export it as PDF and send it by email to other colleagues who are responsible for car rentals, so they know which cars can be offered to the customers. Of course, this process is time consuming, and we don’t know which part of that process can be automated or how to automate it.
Imagine working in a car rental company that manually tracks which cars are rented out and which ones are ready for rental. As employees, we are responsible for informing all other employees about available cars each day and we are performing a repetitive process each day: we have to open SharePoint, find a site and Excel file, download the file, open it in Excel, filter out available cars, export it as PDF and send it by email to other colleagues who are responsible for car rentals, so they know which cars can be offered to the customers. Of course, this process is time consuming, and we don’t know which part of that process can be automated or how to automate it.
Thankfully, with Power Automate Process Advisor, not only can we see where the bottlenecks are and what can be automated, but we can also get a recommendation for which actions a Power Automate flow could be used for achieving the wanted automatization of this business process. With that, we can easily give machines to handle the repetitive process and spend our time on other business tasks. So, from 7 manual steps which must be done each day, we will end up with only 1 manual step, triggering the flow which we will create. How cool is that?
This Guided Project " Use Process Advisor to Analyze and Automate Manual Process" is for any business professional who is looking to automate any kind of manual business process. In the project you will create a SharePoint site and a list (from a sample Excel file), and learn how to use Power Automate Process Advisor to analyze the manual process. You will also create a flow with the guidance of the Process Advisor analysis result. What’s great about SharePoint and Power Automate is that anyone can learn to use them regardless of their educational background!
Since this project uses Office 365 services (SharePoint, Excel, Outlook) and Power Automate (part of the Microsoft Power Platform), you will need access to a Microsoft account and a Microsoft 365 Developer Program subscription account. In the video at the beginning of the project you will be given instructions on how to sign up for both.
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!
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.