Identify the nearest technician from an asset using Power automate

Hi john john,

thanks for your feedback.

The Bing Maps connector in Power Automate can indeed help you calculate distances and routes between coordinates, which could be useful for finding the nearest technician to an asset.

Bing Maps - Connectors | Microsoft Learn

To do that you can use following steps:

Step 1: Set Up Your Flow Trigger

• Begin by creating a flow in Power Automate. Configure it to trigger whenever a new support ticket is created for an asset in your SharePoint list.

Step 2: Retrieve Asset Coordinates

• Use the SharePoint connector in Power Automate to get the latitude and longitude of the asset from your SharePoint list.

Step 3: Fetch Technicians' Coordinates

• Again, use the SharePoint connector to retrieve the latitude and longitude of all your technicians from the SharePoint list where their current locations are stored.

Step 4: Loop Through Technicians

• In your flow, employ an "Apply to Each" control to cycle through each technician's coordinates.

Step 5: Calculate Distances

• Within this loop, employ the Bing Maps connector to calculate the distance or travel time between the asset's coordinates and each technician's current coordinates. You can use the "Get Route" action for this calculation.

Step 6: Identify the Nearest Technician

• As you go through the loop, keep track of the technician with the shortest distance or travel time. You can use variables or compose actions in Power Automate to store this information.

Step 7: Send Email to the Nearest Technician

• Once the loop completes, you'll have determined the nearest technician. Send an email notification to this technician with all the necessary details regarding the support ticket and the location of the asset.

Step 8: Optional - Update SharePoint List

• If needed, you can update a SharePoint list or a specific record associated with the support ticket to indicate that the nearest technician has been assigned.

I hope this helps you.