Loading...

Dynamics 365 Field Service : Configure geocoding for a custom table

Dynamics 365 Field Service :  Configure geocoding for a custom table

Dynamics 365 Field Service enables businesses to deliver onsite service to customer locations efficiently. One of the core features that powers Field Service logistics is geocoding—the ability to convert an address into geographical coordinates (latitude and longitude).

This is vital for features like:

  •  Work order location mapping
  •  Route optimization
  •  Resource scheduling
  •  Proximity-based filtering

But what if your business has a custom table—like `Warehouse`, `Customer Site`, or `Supplier Location`—and you want to enable geocoding on that table too?

Let’s walk through how to configure geocoding for a custom table in a way that blends naturally with Field Service’s native capabilities.

What is Geocoding in Field Service?

Geocoding is the process of translating a physical address (like “123 Main Street, Delhi”) into coordinates (like `28.6139° N, 77.2090° E`).

By default, Field Service geocodes locations for:

  •  Accounts
  •  Work Orders
  •  Bookable Resource Addresses

But with a few simple steps, you can extend this to any custom table that has address fields.

Prerequisites

Before we begin, make sure you have:

  •  Dynamics 365 Field Service installed and licensed
  •  Admin or System Customizer role
  •  Access to Power Platform Admin Center
  •  Custom table created with address fields (Street, City, State, Postal Code, Country)

Let’s assume our custom table is called `Warehouse`.

Step-by-Step Guide to Enable Geocoding for Custom Table

Step 1: Add Address Fields to the Custom Table

Ensure your custom table (e.g., `Warehouse`) has the following address fields:


| Logical Name                       | Display Name    |

| `address1_line1`                    | Street 1              

| `address1_city`                      | City                      

| `address1_stateorprovince`    | State/Province  |

| `address1_postalcode`            | ZIP/Postal Code |

| `address1_country`                 | Country         |

These fields are required by the geocoding process to compute coordinates accurately.

 Tip: These are standard address schema names. Using them allows Field Service features to detect and use them automatically.

Step 2: Enable Bing Maps Integration (Optional but Recommended)

Go to Advanced Settings → Administration → System Settings → General tab:

  •  Find the Set Bing Maps Integration option and ensure it is enabled.
  •  Enter your Bing Maps Key if it's not already present (usually added by your admin).

Step 3: Enable Geocoding for the Custom Table

1. Go to Power Apps Maker Portal

  • URL: https://make.powerapps.com

2. Navigate to Your Solution → Custom Table (e.g., Warehouse)

3. Under the Data experiences section:

  •  Enable Geospatial features
  •  Choose Geocode addresses using Bing Maps

4. Click Save and Publish All Customizations

Step 4: Add Latitude and Longitude Fields

To store geocoded values:

 Create two custom fields:

  •    `Latitude` (Decimal Number, Precision: 6)
  •    `Longitude` (Decimal Number, Precision: 6)

Note: You can name them anything, but using `latitude` and `longitude` ensures compatibility with map controls.

Step 5: Configure and Use Power Automate for Geocoding (Optional for Advanced Use)

If you want to trigger geocoding automatically on record creation or update:

1. Create a Power Automate flow that calls Bing Maps API.

2. Update the record with the retrieved `Latitude` and `Longitude`.

3. Use this data for map visualizations or scheduling logic.

Alternatively, use Field Service’s built-in geocoding plugin, which will auto-trigger if the schema is correct.

Visualizing on the Map

Once geocoding is enabled and records have valid coordinates:

  •  Use Map Controls on the table’s view or form.
  •  Enable map view in Model-Driven App settings.
  •  Use Proximity Search for filtering records by distance.

Conclusion

Enabling geocoding for a custom table in Dynamics 365 Field Service unlocks advanced routing, mapping, and scheduling capabilities. Whether it’s tracking warehouses, service centers, or remote assets—geospatial intelligence adds value across the board.

By following the steps above, you can integrate location intelligence into your custom tables seamlessly. 

Published on:

Learn more
Power Platform , D365 CE & Cloud
Power Platform , D365 CE & Cloud

Dynamics 365 CE, Power Apps, Powerapps, Azure, Dataverse, D365,Power Platforms (Power Apps, Power Automate, Virtual Agent and AI Builder), Book Review

Share post:

Related posts

What’s New in Dynamics 365 Field Service Mobile

Field Service Mobile just got smarter. New updates help technicians work faster, stay connected, and handle jobs with fewer clicks. The post ...

5 days ago

Dynamics 365 Field Service – Optimize multiple resources with Scheduling Operations Agent

We are announcing the ability to optimize multiple resources with Scheduling Operations Agent in Dynamics 365 Field Service. This feature will...

8 days ago

How We Successfully Removed the Resco Woodford Managed Solution from Dynamics 365 Field Service

Recently, we needed to remove the legacy Resco MobileCRM (Woodford) managed solution from a Dynamics 365 Field Service environment. Although t...

9 days ago

Unable to Delete Work Order Due to “The Time To Promised Must Be Later Than The Time From Promised” exception – Dynamics 365 Field Service

While attempting to delete a historical Dynamics 365 Field Service Work Order, we encountered the following error: Exception Message: The time...

15 days ago

Dynamics 365 Field Service – Explore Dataverse data with Microsoft 365 Copilot

We are announcing the ability for service managers, dispatchers, and back-office teams to query work orders, bookings, service history, and as...

1 month ago

How to Optimize Mobile Offline Profiles Using FetchXML in Dynamics 365 Field Service

In many Field Service implementations, mobile offline capability is essential, especially for technicians working in low or no network areas. ...

2 months ago

We need to talk about... Dynamics 365 Field Service... Release Wave 2 for 2025

Next in my blog, I will launch a series on the changes we can expect to see as part of Release Wave 2 for 2025. Microsoft’s 2025 Release Wave ...

3 months ago

Dynamics 365 Field Service: Optimize schedules with Scheduling Operations Agent

The Scheduling Operations Agent for Dynamics 365 Field Service enables dispatchers to quickly and easily optimize schedules for technicians as...

4 months ago

How to Use Copilot to Create Inspection Templates in Dynamics 365 Field Service from PDF and Image Uploads (2025 Guide)

Microsoft’s Dynamics 365 Field Service mobile app empowers field technicians to manage tasks, log inspections, and ensure compliance directly ...

9 months ago

Dynamics 365 Field Service – Tailor Copilot chat experience with Copilot Studio

We are announcing the ability of makers being able to customize their experience of the Copilot side pane by using the customization capabilit...

9 months ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy