
Open
Posted
•
Ends in 2 hours
Paid on delivery
I already have Microsoft Dynamics 365 Field Service creating Work Orders and, at the moment a Work Order is created, a Power Automate flow fires off an email and a Twilio SMS/MMS to the customer. The challenge is that the same instance also dispatches for multiple franchisees, each with its own name style, street address, local phone number and logo. I want the flow to look at the customer’s assigned Business Unit or Territory and automatically merge the correct franchise data into every message. See attached Franchise-Aware Customer Email, SMS and [login to view URL] for details and instructions but not limited. What the message must hold every time it goes out: • Customer details • Franchisee details (name style, address, local phone number) • Work Order details • The franchisee logo embedded as an SVG • Any extra fields described in the attached Developer Implementation Specifications Scope of the work 1. Extend or rebuild the existing “When a Work Order is Created” trigger flow so it fetches the related Business Unit or Territory, pulls the matching franchise record and injects the right variables into both the email body and the Twilio SMS/MMS payload. 2. Create or update reusable HTML/JSON templates so the message layout is clean and the SVG logo renders correctly across common mail clients and phones. 3. Add environment-safe variables or a configuration table in Dataverse so new franchisees can be added without editing the flow again. 4. Document every step clearly so I (or another admin) can maintain it later, including screenshots of key settings, expression formulas and the Twilio connector configuration. Acceptance criteria • A single test Work Order for Franchisee A sends an email and SMS that display the correct address, local phone and SVG logo for Franchisee A. • Repeating the test for Franchisee B swaps in Franchisee B’s branding with no manual edits to the flow. • The flow runs only on create; updates to the Work Order do not retrigger it unless we explicitly switch that on later. • All configuration is stored centrally so adding a franchisee requires data entry only, not flow edits. If you have solid experience with Dynamics 365 Field Service, Dataverse tables and the Twilio connector inside Power Automate, this should be a straightforward build. Let me know how you would structure the configuration table and any best-practice tips you plan to apply.
Project ID: 40679187
164 proposals
Open for bidding
Remote project
Active 3 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
164 freelancers are bidding on average $462 USD for this job

Your current flow is doing the trigger part correctly, but the weak point is that branding and sender context are being treated as static when they really need to be franchise-aware. I’d handle this by keeping the Work Order create trigger as the only entry point, then resolving Business Unit/Territory to a Dataverse configuration record and feeding those values into both the email template and Twilio payload so no one has to edit the flow each time a franchise is added. I’ve worked on Dynamics/Dataverse automations where the real challenge was not sending the notification itself, but making the logic maintainable after handoff. For this kind of setup, the best result usually comes from a central franchise config table, reusable template variables, and careful trigger conditions so updates do not fire unless you intentionally enable that later. A small admin guide with screenshots and expressions would be included so another admin can maintain it cleanly. - Is Business Unit or Territory the more reliable source in your current data model for determining franchise ownership? - Are the franchise logos already stored in Dataverse/notes/web links, or do they still need a consistent storage approach for the SVGs? - Is your existing Twilio step using the native connector or an HTTP/custom connection?
$261 USD in 7 days
9.6
9.6

Hello, I understand that you are looking to enhance your Dynamics 365 Field Service setup by automating the inclusion of specific franchisee details in customer notifications. This requires a seamless integration of Business Unit/Territory data to personalize emails and SMS/MMS messages with franchise-specific information. To address this, I would focus on extending the existing trigger flow to dynamically fetch and merge franchisee data based on the customer's assigned Business Unit/Territory. By updating templates and incorporating environment-safe variables in Dataverse, new franchisees can be effortlessly added without disrupting the flow. My expertise in Dynamics 365 Field Service, Dataverse tables, and Twilio connector in Power Automate positions me well to deliver a solution that meets your requirements efficiently. I plan to structure the configuration table logically and implement best practices to ensure scalability and ease of maintenance. I invite you to initiate a chat to discuss the technical approach further and share insights on how we can streamline the process effectively. Sincerely, Rajesh
$500 USD in 10 days
8.0
8.0

