A leading Global Business Services company, providing a range of services and solutions in strategy, consulting, and operations management, leveraged MSFT Power platform. This technology provides a suite of apps, services, connectors, and data platform that provides a rapid application development environment to build custom apps for their business needs. They intended to eliminate their manual activities and streamline their processes. 

  • Microsoft Power Apps
  • Microsoft Power Automate
  • XrmTool
  • PowerQuery
  • Azure directory service
  • External API service for field validations

Pre-Automation Process

The payroll creation and validations are done manually. New client on-boarding / Employee info updates are done through multiple mail exchanges between the payroll Admin and HR of the company, which also goes through multiple validations before being fed to payroll processing.

The pre-automation process involves a lot of communication between the HR and the Payroll admins for clarification purposes. This takes up a lot of time for the Payroll Admin to process. Employee PAN Card validation had to be done on an external website for every employee which was time-consuming. The automated process has features to address these issues. 


The business process is expected to satisfy the below requirements with the Microsoft app:



The business objectives and benefits expected by the company after automating their selected business process are: 


Expected Automation Impact