
Closed
Posted
I need a complete Power Automate Desktop flow that pulls raw information from three different places—our internal SQL database, a couple of public-facing web pages, and several regularly updated Excel workbooks—then cleans and transforms everything into a uniform, ready-for-analysis format. The flow has to run unattended on a Windows 11 machine, trigger on a schedule I can adjust, and handle the usual hurdles such as login prompts, dynamic web tables, and occasional missing cells in the spreadsheets. When it finishes, the transformed data should be dropped into a new Excel file and, if possible, pushed to a designated SharePoint folder. Please build the solution directly in Power Automate Desktop and include any helper scripts, connection strings, or custom actions you create. Deliverables • PAD file with the complete extraction-to-transformation logic • An annotated screenshot or short screen-capture showing the flow in action • A brief setup document so I can change credentials, source locations, and schedule without breaking the automation I’ll test by running the flow against my live sources; acceptance is complete when the output file arrives cleaned, consolidated, and free of the duplicate and null values currently giving me headaches.
Project ID: 40594356
11 proposals
Remote project
Active 14 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
11 freelancers are bidding on average ₹1,357 INR/hour for this job

Hi, this is exactly the type of Power Automate Desktop solution I build. I’ve automated workflows that combine SQL Server, dynamic websites, Excel, and SharePoint, with unattended execution, robust error handling, data cleansing, deduplication, and scheduled runs. You’ll receive a fully documented PAD flow, helper scripts (if needed), and a setup guide for easy maintenance. I’d bid ₹2,500/hour, with an estimated 20–30 hours (4–6 days) depending on the web scraping complexity. Happy to get started right away.
₹2,500 INR in 40 days
5.9
5.9

Hello there, I can build a complete Power Automate Desktop solution to extract, transform, and consolidate data from SQL, web pages, and Excel into a clean, analysis-ready dataset. Approach * Connect to SQL, web sources, and Excel workbooks. * Clean, validate, remove duplicates, and transform the data. * Generate a consolidated Excel output and upload it to SharePoint. * Configure unattended execution with robust error handling, logging, and retry logic. * Deliver the PAD flow, setup documentation, and a walkthrough for future maintenance. I have experience with Power Automate Desktop, SQL Server, Excel automation, SharePoint, web automation, and data processing, and can deliver a reliable, production-ready solution. Best regards, Samira
₹1,800 INR in 40 days
4.8
4.8

Hi, I’ve reviewed your requirements and can build a reliable, unattended Power Automate Desktop solution to automate your complete data extraction and transformation process. With 11+ years of experience in Microsoft Power Platform, Power Automate Desktop, SQL, Excel, SharePoint, and workflow automation, I have developed end-to-end automation solutions that eliminate manual work and improve data accuracy. For this project, I will: * Build a Power Automate Desktop flow to extract data from SQL, web pages, and Excel files. * Clean, transform, merge, and remove duplicate/null records. * Generate a consolidated Excel output and upload it to your designated SharePoint folder. * Configure unattended execution with an adjustable schedule. * Provide the PAD flow, setup documentation, and a walkthrough video/screenshots for easy maintenance. A few quick questions: * Which SQL database are you using (SQL Server, MySQL, etc.)? * Do the web pages require authentication or MFA? * Approximately how many Excel files and records are processed in each run? I’m available to start immediately and can deliver a scalable, well-documented solution that is easy to maintain and extend. Looking forward to working with you. Best regards, Nidhi
₹1,500 INR in 40 days
5.2
5.2

Hi, I can build the complete Power Automate Desktop flow to extract data from SQL Server, public web pages, and Excel workbooks, then clean and consolidate it into a ready-for-analysis Excel output. I’ll first review your SQL connection, web page structure, workbook formats, cleaning rules, SharePoint folder, and scheduling needs. Then I’ll create an unattended Windows 11 PAD flow that handles login prompts, dynamic web tables, missing cells, duplicates, null values, and final file generation. I’m comfortable with Power Automate Desktop, SQL Server, Excel automation, web extraction, SharePoint upload, data cleaning, scheduled flows, and setup documentation. Deliverables will include: * Complete PAD flow * SQL, web, and Excel extraction * Data cleaning/transformation * Duplicate and null handling * Final Excel output * SharePoint upload if supported * Demo screenshot or short recording * Setup guide for credentials, paths, and schedule I’ll focus on a stable, easy-to-maintain automation that runs unattended and produces clean consolidated data. Best regards Ankit
₹1,000 INR in 40 days
3.4
3.4

