Automation Developer using Power Automate - MS SharePoint - Power BI
Budget: $30 – $250 USD
Hi - I am into Oracle ERP and as part of business process optimization initiatives, i would like to conduct some Proof of concept using Power Automate- Power BI solution. I have illustrated a scenario below, do get in touch if you can handle this or similar requirement
PROCESS
The ERP requires email address of employee to be added when the employee is created. The HR creates draft employee without email address. HR then emails to IT admin to create email.
PROBLEM
• Blank email for new employee creates data mismatch between applications
• Sometimes HR fails to request email address itself
• If email address is created, HR may forget to update.
STEPS
- Email Notification with a particular subject shall be created [‘New employee created with employee id 12345’]
- Body of notification email shall contain details of Employee Name, Company, Line Manager
- There is a SharePoint page which contains a grid with the above details of existing employees
and email address.
- PowerAutomate to extract the new employee details from the notification email except email
address of employee
- SharePoint to trigger workflow and send to Admin to create email and update the employee
record
- SharePoint to access the API from ERP and Update the email address
- Update PowerBI Dashboard with counter for ‘Monthly email created’ and “Average time
between Request creation to completion’.
PROCESS
The ERP requires email address of employee to be added when the employee is created. The HR creates draft employee without email address. HR then emails to IT admin to create email.
PROBLEM
• Blank email for new employee creates data mismatch between applications
• Sometimes HR fails to request email address itself
• If email address is created, HR may forget to update.
STEPS
- Email Notification with a particular subject shall be created [‘New employee created with employee id 12345’]
- Body of notification email shall contain details of Employee Name, Company, Line Manager
- There is a SharePoint page which contains a grid with the above details of existing employees
and email address.
- PowerAutomate to extract the new employee details from the notification email except email
address of employee
- SharePoint to trigger workflow and send to Admin to create email and update the employee
record
- SharePoint to access the API from ERP and Update the email address
- Update PowerBI Dashboard with counter for ‘Monthly email created’ and “Average time
between Request creation to completion’.