
Closed
Posted
Paid on delivery
Every week I spend far too much time copying data out of Microsoft Forms, combing through emails and their attachments, and then pasting everything into Excel, SharePoint, and finally Power BI so our dashboards stay up-to-date. I’m ready to hand that work to a set of reliable, well-documented flows. Here’s what I need built: • A series of Power Automate (or comparable) workflows that watch three sources simultaneously: – New Microsoft Forms responses or items added to SharePoint lists – Incoming emails—plus any attached Excel, CSV, or PDF files—in Outlook – Activity or data drops from Teams, Outlook, or Dynamics 365 • Each flow should cleanse and normalise the data, then: – Append or overwrite rows in one or more master Excel workbooks stored in OneDrive/SharePoint – Push the same data to connected SharePoint lists for team visibility – Trigger an automatic refresh so our Power BI dashboards reflect the new information without manual intervention • Error handling and notification: if a file is malformed or a mapping fails, I want an email (or Teams message) that clearly states what went wrong and which record needs attention. • Lightweight documentation: a simple diagram of each flow, the trigger conditions, key actions, and where credentials or connections are stored so I can maintain it later. Acceptance criteria 1. A test submission from each source populates the correct Excel table, updates the corresponding SharePoint list, and refreshes the designated Power BI dataset within five minutes. 2. All connections use service accounts or connection references that can be re-authorised without editing the flow steps. 3. Error notifications arrive within two minutes of any failure, showing the run history link for quick troubleshooting. If you’ve built multi-source Microsoft 365 automations before—using Power Automate, Logic Apps, Graph API, or similar—let’s talk.
Project ID: 40783041
114 proposals
Remote project
Active 2 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
114 freelancers are bidding on average £142 GBP for this job

My expertise in Excel automation, Power Query, data cleansing, and Power BI directly matches your goal of replacing repetitive Microsoft 365 data handling with reliable, maintainable workflows. I build spreadsheet systems that run themselves, including AI-integrated commission automation, VBA-driven forecasting, and live inventory, headcount, and project-management systems built for real business operations. I can apply that experience to consolidating Forms, Outlook attachments, SharePoint, Teams, and Dynamics data into structured Excel workbooks and SharePoint lists, while keeping the information clean and dashboard-ready for Power BI. My background in Microsoft Office, Excel, Power BI, data processing, and PDF/document solutions is also well suited to handling mixed file types, normalising records, and making exceptions understandable when a mapping or file fails. I will deliver clearly organised automation supported by lightweight documentation, with an emphasis on dependable connections and easy ongoing maintenance. I’m ready to build a practical Microsoft data workflow system that removes the weekly manual effort from your team.
£20 GBP in 1 day
8.2
8.2

My strong Excel and data-cleansing background makes me well suited to organise the information moving through your Microsoft 365 workflows. I work extensively with MS Excel, Microsoft Office, PDF forms, data entry, data analysis, data mining, and web-based data collection—skills directly relevant to consolidating Forms responses, email attachments, and other incoming records into dependable master workbooks. I can help structure and normalise Excel and PDF data so it is consistent and ready for use across Excel and SharePoint, while keeping the resulting records clear for reporting and dashboard updates. My experience with data cleansing and careful record handling also supports accurate mappings and identifying malformed or incomplete entries that need attention. I would be glad to apply my Excel, Microsoft Office, and data-cleansing skills to create reliable, maintainable Microsoft data workflows and supporting documentation. Choose me to help reduce the repetitive manual work behind your reporting process.
£135 GBP in 1 day
7.7
7.7

Hi there, I have carefully reviewed your project and understand that you need a reliable, end-to-end automation system that consolidates data from Microsoft 365 sources, keeps Excel and SharePoint synchronized, and refreshes Power BI dashboards without manual intervention. First, I’ll map your existing data sources, workbook structures, SharePoint lists, and Power BI datasets to establish consistent field mappings. Then, I’ll build modular Power Automate flows for Forms, SharePoint, Outlook attachments, Teams, and Dynamics 365, incorporating data validation, normalization, duplicate prevention, and appropriate handling for Excel, CSV, and PDF inputs. Next, I’ll automate updates to your master workbooks and SharePoint lists, configure Power BI refresh triggers, and implement failure notifications with record details and run-history links. Finally, I’ll test each source against your five-minute synchronization target, verify connection references and service-account ownership, and provide flow diagrams and maintenance documentation. One key question: Are your incoming PDFs digitally generated with selectable text, or do some contain scanned pages requiring OCR? I also have ideas for improving reliability through centralized error logging and reusable flow components. Please initiate a chat so we can discuss the technical requirements and next steps. Cheers, Aneesa
£75 GBP in 1 day
6.5
6.5

