Canvas PowerApps are great for building simple apps that make us more efficient and help remove obstacles to collecting data. In this blog post I am going to showcase a PowerApp that I have built which significantly improves the speed in which a user can record a customer visit as an Appointment in Dynamics 365.

The Scenario

The scenario I am tackling is one in which Account Managers visit their customers on an often adhoc basis and want to be able to quickly record a visit in Dynamics 365. The purpose of tracking these visits with customers is so that the visit data can be used to identify which customers are getting the attention they need and which ones aren’t.  Combined with other data, machine learning scenarios can be conducted to do things like proactively predict customer churn rates, identify customers that are most likely to leave, or reduce or stop purchasing products and services.  But the data needs to be captured first.

Account Managers are busy people and do not have time, or the inclination to carry out 10+ taps on their phone or tablet just to create a simple appointment record in Dynamics 365.  There must be a simpler way!

The Solution

The solution is based on a Canvas PowerApp showing the Account Manager the Account records for customers that are at the same location that he or she is currently at. With one click the user can add an Appointment to the Account record.  This enables an Account Manager to attend a visit with a customer and then quickly record their visit on the spot.

The solution was built using the following…

Quick Customer Visit Architecture

1. Canvas PowerApp containing the following components

a. Gallery – listing all of the Accounts from Dynamics 365 within a certain radius of the users current location
b. A Bing maps control which shows the user’s and Account locations
c. A slider control that allows the user to change the search radius
d. Gallery controls to add an new appointment quickly without details, add new appointment with details and show the Account on the map
e. Confirmation label to confirm when the Appointment is created in Dynamics 365

Quick Visit App

2. Microsoft Flow which carries out the following steps

a. Triggered from the add appointment action in the PowerApp
b. Creates the appointment in Dynamics 365 based on the selected Account
c. Returns the successful result back to the PowerApp to confirm the Appointment was created.

Quick visit flow

The Result

With one click a new appointment is added to Dynamics 365.

Quick appointment created in Dynamics 365


The idea has been turned into a working prototype but only time will tell how well this app works in the real world. I’m looking forward to seeing how this goes but expect that the number of Appointments captured in Dynamics 365 would increase dramatically. If you have a scenario where this applicable to your business and want to try it out, please fell free to get in touch.

QuickVisit PowerApp