Hi there, I can update your Dynamics 365 Field Service and Power Automate workflow to automatically identify the correct Business Unit/Territory and load the matching franchise configuration from Dataverse. I’ll structure a centralized franchise table for branding, contact details, address and SVG logo, then use reusable HTML/JSON templates to inject the correct data into both email and Twilio SMS/MMS without requiring flow changes when new franchisees are added. I’ll also ensure the flow triggers only on Work Order creation, test multiple franchisees end-to-end, and provide clear documentation with screenshots, formulas, and connector settings for future maintenance. Do you already have the franchise records and their Business Unit/Territory relationships configured in Dataverse? Kindly send me a message to discuss more in detail. Thanks.
$350 USD in 6 days
8.0
8.0

The main issue here is not the notification trigger itself, it is making one shared Dynamics 365 instance send the right local identity every time a Work Order is created. I would rebuild the lookup layer around the existing flow so it pulls the franchise mapping from Dataverse, inserts the proper address/phone/logo dynamically, and keeps all brand-specific settings in one maintainable place. I’ve handled Power Automate jobs where Twilio messaging, Dataverse records, and conditional template data all had to stay stable across multiple business units. In cases like this, I normally avoid hardcoded branches and instead use a dedicated configuration table plus reusable compose/template actions, which makes future franchise additions much safer. I can also document the formulas, connector settings, and table structure clearly for your admin handoff. - Do you want the franchise mapping keyed only by Business Unit/Territory, or should there be a fallback rule if one of those fields is blank? - For the email side, are you sending through Outlook/Dataverse email, and do you already have an HTML template started? - Should MMS include the logo as a separate media item when needed, or only inside the email layout?
$250 USD in 7 days
7.8
7.8

Hi, I will create a Dataverse configuration table to store franchisee branding, then update your Power Automate flow to dynamically inject these variables into your templates. This ensures clean, automated multi-brand communication without ongoing maintenance. Let’s discuss and get started! -AJ
$500 USD in 7 days
7.5
7.5

Hello!, I am a US-based senior software engineer and I’d love to help with your Dynamics 365 Franchise Notifications project. It sounds like the main issue is getting your Work Order creation flow to trigger the right notification, every time, without brittle fixes or manual follow-up. I can help make that automation reliable, clear, and easy to maintain. My approach: 1. Review the current Work Order trigger in Dynamics 365 Field Service 2. Build the notification logic in Power Automate / workflow 3. Integrate Twilio or the needed delivery channel 4. Test payloads, formatting, and edge cases before go-live I’m very detail-focused with Dynamics, JSON mapping, and workflow conditions, which is usually where these projects succeed or fail. Relevant work examples: - Fleet service alert automation for a regional logistics platform - CRM-to-SMS workflow for a home services company - Power Automate approval and dispatch system for a field operations team Could you please clarify the following questions to help me better understand the project? 1. What exact Work Order event should trigger the notification? 2. Is Twilio SMS the only channel, or do you want email too? 3. Are there specific fields or franchise rules that must be included? If you want someone who’ll treat this carefully and build it right the first time, I’d be glad to chat. James Zappi
$525 USD in 2 days
7.0
7.0

Because one Field Service environment is serving multiple franchisees, the real risk is ending up with hardcoded branding logic that works today but becomes messy the moment Franchisee C or D is added. I’d structure this so the flow checks the Work Order’s related Business Unit or Territory, fetches the matching franchise record from Dataverse, and then uses that dataset across both the customer email and Twilio SMS/MMS steps. This is the kind of automation that looks simple on the surface but benefits from clean architecture: central config, reusable variables, controlled trigger behavior, and template handling that does not break when branding changes. I’ve done similar platform-specific automation work where maintainability after delivery mattered just as much as getting the first test to pass. I’d also leave you with a practical maintenance document rather than just a finished flow. - Do you already have a franchise entity/table in Dataverse, or would you like that created fresh for this purpose? - Are there any per-franchise message differences beyond contact info and logo, such as wording, signatures, or reply numbers? - Would you like the flow to log which franchise config was used on each send for easier troubleshooting later?
$250 USD in 7 days
7.2
7.2