Hi there, I went through your project description and understand you need reliable Microsoft 365 automation flows that consolidate data from Forms, SharePoint, Outlook, Teams, and Dynamics 365 into Excel, SharePoint lists, and Power BI with minimal manual work. I will first map your data sources, formats, destinations, and existing dashboard dependencies. Using Power Automate, I will build modular flows with appropriate triggers, data cleansing, field mapping, and Excel or SharePoint updates. I will handle email attachments in Excel, CSV, and PDF formats, with suitable extraction methods for each file type. I will configure Power BI refresh actions, reusable connection references, and service-account authentication where supported. Robust error handling will notify your team through email or Teams, identify the failed record, and include the relevant run history link. I will test each source against your five-minute update and two-minute error-notification targets, then provide flow diagrams and maintenance documentation. I will provide an initial integration plan within 24 to 48 hours of being awarded the project. To scope your project clearly, I would like to ask: are your Power BI datasets and master Excel workbooks already configured, and do you have the required Microsoft 365 licensing and permissions for these integrations? I look forward to helping streamline your reporting workflow. Kind Regards, Imran Ali
£70 GBP in 1 day
6.1
6.1

Hi, I can help automate your Microsoft 365 workflows using Power Automate, integrating Forms, Outlook, SharePoint, Excel, Teams, and Power BI. I’ll focus on data cleansing, reliable synchronization, automated dataset refreshes, error notifications, and clear documentation. I’ll also include reusable connection references, structured error handling, and testing to meet your acceptance criteria as closely as the available connectors and platform limits allow. I’m ready to discuss your current workflow and build a maintainable automation solution. Suzon
£135 GBP in 10 days
6.0
6.0

Hi! I’d replace the repetitive copy-paste process with a set of reliable, documented Power Automate flows across Forms, Outlook, SharePoint, Teams, and Dynamics 365. I’ll build reusable data-cleaning and mapping steps, process Excel/CSV/PDF attachments where supported, update master Excel tables and SharePoint lists, and trigger Power BI refreshes. I’ll also include duplicate checks, failure alerts with run-history links, and maintainable connection references. Fixed price: £250 for an agreed, prioritised initial implementation Timeline: 5–7 business days I’ll test each agreed source-to-destination path and document triggers, actions, connections, and troubleshooting. The five-minute refresh target will be validated against connector limits, file sizes, and Power BI capacity. Quick question: Which source-to-destination workflow is most urgent, and do you already have the Excel tables, SharePoint lists, and Power BI dataset in place? — Sahanaj
£250 GBP in 5 days
6.1
6.1

⭐⭐⭐⭐⭐ Build Power Automate flows to sync Forms, Email, Teams data to Excel, SharePoint & Power BI ❇️ Hi My Friend, I hope you are doing well. I checked all of your project requirements and I can see you are looking for Power Automate workflows. You have no need to look any further as Zohaib is here to help you! My team is already doing 50+ similar projects for Microsoft 365 automation. I will build reliable flows that watch Forms, Outlook and Teams, cleanse data and write to Excel and SharePoint, then trigger a Power BI refresh. I will also add error alerts and a simple diagram, all within the same budget. ➡️ Why Me? I can easily do your automation as I have 5 years of experience in Power Automate, Microsoft Forms, SharePoint, Outlook, Teams, Power BI. Not only this, I have a strong grip on Graph API, Logic Apps, data cleansing and service‑account connections. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ Power Automate ✅ Logic Apps ✅ Microsoft Forms ✅ Outlook ✅ Teams ✅ SharePoint ✅ OneDrive ✅ Power BI ✅ Graph API ✅ Data Cleansing ✅ Error Handling ✅ Documentation Waiting for your response! Best Regards, Zohaib
£150 GBP in 2 days
5.9
5.9

