
Closed
Posted
Paid on delivery
OVERVIEW ─────────────────────────────────────── We are looking for a Power Automate specialist to finalize and validate an automated daily email flow for client payment follow-up. The flow is already 80% built and functional. We need someone to debug the remaining issues, test end-to-end, and hand it over ready for production. ─────────────────────────────────────── BACKGROUND ─────────────────────────────────────── The flow automatically sends daily reminder emails to clients with overdue invoices. It distinguishes between two levels of urgency based on the number of days overdue, using an Excel file hosted on SharePoint as the data source. ─────────────────────────────────────── FLOW ARCHITECTURE (already built) ─────────────────────────────────────── 1. Scheduled Trigger — runs automatically every day at a defined time. 2. List rows present in a table — reads the "Recouvrement" table from the Excel file (SharePoint), which contains all clients with their outstanding amounts, late payment interest, and follow-up status. 3. Filter array — in-memory filter to retain only clients flagged for follow-up ("Activ relance = Oui"), avoiding unnecessary processing of all 33 clients when only a few require action. 4. Initialize variable / Initialize variable 1 — initializes two empty string variables (CorpsMail and ObjetMail) that will hold the personalized email content for each client. 5. Apply to each — loop that processes each filtered client one by one. Inside the loop: • Condition — checks whether the client requires a formal "Mise en demeure" (overdue > 120 days) or a standard "Rappel" reminder (overdue 30–90 days). • True branch (Mise en demeure / Formal Notice): - Get a row 2 — retrieves full client data (amount, interest, total due, invoice number) from the Recouvrement tab - Get a row — retrieves the "Mise en demeure" email template from the Modèle tab - Set variable — builds the email body by replacing placeholders {{NOM_CLIENT}}, {{MONTANT_TTC}}, {{MONTANT_INTERET}}, {{MONTANT_TOTAL_DU}}, {{NUMERO_FACTURE}} with the client's actual data • False branch (Rappel / Standard Reminder): - Get a row 3 — retrieves client data from the Recouvrement tab - Get a row 1 — retrieves the "Rappel" email template from the Modèle tab - Set variable 1 — builds the email body with placeholders {{NOM_CLIENT}}, {{MONTANT_TTC}}, {{NUMERO_FACTURE}} 6. Send an email (V2) — sends the email via Outlook to the address stored in the client's "Email recouvrement" field, with the personalized subject and body. ─────────────────────────────────────── TECH STACK ─────────────────────────────────────── • Power Automate (Microsoft 365) • Excel Online (SharePoint) as the data source • Outlook as the sending channel • Standard connectors only — no premium licence required ─────────────────────────────────────── SCOPE OF WORK FOR THE FREELANCER ─────────────────────────────────────── The following tasks remain to be completed: 1. Fix and validate the loop JSON — the flow currently fails to save correctly in the visual editor ("cannot read in real edit editor" error). The JSON needs to be reviewed, corrected, and confirmed error-free. 2. End-to-end test — trigger the flow manually on a real client, verify that the correct email template is selected (Rappel vs. Mise en demeure), and confirm that all placeholders are properly replaced with live data. 3. Remove the test constraint — the loop is currently limited to 1 iteration (Degree of parallelism = 1). This must be removed before go-live. 4. Activate the daily schedule — configure and enable the scheduled trigger for automatic daily execution. ─────────────────────────────────────── DELIVERABLES ─────────────────────────────────────── • Fully functional and saved Power Automate flow • Successful test run with confirmed email delivery • Flow active and running on daily schedule • Brief handover notes (what was fixed and how) ─────────────────────────────────────── CONTEXT & ACCESS ─────────────────────────────────────── • The Excel file is hosted on SharePoint (Microsoft 365 tenant) • All connector credentials are already configured • The existing flow JSON will be shared upon engagement • Estimated effort: 2–4 hours for an experienced Power Automate developer
Project ID: 40552445
16 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average €48 EUR for this job

Hi, The core outcome here is getting your Power Automate flow stable again so overdue invoices trigger the correct Rappel vs Mise en demeure emails without breaking in the editor or runtime. I’ve worked on similar M365 + Excel/SharePoint automations, and I’ll start by fixing the broken Apply to each structure causing the “cannot read in real edit editor” issue, then validate the expressions used for the Recouvrement table and template lookups. After that I’ll run an end-to-end test with one client to confirm placeholder replacement, and finally remove the Degree of parallelism = 1 constraint and enable the daily schedule safely. Main risk is mismatched dynamic fields between Excel rows and email template variables — I’ll normalize those mappings so the switch logic stays consistent. Can you share the current flow export/JSON so I can inspect the failing loop directly? Thanks!
€19 EUR in 7 days
3.9
3.9

The tricky part with expiry reminder flows in Power Automate is getting the timing conditions right so reminders fire at the correct intervals without duplicates or spam. I would build a scheduled flow in Microsoft 365, filter records by expiry date, and wire up the email stages cleanly. Can start today and have it running within 2 days. The bid reflects the post as written. Final numbers depend on your data source and how many reminder stages you need. Want to jump on a quick call?
€30 EUR in 3 days
3.7
3.7