Hi there, The key here is making the notification flow franchise aware without creating franchise specific branches. I would structure the Dataverse configuration so Power Automate resolves the Business Unit/Territory → Franchise record → branding/contact variables dynamically for every new Work Order. My approach: • Extend the existing create only Work Order flow • Use Dataverse as the central franchise configuration source • Dynamically populate customer, Work Order and franchise details • Build reusable HTML/JSON templates for email and Twilio SMS/MMS • Handle SVG branding carefully across email clients and mobile devices • Keep the flow reusable so adding Franchise C requires data entry, not flow changes • Document expressions, configuration, connector settings and maintenance steps I would also ensure Work Order updates cannot accidentally retrigger the notification flow. One thing I would confirm first: is the franchise relationship currently stored directly against the Work Order/customer through Business Unit, Territory, or another Dataverse relationship? That determines the cleanest lookup architecture. Please ping to get started and get outstanding results. Thanks!!!
$550 USD in 7 days
7.4
7.4

Hello There! I’m an experienced Microsoft Power Platform developer specializing in Power Automate, Dynamics 365 Field Service, Dataverse, API integrations, and Twilio messaging workflows. I understand you need to enhance the existing Work Order creation flow so it identifies the assigned Business Unit/Territory, retrieves the correct franchise configuration, and dynamically applies its branding and contact details across email, SMS, and MMS without future flow edits. I’m skilled in Power Automate, Dataverse configuration tables, Dynamics 365, reusable HTML/JSON templates, Twilio integrations, conditional logic, expressions, and environment-safe configuration. I can structure the solution so each franchise is maintained centrally with fields for name, address, phone, SVG logo, and other required messaging data. A few questions: 1) Is the franchise relationship currently stored on Business Unit, Territory, or both? 2) Is the franchise data already available in Dataverse, or should I create the configuration table? 3) Can you provide the attached Developer Implementation Specifications PDF and existing flow for review? I’m ready to work within your existing architecture and deliver a clean, maintainable franchise-aware solution. Best regards, Md Toriqul Islam
$250 USD in 5 days
6.5
6.5

Hello, Dynamics 365 Franchise Notifications {{{ I HAVE CREATED SIMILAR BEFORE AND I CAN SHOW YOU }}} I have carefully reviewed your Dynamics 365 Field Service, Dataverse, Power Automate, and Twilio requirements and understand that the main goal is to make the existing Work Order notification workflow franchise-aware, reliable, and fully traceable. I have 11+ years of software and automation development experience and have worked with similar business automation and notification workflows before. I can show you relevant previous work so you can see my experience with this type of implementation. I can extend or rebuild the existing Power Automate flow to resolve the correct Franchise Communication Profile based on the Service Territory, with the required override and fallback logic. I will make sure the correct franchise name, address, local phone, email identity, SMS branding, and logo are automatically used for each customer notification. I will also create the required Dataverse configuration structure so new franchisees can be added through configuration without modifying the flow. The Twilio integration will support both SMS and MMS, including the public HTTPS logo URL where required, along with consent and phone validation. Thanks, Christina
$450 USD in 7 days
6.6
6.6

I'd start by turning the Business Unit/Territory lookup into a Dataverse table instead of adding another condition branch to the flow, since that's the only version of this that survives a fifth franchise being added without someone opening the flow editor again. The build sits on top of the existing Work-Order-Created trigger. I add a Franchise config table (Business Unit/Territory as the key, plus name, address, phone, and the SVG logo as a file or image column), extend the flow with a lookup step keyed off the work order's Business Unit, and merge the returned fields into the email template and the Twilio SMS/MMS step, logo included on the MMS side. Territories that don't resolve to a row fall back to a default record rather than failing the run silently. First milestone gets the table shaped, populated with your current franchises, and the lookup wired into the flow so it's pulling real data end to end, before I touch the notification templates themselves. That's the part worth confirming before I style anything. M1: Franchise config table + Business Unit/Territory lookup wired into the flow, $215, 2 days. M2: Merge franchise name, address, and phone into the email and SMS/MMS templates, $215, 2 days. M3: SVG logo handling on MMS, fallback record for unmatched territories, and testing across a couple of business units, $220, 1 day.
$650 USD in 5 days
6.4
6.4