Microsoft Forms and Power Automate workflows are already part of my automation and data-management skill set, supported by strong experience with Excel, data cleansing, and Power BI. I can help replace repetitive copying across Forms, Outlook, Excel, SharePoint, and reporting systems with structured, reusable workflows that keep your information consistent and your dashboards current. My background includes advanced Excel workbooks, VBA macros, CSV and Excel import/export workflows, automated reporting, duplicate removal, large-dataset organization, and data validation. This aligns directly with cleansing incoming records, processing spreadsheet data, maintaining master Excel tables, and preparing reliable information for Power BI. I also focus on practical, editable deliverables with clear documentation, so the workflows can remain maintainable after delivery. I would be glad to build your multi-source Microsoft data automation with dependable error notifications, reusable connections, and documentation that supports ongoing maintenance. Choose me to turn this weekly manual process into a reliable reporting workflow.
£135 GBP in 7 days
5.5
5.5

Hi Claire, I will deliver Power Automate flows watching Forms, SharePoint, Outlook emails and Teams, cleansing data, updating Excel/SharePoint and refreshing Power BI, plus documentation. I’ll have a prototype in three days within your £250 budget. I can start now and share a sample flow
£135 GBP in 3 days
5.3
5.3

Hello I can build reliable Power Automate workflows integrating Microsoft Forms, Outlook, Teams, Dynamics 365, Excel, SharePoint, and Power BI, with data cleaning, automated refreshes, error notifications, reusable connections, and clear documentation. Regards Muhammad
£100 GBP in 1 day
5.3
5.3

This is a strong use case for Microsoft Power Automate. I’d recommend building a modular, event-driven automation solution across Microsoft 365, with a shared data-processing layer, centralized error handling, and controlled Power BI refreshes. The key is to make the workflows reliable, idempotent, and maintainable—so a retry does not create duplicate records, malformed attachments do not silently disappear, and connection credentials can be renewed without rebuilding the flows.
£350 GBP in 3 days
5.7
5.7

Am expert in automation and I finish the whole workflow in the same day. Thank you....................
£135 GBP in 1 day
4.5
4.5

I can build a reliable, documented Microsoft 365 automation layer that removes the weekly manual copying between Forms, Outlook, Teams, Dynamics 365, Excel, SharePoint, and Power BI. I’ll design the flows around reusable connection references or service accounts, with clear source-to-destination mappings and centralized handling for Excel, CSV, and PDF attachments. Each workflow will cleanse and normalize incoming data, update the appropriate master Excel tables and SharePoint lists, and trigger the designated Power BI dataset refresh. Reliability will be built in from the start: validation checks, duplicate and malformed-file handling, scoped error actions, and notifications containing the failed record, failure reason, and run-history link. I’ll also test each source end-to-end against your five-minute refresh requirement and verify that failures generate alerts within two minutes. You’ll receive lightweight maintenance documentation for every flow, including diagrams, triggers, key actions, data mappings, and connection/credential guidance. The implementation can use Power Automate directly, with Logic Apps or Microsoft Graph where they provide better control for specific integrations.
£250 GBP in 2 days
3.9
3.9

Hello, I'm Denis, a full-stack developer. I've built multi-source Microsoft 365 automations that pull data from Forms, email, and SharePoint, then push it to Excel and Power BI dashboards automatically. Your goal is to stop spending hours weekly moving data between Forms, email attachments, Outlook, and your master Excel and SharePoint tables. You need three parallel flows that watch these sources, cleanse data as it arrives, and keep Power BI dashboards current—with reliability your team can trust and fast alerts when issues occur. I'd start by mapping each source, its data shape, and exact destination. Then I'd build the three Power Automate flows using connection references for secure, reusable credentials. Each flow includes data cleansing, error handling that sends Teams or email alerts within two minutes with run history links, and Power BI dataset refresh triggers. I'd test against real submissions to confirm data reaches Excel, updates SharePoint, and refreshes Power BI within five minutes, then provide a diagram and maintenance notes. The key challenge is handling different file formats and attachment types reliably. I'd build validation steps that catch malformed files early and route them to your error queue rather than breaking the flow. The main risk is unclear field mappings between sources and destinations, so I'll confirm those with you in detail before building. I can start right away. Let's connect and discuss the details. Thanks, Denis.
£20 GBP in 3 days
3.9
3.9

