Microsoft Power Automate is a RPA (Robotic Process Automation) application which helps to automate certain fixed process of our day to day tasks.

This guide is for automating the tedious process of generating P-Report in order to analyse Production Capacity.

The RPA for P-Report has already been programmed accordingly dated 16th September 2021. End-Users will only need to run the RPA automation to generate P-Report. For editing of this RPA, please send a ticket to IT for further assistance.


Installation 

  1. Kindly send a ticket to IT to schedule a installation time to install Power Automate Desktop


Operating RPA for P-Report

  1. Open Power Automate app on your desktop 
  2. Click Shared with me.
  3. Select the correct automation flow.

  4. Click the run icon to run the automation.

  5. Click Open when prompted the Security Warning triggered by MS Access in the file server.

  6. Enter the Month and Year of the report to build in the correct format as shown on the prompt and click OK. *Take note of the format required otherwise the automation will not run properly.*

  7. Enter the Start Date of report to build and click OK. Do take note of the format required on the prompt.

  8. Enter the End Date of report to build and click OK. Do take note of the format required on the prompt.


  9. The next prompt will be out after running the RPA for awhile. Click on Update followed by Continue on the next prompt to proceed.
  10. Now you may sit back and do your stuffs while letting the RPA do your job.

  11. Once automation is completed, a info message will appear and inform you. Click OK to end the RPA.