CRM migration

Migrate from Powered Now to Microsoft Dynamics 365 Sales

Field-level mapping, validation, and rollback between Powered Now and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .

Powered Now logo

Powered Now

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

100%

12 of 12

objects map 1:1 between Powered Now and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

48–72 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Powered Now is job management software built for UK trade businesses — plumbers, electricians, gas engineers — handling quoting, invoicing, scheduling, certificates, and team management with Making Tax Digital compliance baked in. Microsoft Dynamics 365 Sales is a CRM platform organised around Account, Contact, Lead, and Opportunity entities, with native integration to Microsoft 365, Power Platform, and Dataverse. The migration carries Powered Now's client records, job histories, quotes, invoices, and custom fields into Dynamics 365 Sales' relational model. The harder translation problems are converting Powered Now's job-pipeline structure into Dynamics 365 Sales Opportunity stages, preserving multi-line invoice data in the Quote/Order model, mapping UK-specific tax fields (VAT rate, Making Tax Digital flags) to Dynamics 365 Sales financial fields, and rebuilding any Powered Now workflow automation in Power Automate post-migration. We use the Dynamics 365 Sales Web API and Dataverse endpoints to load data, with bulk-create for high-volume record sets and field-level diff validation before commit.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Powered Now logo

Powered Now

What's pushing teams away

  • Lack of a public API blocks integration with third-party tools and makes data portability difficult, forcing businesses to manually export records when switching platforms.
  • Pricing is per-user and can become expensive as a team grows, pushing smaller operators toward lower-cost alternatives with flat-rate pricing.
  • Advanced features such as Xero integration, time tracking, and custom reporting are gated behind higher tiers, creating upgrade pressure on businesses that only need one or two premium features.
  • The platform is UK-only in its compliance features, making it unsuitable for trade businesses operating in Ireland, the Isle of Man, or other UK-aligned jurisdictions with different MTD rules.

Choosing

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

What's pulling them in

  • Deep Microsoft 365, Teams, and Outlook integration makes Microsoft Dynamics 365 Sales a natural fit for Microsoft-first organizations already invested in that ecosystem
  • Sales Enterprise and Premium tiers offer unlimited custom tables and advanced AI-driven forecasting and predictive analytics not available in lower tiers
  • Professional tier pricing at $65 per user per month offers a lower entry cost than Salesforce for SMB teams with straightforward CRM needs
  • Flexible customization options allow businesses to build bespoke apps, tailor forms and views, and integrate with other Dynamics 365 modules
  • Microsoft Copilot AI tools are embedded directly into the sales workflow on Enterprise and Premium, automating routine tasks and providing deal intelligence

Object mapping

How Powered Now objects map to Microsoft Dynamics 365 Sales

Each row shows how a Powered Now object lands in Microsoft Dynamics 365 Sales , including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Powered Now

Client

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

Powered Now clients with company names map directly to Dynamics 365 Sales Account.Name. Sole-trader clients with personal names map to Account.Name with Contact created as the primary Contact record. Primary address and postcode map to Account.Address fields.

Powered Now

Client

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

Client contact details — name, email, phone — map to Dynamics 365 Sales Contact.FirstName, Contact.LastName, Contact.Email, Contact.Phone. Multiple contacts per client create multiple Contact records linked by AccountId lookup.

Powered Now

Job

maps to

Microsoft Dynamics 365 Sales

Opportunity

1:1
Fully supported

Powered Now jobs translate to Dynamics 365 Sales Opportunity records. Job name becomes Opportunity.Name. Job status (Quoted, In Progress, Complete, Invoiced) maps to Opportunity StageName pick-list values. Job value maps to Opportunity.Amount. Close date is derived from job completion date.

Powered Now

Quote

maps to

Microsoft Dynamics 365 Sales

Quote

1:1
Fully supported

Powered Now quotes map 1:1 to Dynamics 365 Sales Quote entities. Quote number becomes Quote.Name. Line items (labour, parts, call-out fee) map to Quote Product records with Quantity, UnitPrice, and manual VAT calculations.

Powered Now

Invoice

maps to

Microsoft Dynamics 365 Sales

Invoice

1:1
Fully supported

Powered Now invoices map to Dynamics 365 Sales Invoice records. Invoice number becomes Invoice.Name. Line items map to Invoice Product records. VAT amount and Making Tax Digital status are preserved as custom columns on the Invoice.

Powered Now

Purchase Order

maps to

Microsoft Dynamics 365 Sales

Purchase Order (Custom Entity)

1:1
Fully supported

Dynamics 365 Sales has no native Purchase Order object in the base CRM schema. Supplier purchase orders migrate as a custom Dataverse table with PO number, supplier link, line items, and status — created as part of the migration schema setup.

Powered Now

Diary Entry / Job Assignment

maps to

Microsoft Dynamics 365 Sales

Task + Custom Fields

1:1
Fully supported

Powered Now diary entries with engineer assignments translate to Dynamics 365 Sales Task records with Subject, ScheduledStart, and OwnerId resolved by engineer email. Job-site postcode and What3Words reference preserved as custom text fields.