I can build this as a single unattended PAD solution with SQL extraction, web scraping, Excel cleanup, and optional SharePoint output. Microsoft’s guidance confirms unattended desktop flows are run from cloud flows on a configured machine, and that video logs can be enabled for unattended runs. Bid: ₹3,000/hr. Timeline: 2–4 days for the flow, testing, and setup notes. One question: do your web sources require manual login or do they support a saved session/cookie-based access?
₹3,000 INR in 40 days
1.8
1.8

Hello, I have extensive experience building Power Automate Desktop solutions that integrate SQL databases, web portals, Excel, and SharePoint. I can develop an unattended PAD flow for Windows 11 that extracts data from your SQL database, public web pages, and Excel files, then cleans, validates, removes duplicates and null values, transforms the data into a consistent format, and generates a consolidated Excel report. The flow will support configurable scheduling, secure credential management, dynamic web handling, and SharePoint upload. I'll deliver the complete PAD file, helper scripts, setup documentation, and a demo video/screenshot. To begin, please confirm your SQL database type, sample queries, website URLs, and authentication requirements.
₹800 INR in 35 days
1.5
1.5

Dynamic web tables are the trickiest part here, especially when the HTML structure shifts between page loads. I'll build the PAD flow with CSS selector fallbacks so extraction doesn't silently fail when a column moves. I'll set up the three data connectors (SQL query, web scraping actions, Excel workbook reads), unify everything through a transformation step that handles nulls and deduplication, then output the cleaned file and push it to your SharePoint folder. The unattended trigger will use a Windows Task Scheduler hook so you can adjust the schedule without opening PAD each time. One thing worth noting: for login-protected web pages, PAD's browser automation stores credentials in the local session, so I'll include a secure credential variable setup in the documentation rather than hardcoding anything. Best regards, Shayan
₹925 INR in 40 days
0.0
0.0

Hello, I can build a reliable Power Automate Desktop solution that extracts data from your SQL Server database, dynamic public web pages, and regularly updated Excel workbooks, then cleans, standardizes, deduplicates, and consolidates the records into a ready-for-analysis Excel file. I have extensive experience in systems integration, SQL, Excel data processing, SharePoint, Python/PowerShell automation, REST APIs, and Microsoft cloud technologies. I will design the flow in modular stages so credentials, file paths, URLs, queries, output locations, and schedules can be changed without modifying the core logic. The solution will include: • Complete PAD extraction and transformation flow • Resilient handling of login prompts, changing web tables, missing cells, timeouts, and retries • Duplicate/null validation and execution logging • Scheduled unattended execution on Windows 11 • Excel output and SharePoint upload • Helper scripts, annotated screenshots or a short demonstration video • Clear setup and maintenance guide I will test each source independently before completing the consolidated end-to-end run. Could you share sample source files, the SQL schema/query, webpage URLs, expected output columns, login/MFA requirements, and SharePoint destination? Estimated delivery: 5–7 working days.
₹1,000 INR in 40 days
0.0
0.0

Your requirement for a Power Automate Desktop flow to consolidate data from various sources into a clean, ready-for-analysis format is clear. Managing different data formats and overcoming challenges like login prompts and dynamic content is crucial for seamless automation. To address this, I would develop a robust flow that efficiently extracts data from your SQL database, web pages, and Excel workbooks. The process will include data cleaning and transformation to ensure uniformity. I’ll ensure it runs unattended on your Windows 11 machine, with adjustable scheduling and proper error handling. I have successfully built similar automation solutions that involved complex data integrations and transformations. My approach will guarantee that the output is clean and meets your criteria for acceptance. What specific scheduling needs do you have for this flow? --- **Why this approach:** - Directly addresses your need for data consolidation and transformation. - Focuses on automation challenges, ensuring reliability. - Encourages dialogue about scheduling, showing willingness to customize.
₹750 INR in 7 days
0.0
0.0

Chennai, India
Member since Jul 20, 2026
₹12500-37500 INR
₹600-1500 INR
$30-250 USD
₹750-1250 INR / hour
$15-25 USD / hour
₹12500-37500 INR
₹100-1500 INR / hour
₹2000-3000 INR
$15-25 USD / hour
$10-30 AUD
€250-750 EUR
₹100-400 INR / hour
€12-18 EUR / hour
₹100-400 INR / hour
$2-8 USD / hour
₹750-1250 INR / hour
₹600-1500 INR
₹75000-150000 INR
$2-8 USD / hour
₹600-1500 INR