With over a decade of experience in web development, especially in HTML, I believe I am an ideal fit for your project that involves building and extending Power Automate flows using Dynamics 365 Field Service and Twilio connectors. My expertise covers a wide range of technologies including JavaScript, PHP, Ordo CRM and many more, which are crucial for smooth functioning of your work order creation, dispatching and notification automations. Of particular importance is my ability to create clean and efficient HTML/JSON templates- an area critical to achieving a consistent branding experience using SVG logos across multiple platforms. Additionally, I can suggest an environment-safe configuration structure using Dataverse tables that will facilitate easy onboarding of new franchiees without frequent edits. All these stem from my deep understanding and highly honed skills in utilizing various Microsoft applications like Dynamics 365 Field Service. I am eager to start working on this project and look forward to exceeding your expectations.
$250 USD in 5 days
6.9
6.9

I have experience with Dynamics 365, Dataverse, Power Automate, and Twilio integrations, including dynamic workflows and reusable notification templates. I can build a centralized franchise configuration that automatically selects the correct branding, contact details, Work Order data, and SVG logo for each franchise without requiring flow changes. I’ll also ensure the trigger runs only on creation and provide clear documentation for future maintenance. Please start the inbox so we can discuss your existing flow and configuration.
$300 USD in 7 days
6.4
6.4

Your spec's Franchise Communication Profile table keyed to Service Territory is exactly how I'd structure the config. Two details matter most: Profile Code as an alternate key so integrations stay stable, and treating two active profiles on one territory or BU default as a hard configuration error, never a "pick the first row" fallback. I'd snapshot the resolved profile onto the Work Order at creation, so reassigning a customer later never rebrands an open job. One thing to flag from your requirements: Twilio MMS only fetches PNG/JPEG and Outlook strips SVG, so each profile would store the SVG for email plus a PNG fallback URL, chosen per channel. The create-only rule gets a trigger condition plus a notification fingerprint, so Dataverse updates and retries can't double-message a customer. First milestone: the config table, resolve flow and your Franchisee A/B acceptance test passing in a test environment within 7 days, released only when both swap branding with zero flow edits, documentation and screenshots included. Do you already have public HTTPS hosting for the logos, or should I set that up too, since authenticated Dataverse files won't work as Twilio MediaUrl?
$500 USD in 7 days
5.8
5.8

With my extensive experience in developing SaaS platforms, ERP systems, and CRM solutions, I am confident that I can deliver a comprehensive solution to your Dynamics 365 franchise notification challenge. I've built robust Business Process Automation systems using Dynamics 365 Field Service and Power Automate, integrating various APIs to create efficient workflows - a skillset that aligns perfectly with your project requirements. Moreover, I have hands-on expertise with Dataverse tables and the Twilio connector to ensure seamless communication between your system and the end-users. One of the strengths defining my work is keen attention to detail in every aspect. Whether it's creating or updating HTML/JSON templates for clean message layouts that render flawlessly across email clients and phones or designing a configuration table for environment-safe variable management, you can be assured of a meticulous approach at every step. The final outcome will be an easily maintainable system that will keep propagating correct customer, franchisee, and work order information automatically, without requiring any manual intervention even when adding new franchisees. II look forward to discussing the project specifics further with you.
$350 USD in 10 days
5.9
5.9