Hello, I can build your Power Automate expiry reminder email flow to automatically track expiry dates and send timely email notifications. I have experience in Microsoft Power Automate, workflow automation, and email-based alert systems. I will ensure accurate scheduling, reliable triggers, and smooth automation with proper testing. Ready to start immediately. Regards, Acute Tech Solutions
€19 EUR in 7 days
0.0
0.0

A Power Automate flow can be 80% complete and still fail at the most important point: reliably running without manual intervention when real client data enters the process. The priority here is not rebuilding the automation, but making sure the existing logic is stable from trigger to delivery. The loop structure, JSON configuration, template selection, placeholder replacement, and Outlook sending process all need to work together as one dependable workflow. I would approach this by reviewing the current flow structure, correcting the save/editor issues, testing both reminder paths with live data, removing the temporary limitations, and ensuring the daily schedule is production-ready with clear handover notes. Is the existing flow JSON already available, and are there any specific errors appearing in the run history besides the visual editor save issue??
€19 EUR in 7 days
0.0
0.0

As a digital marketer with a proven track record in email marketing, I bring unparalleled depth and breadth of knowledge to your Power Automate project. Having successfully managed numerous email campaigns and automated customer journeys across different industries, I am no stranger to Power Automate's capabilities. Strengthening that point, my technical competence extends seamlessly to SharePoint and Outlook which are vital components of this pain-point you are experiencing. One of the remarkable skills I possess, which aligns perfectly with your specific requirement, is my keen eye for detail. This quality will enable a meticulous debug of existing issues, ensuring there are no stone left unturned within the flow before forwarding it over to production. On implementation, one thing you can be sure of is a smooth process void of glitches and with maximum efficiency. Once enlisted for task of fixing loop JSON, end-to-end testing, removing test constraints and more I am dedicated to provide 100% satisfactory result on each rudiment no matter how minute they might seem. Place your trust in me for the delivery of fully functional and saved Power Automate flow timely without compromising quality and productivity. Let's move this project to production together with ease!
€250 EUR in 7 days
0.0
0.0

Bonjour, I understand your looking to have your powerautomate workflow completed and commissioned live. This is someting I can do for you and I can start straight away. I have helped lots of clinets with all types of Workflows and I would love the opportunity to use my knowledge and experience to help you out with getting this up and running. If you have any queries or questions then please get in touch. Cheers for now, Robert
€50 EUR in 7 days
0.0
0.0

I've got solid experience shipping Power Automate flows in production environments. I'll start by reviewing the flow JSON you share, fix the visual editor errors, then run a full end-to-end test with both email templates (Rappel and Mise en demeure) to confirm placeholder replacement and correct routing logic. I'll remove the parallelism constraint, activate the daily schedule, and deliver a clean, documented flow ready to go live. Expect handover notes covering what was fixed and validation screenshots showing successful test runs.
€8 EUR in 2 days
0.0
0.0

I can help you finalize this Power Automate flow. I'll fix the JSON error, test the flow end-to-end to make sure the right email template is sent with correct placeholders, remove the parallelism limit, and activate the daily schedule. I've worked with Power Automate, SharePoint Excel, and Outlook connectors before, so this should be straightforward. Estimated time: 2–3 hours. Ready to start right away. Please share the flow JSON and I'll get it done
€20 EUR in 1 day
0.0
0.0

AFTER READING THROUGH YOUR PROJECT, I SEE WHAT YOU'RE LOOKING FOR. You need a Power Automate specialist to finalize and validate an automated daily email flow for client payment follow-up. The flow is already 80% built and functional, with the remaining tasks being debugging, testing, and preparing it for production. I have experience working on similar automated email flows and challenges. I am genuinely interested in ensuring your payment reminder system runs smoothly and effectively. What you truly desire is not just an automated email flow, but a reliable system that efficiently sends personalized reminders to clients with overdue invoices. I would approach this by meticulously fixing the remaining issues, conducting thorough testing, and ensuring seamless daily execution. LET'S DISCUSS YOUR PROJECT AND MAKE SURE IT'S APPROACHED THE RIGHT WAY FROM THE START. Kind Regards, Ethan
€12 EUR in 8 days
0.0
0.0

Brussels, France
Member since Jul 1, 2026
₹750-1250 INR / hour
£2-5 GBP / hour
₹12500-37500 INR
$1500-3000 USD
€12-18 EUR / hour
$250-750 USD
£10000-20000 GBP
£250-750 GBP
$15-25 USD / hour
£20-250 GBP
₹750-1250 INR / hour
₹12500-37500 INR
€8-30 EUR
₹750-1250 INR / hour
₹600-1500 INR
$750-1500 USD
$8-15 USD / hour
₹750-1250 INR / hour
$15-25 USD / hour
$250-750 CAD