Powered Now

Supplier Invoice

maps to

Microsoft Dynamics 365 Sales

Invoice (Vendor) / Custom Entity

1:1
Fully supported

Supplier invoices from Powered Now have no direct Dynamics 365 Sales equivalent. We create a vendor-invoice custom entity mapping supplier name, invoice number, amount, date, and status — accessible for reconciliation reporting in Power BI post-migration.

Powered Now

Certificate (Gas / Electrical)

maps to

Microsoft Dynamics 365 Sales

Note (Annotation) + Custom Entity

1:1
Fully supported

Powered Now certificates for gas safety and electrical work cannot be generated by Dynamics 365 Sales. We migrate certificate records as Note attachments on the associated Job/Opportunity, with certificate type, expiry date, and engineer name preserved as custom fields for compliance tracking.

Powered Now

Custom Field (Client)

maps to

Microsoft Dynamics 365 Sales

Account Custom Column

1:1
Fully supported

Powered Now custom fields on clients (e.g., trade classification, account tier, credit limit) migrate as custom columns on the Account table in Dataverse, using the new_ prefix naming convention. Field type constraints applied per Dynamics 365 Sales data model.

Powered Now

Custom Field (Job)

maps to

Microsoft Dynamics 365 Sales

Opportunity Custom Column

1:1
Fully supported

Powered Now custom fields on jobs (e.g., job type, priority flag, site-access notes) migrate as custom columns on the Opportunity table. Text, number, date, and pick-list types are supported; pick-list values require value-mapping setup in the migration plan.

Powered Now

Engineer / Team Member

maps to

Microsoft Dynamics 365 Sales

System User

1:1
Fully supported

Powered Now team members are resolved by email match to existing Dynamics 365 Sales users. If no match exists, the team member is flagged as an unassigned owner — your admin either creates a Dynamics user or assigns records to a fallback owner before migration runs.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

Powered Now logo

Powered Now gotchas

High

No public REST API means migration requires reverse-engineered data access

Medium

Certificate expiry dates require manual re-validation post-migration

Medium

Making Tax Digital data is tied to the Powered Now MTD-compliant invoice format

Low

Attachment blobs export as raw files without a relational manifest

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales gotchas

High

Professional tier 15-table custom table limit blocks migrations

High

October 2024 pricing increase applies at renewal for all customers

Medium

Custom fields must be created in the UI before API writes

Medium

Power Platform request limits apply to bulk migrations

Medium

Activity records orphaned to inactive owners fail silently

Pair-specific challenges

  • Job-to-Opportunity stage mapping requires a manual status translation

    Powered Now tracks job status as free-text labels like 'Quoted', 'In Progress', 'Complete', and 'Invoiced'. Dynamics 365 Sales Opportunity uses a pick-list stage model (Qualification, Proposal, Negotiation, Closed Won, Closed Lost) that does not have a native equivalent for trade-job stages. We map Powered Now statuses to the nearest Dynamics 365 Sales stage values during migration, but your admin should review and adjust the stage pipeline configuration in Dynamics 365 Sales after data lands to reflect your actual trade-business sales cycle accurately.

  • VAT and Making Tax Digital fields have no native Dynamics 365 Sales home

    Powered Now is built for UK trade compliance, including VAT rate tracking per line item and Making Tax Digital submission flags on invoices. Dynamics 365 Sales has no native VAT amount field or MTD status flag on Invoice records. We preserve both as custom currency and option-set columns on the Invoice entity, but MTD filing still requires a separate bridging tool or manual process outside of Dynamics 365 Sales CRM.

  • Diary entries and What3Words data land as Tasks, not as a scheduling board

    Powered Now's diary and job-routing features have no equivalent in Dynamics 365 Sales base CRM. We translate diary entries to Task records with owner, date, and description fields, and preserve What3Words site references as custom text fields on the Opportunity. However, the visual scheduling board, engineer routing, and What3Words field navigation must be rebuilt using Power Apps or a third-party field-service add-in post-migration.

  • Purchase orders and supplier invoices require a custom Dataverse table

    Dynamics 365 Sales does not include a purchase order or supplier invoice entity in the base CRM schema. Powered Now's purchase order and supplier invoice records cannot map to any standard Dynamics 365 Sales object. We create a custom Dataverse table to hold these records, but it will not appear in standard Dynamics 365 Sales forms without a custom Power App or form configuration by your admin.

  • Certificate and compliance documents migrate as Notes only

    Powered Now generates and stores certificates for gas safety and electrical work with expiry dates, engineer signatures, and site references. Dynamics 365 Sales has no certificate-generation capability. Migrated certificates land as Note (Annotation) attachments on the related Opportunity record, with certificate type and expiry date stored as custom fields for tracking. The actual PDF or document must be regenerated using a dedicated certificate tool post-migration.

Migration approach