Hello there, I can help extend your existing Dynamics 365 Field Service flow to make the customer communications franchise-aware. My approach: 1. Update the Work Order creation flow to identify the related Business Unit/Territory and retrieve the correct franchise configuration. 2. Maintain franchise details centrally in Dataverse, including name, address, phone, logo and messaging settings, so new franchisees can be added without changing the flow. 3. Build reusable email, SMS and MMS templates using dynamic Work Order, customer and franchise data. 4. Handle the franchise SVG logo and ensure the email/MMS output renders correctly. 5. Configure the Twilio payload for the correct franchise branding and customer information. 6. Add proper error handling and logging so missing mappings, files or configuration are easy to identify. 7. Test with multiple franchisees to confirm the same flow automatically selects the correct branding and details. 8. Provide clear documentation covering the Dataverse configuration, flow logic, expressions and Twilio setup. I have hands-on experience with Dynamics 365, Dataverse and Power Automate integrations and can work with your existing flow rather than unnecessarily rebuilding the solution. I’d be happy to review the current flow and specification and get started. Best regards, Samira
$500 USD in 7 days
5.6
5.6

Hey! I specialize in Power Automate and Dynamics 365 automation with 9+ years building Dataverse workflows, Twilio integrations, and scalable business processes. Here’s how I can help: • Extend the Work Order flow with franchise-aware data mapping • Build reusable HTML/JSON templates with embedded SVG branding • Configure centralized Dataverse settings for scalable franchise management • Document formulas, connectors, configurations, and maintenance steps clearly Could you clarify whether Business Unit or Territory should be the primary franchise lookup, with the other used as a fallback?
$500 USD in 7 days
5.4
5.4

Hi, I'm Denis, and I've built similar Dynamics 365 automation flows where branding consistency across franchisees was critical. Your current setup is close, but the key gap is dynamic franchise data injection without hardcoding. The cleanest approach is to store franchise configurations in a dedicated Dataverse table linked to Business Units, then pull the matching record when the Work Order triggers. This keeps the flow lean while making onboarding new franchisees as simple as creating a new row. I'd structure the configuration table with franchise name style, address, local number, and SVG logo path, then use Power Automate's "List rows" action to fetch the correct record. For the templates, a reusable HTML/JSON structure with embedded SVG (base64-encoded for email safety) ensures consistent rendering across clients. The Twilio connector payload can reference these dynamic values directly. The main risk is data quality—ensure Business Units or Territories are properly mapped to franchise records. A simple check like "if no franchise found, log error and skip" prevents silent failures. I can start working right away. Let's connect and discuss the details. Thanks, Denis.
$400 USD in 5 days
5.5
5.5

Hi, there. - Truong here. "FRANCHISE-AWARE POWER AUTOMATE NOTIFICATIONS" — one Work Order must automatically use the correct franchise branding and contact details. I’d use a Dataverse franchise configuration table keyed to Business Unit/Territory, so the flow looks up the correct name, phone, address, and SVG once and uses the same data for email and Twilio. I’d keep the trigger strictly on create and document the expressions so adding a franchise needs data entry, not flow changes. How is the franchise currently linked to each Work Order: Business Unit, Territory, or both? Thank you
$250 USD in 2 days
5.4
5.4

I’ve built and maintained franchise-branded notification flows in Dynamics 365 Field Service before, so this is right in my wheelhouse. I’ll extend the existing “When a Work Order is Created” trigger to query the Business Unit or Territory, join the franchise lookup, and inject the correct franchise data into both email and Twilio payloads. The HTML/SVG templates will use inline styles and Litmus-approved structure to render cleanly across clients and devices. A dedicated Dataverse table will store franchise logos as SVG blobs, addresses, and phone numbers with environment-safe variables for tenant overrides. The Twilio connector will be configured for MMS with fallback handling for SVG rendering gaps. I’ll lock the flow to “on create” and deliver a concise maintenance guide with key expressions and connector screenshots. Thanks, Andrii.
$300 USD in 6 days
5.2
5.2

Houston, Canada
Payment method verified
Member since Feb 24, 2003
$2-8 USD / hour
$100-500 USD
$50 USD
$250-750 USD
$250-750 USD
£5000-10000 GBP
$250-750 USD
₹12500-37500 INR
$750-1500 CAD
€250-750 EUR
$25-50 USD / hour
$10-30 AUD
₹12500-37500 INR
€30-250 EUR
₹600-1500 INR
$5-20 USD / hour
₹600-1500 INR
₹12500-37500 INR
$750-1500 USD
$15-25 AUD / hour
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
₹12500-37500 INR
₹1500-12500 INR