Hello, After carefully reviewing your project requirements, I fully understand your goal of automating data collection, processing, and Power BI reporting across Microsoft 365. I have experience with workflow automation, API integrations, and data processing, and I'm available to start immediately. In my opinion, the main challenge is preventing duplicate records and inconsistent updates when Forms, Outlook attachments, SharePoint, and Dynamics 365 trigger workflows simultaneously. I'd use Power Automate with reusable data-mapping logic, unique record IDs, validation rules, and controlled retries. Each flow would normalize incoming data, update Excel tables and SharePoint lists, trigger Power BI refreshes, and send detailed Teams or email alerts with run-history links. I'd configure connection references, test malformed files and duplicate submissions, and provide flow diagrams and hand-off documentation. One important consideration is that the five-minute Power BI refresh target depends on licensing and dataset configuration. I have two quick questions: • Are your Power BI datasets using Import or DirectQuery? • Are incoming PDFs structured forms or scanned documents? I'd be glad to discuss the implementation and start immediately. Best regards, Carlos.
£30 GBP in 7 days
3.7
3.7

Hi, hand-copying Forms, emails and attachments into Excel, SharePoint and Power BI every week should be automated. I’d build this in Power Automate: flows for Forms/SharePoint, Outlook (with Excel/CSV/PDF attachments) and Teams/Dynamics. Each one cleans the data, writes to your Excel tables and SharePoint lists, then refreshes Power BI. Connections would use service accounts, failures would send an alert with the run-history link, and each flow gets a simple diagram so you can maintain it. Which source is messiest today? I’d start there.
£80 GBP in 1 day
3.9
3.9

Hi, I would start by proving one source-to-dashboard path, with validation and duplicate protection before expanding to the other sources. My £250 bid is for that first pilot: one agreed Forms/SharePoint or Outlook CSV input, one Excel table, one SharePoint list, refresh triggering, failure alerts and a short handover diagram. It does not cover all three integrations or arbitrary PDF extraction. I will check connector licences and Power BI refresh limits before committing to the five-minute target; triggering a refresh and completing it are different. I can deliver the pilot within 5 days after access and mappings are agreed. Which source causes the most manual work today?
£250 GBP in 5 days
3.7
3.7

Affordable, Early Delivery. ★★★★★★★★★★★★★★I hold a Masters degree which gives me the requisite background to handle writing from various subjects. I am a highly committed person towards my work. You can rely on QualityXenter for quality and consistency in writing. We never violate copyright rules. I have vast amount of experience in this industry since I am working from 2015 as a professional writer. I provide many modifications till to get your satisfactions. I have access to enough journals to use in your research project. I always produce quality work at VERY LOW RATES so, don't worry if you have a low budget for your work, I will be very happy to make a new client like you. I am producing quality work for my clients including ARTICLE WRITING, REPORT WRITING, ESSAY WRITING, RESEARCH PAPERS, BUSINESS PLAN, TECHNICAL WRITING, MATLAB, THESIS, ACCOUNTING & FINANCE work ETC. Go through my profile link https://www.freelancer.com/u/qualityxenter
£30 GBP in 1 day
3.3
3.3

I can help you eliminate repetitive data entry by building reliable Microsoft 365 automation workflows that connect Forms, Outlook, SharePoint, Excel, Teams, and Power BI—keeping your data synchronised and dashboards updated with minimal manual effort. Thank you for considering my proposal. I have gone through the requirements in detail. I will configure Power Automate flows with data cleansing, validation, Excel table updates, SharePoint synchronisation, and Power BI refresh triggers. I will also implement error handling with actionable email or Teams alerts, including failed record details and run-history links. My approach includes testing each source against your five-minute update target, using maintainable connection references or service accounts, and providing flow diagrams and clear documentation covering triggers, actions, dependencies, and connection management. I have uploaded samples of similar automation, reporting, and dashboard projects completed by me earlier in my profile. With 10+ years of professional experience and strong expertise in Excel, Power BI, data management, and process improvement, I am committed to delivering a scalable, well-documented solution. Could you share how many master workbooks and Power BI datasets need to be connected? This will help me estimate the scope and delivery timeline accurately.
£70 GBP in 1 day
3.7
3.7

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
£99 GBP in 31 days
3.5
3.5

Biggleswade, United Kingdom
Member since Oct 23, 2026
₹400-750 INR / hour
$250-750 USD
₹750-1250 INR / hour
₹10000-15000 INR
$250-750 USD
£20-250 GBP
₹600-1500 INR
$30-250 USD
₹1500-12500 INR
$250-750 USD
$15-25 USD / hour
$30-250 CAD
₹400-750 INR / hour
$15-25 USD / hour
£750-1500 GBP
£20-250 GBP
₹12500-37500 INR
₹750-1250 INR / hour
₹12500-37500 INR
₹12500-37500 INR