Six steps for a successful Powered Now to Microsoft Dynamics 365 Sales data migration

  1. Map Powered Now data model to Dataverse schema

    Before any data moves, we map Powered Now's object model — clients, jobs, quotes, invoices, diary entries, purchase orders, certificates, and custom fields — to the nearest Dynamics 365 Sales and Dataverse equivalents. For objects with no standard target (purchase orders, supplier invoices), we design a custom Dataverse table schema and present it for your admin's approval before creation. We also flag any Powered Now field types that require value-mapping (job status, invoice status) so the pick-list configuration is ready in Dynamics 365 Sales.

  2. Resolve engineers and users by email

    Powered Now team members are matched against Dynamics 365 Sales users by email. Unmatched engineers are flagged before migration — your team either creates a Dynamics user for each engineer or assigns their records to a fallback owner. No Opportunity or Task lands in Dynamics 365 Sales without a resolved OwnerId.

  3. Migrate accounts, contacts, then jobs as opportunities

    Dynamics 365 Sales requires Accounts to exist before Contacts (via AccountId lookup) and Opportunities to reference Contacts via OpportunityContactRoles. We sequence the migration: Accounts first, then Contacts linked to Accounts, then Opportunities with owner resolution, then Quote and Invoice records with their product lines. This ordering ensures foreign key integrity throughout the load.

  4. Run a sample migration with field-level diff

    A representative slice — typically 100–500 records spanning clients, jobs, quotes, invoices, and diary entries — migrates first. We generate a field-level diff between source and destination so you can verify stage mapping, VAT field preservation, owner resolution, and custom field population before the full run commits. Your sign-off on the sample unlocks the full migration.

  5. Cut over with delta-pickup for in-flight records

    Full migration runs against Dynamics 365 Sales via the Dataverse Web API. A delta-pickup window (typically 24–48 hours) captures any records created or modified in Powered Now during the cutover so Dynamics 365 Sales reflects the final state at go-live. Audit log records every operation, and one-click rollback is available if reconciliation identifies data integrity issues.

Platform deep dives

Context on both ends of the pair

Powered Now logo

Powered Now

Source

Strengths

  • UK MTD compliance is native to the platform, eliminating the need for separate accounting software for straightforward sole-trader and small-business tax filing.
  • On-site invoicing with mobile card reader integration accelerates payment collection and improves cash flow for field-service businesses.
  • Unlimited contacts and quotes are included even on lower tiers, making cost predictable as the client base grows.
  • Digital forms and certificates are attached directly to jobs, keeping compliance documentation organised and retrievable without paper filing.
  • Cross-platform availability on iOS, Android, PC, and Mac ensures field engineers can use the app on whatever hardware they already carry.

Weaknesses

  • No published public REST API means third-party integrations must go through unofficial channels or Zapier/Make workflows, limiting automation options.
  • Data export appears to rely on CSV or in-app backup rather than a structured programmatic export, making bulk migration a manual process.
  • Pricing is per-seat, which becomes costly for larger field-service teams compared to flat-rate alternatives.
  • Advanced workflow automation (job routing, time tracking, Xero integration) requires higher-cost tiers, raising the effective price for growing businesses.
  • The platform is UK-primary; businesses with operations outside the UK or with non-UK accounting requirements may find compliance features incomplete.
Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

Destination

Strengths

  • Native integration with Microsoft 365, Teams, Outlook, and SharePoint for unified productivity workflow
  • Unlimited custom tables and complex workflows on Enterprise tier enable deep customization for complex sales processes
  • AI-driven predictive analytics and deal intelligence on Enterprise and Premium tiers help sales teams prioritize pipeline
  • Dataverse unified data layer provides a consistent API and data model across all Dynamics 365 and Power Platform apps
  • Strong security model with Field-Level Security and Record Ownership rules for governance-conscious enterprises

Weaknesses

  • Sales Professional tier caps custom tables at 15, creating a migration ceiling for highly customized SMB environments
  • October 2024 pricing increases of $15 per user across all tiers apply to existing customers upon renewal
  • Implementation typically requires costly certified partners, adding 30–50% to total project cost
  • Updates and platform releases can disrupt customizations and plugins, requiring regression testing after each wave
  • Non-Microsoft integrations require additional configuration or middleware, limiting flexibility for heterogeneous tech stacks

Complexity grading

How hard is this migration?

Standard CRM migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Powered Now and Microsoft Dynamics 365 Sales .

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Powered Now: Not applicable..

  • Data volume sensitivity

    B

    Powered Now doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Powered Now to Microsoft Dynamics 365 Sales migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Powered Now to Microsoft Dynamics 365 Sales data migrations

Answers to the questions buyers ask most during Powered Now to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Powered Now to Microsoft Dynamics 365 Sales migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most Powered Now to Dynamics 365 Sales migrations complete in 48–72 hours for under 50,000 records. Larger setups with 500,000+ records or heavy custom fields extend to 5–7 days. The longest planning step is mapping Powered Now's job-status labels and VAT fields to Dynamics 365 Sales stage and custom column configuration before data starts moving.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Powered Now.
Land in Microsoft Dynamics 365 Sales , intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day