Power Automate Workflow for Sharepoint
Budget: $30 – $250 AUD
I require a professional proficient in Microsoft Power Automate to automate a series of tasks involving Sharepoint, csv files and Excel. Here's a breakdown of the project:
- **Folder Review**: The Power Automate workflow should review 'Folder A' on Sharepoint.
- **Data Manipulation**: Each CSV file within the folder needs to undergo data manipulation.
- **Excel Data Transfer**: The manipulated data from CSV files should be transferred to a single excel file into a single table. This process should replace the existing data within the file.
- **Excel Manipulation**: The Excel file should have pivot tables created based on the imported data.
- **Email Notification**: Once the Excel file is updated, an email should be sent to a specified user.
Ideal candidates for this job should have:
- Proficiency in Microsoft Power Automate
- Experience working with Sharepoint and Excel automation
- Strong skills in data manipulation and transformation
- Previous experience creating automated email notifications
Please provide a clear overview of how you intend to approach this task when submitting your proposal.
A comprehensive overview of the requirements and workflow is shown in the attachments along with the sample csv input files and a sample Excel output file. Thank you.
- **Folder Review**: The Power Automate workflow should review 'Folder A' on Sharepoint.
- **Data Manipulation**: Each CSV file within the folder needs to undergo data manipulation.
- **Excel Data Transfer**: The manipulated data from CSV files should be transferred to a single excel file into a single table. This process should replace the existing data within the file.
- **Excel Manipulation**: The Excel file should have pivot tables created based on the imported data.
- **Email Notification**: Once the Excel file is updated, an email should be sent to a specified user.
Ideal candidates for this job should have:
- Proficiency in Microsoft Power Automate
- Experience working with Sharepoint and Excel automation
- Strong skills in data manipulation and transformation
- Previous experience creating automated email notifications
Please provide a clear overview of how you intend to approach this task when submitting your proposal.
A comprehensive overview of the requirements and workflow is shown in the attachments along with the sample csv input files and a sample Excel output file. Thank you.