Power Apps data integration

Property investors become customer-centric with Power Apps data integration

Influential Software delivered a Power Apps data integration solution that gave the company an intuitive dashboard for customer data.

CRM graphic representing Power Apps data integration with SharePoint

Executive brief

Boosting efficiency with SharePoint Power Apps

Our client is an investment management firm with property assets of over £5 billion. Influential Software’s integration experts assisted the company with SharePoint data migration and Power Apps data integration solutions. The benefits of this project were:

full customer data visibility

improved customer satisfaction

reduced manual data tasks

future-proof cloud platform

Wondering how we achieved this with Power Apps data integration? Read on to learn more.

The full story

Purple arrow encouraging readers to scroll down for the rest of the GDPR data solutions case study

The challenge

Disparate customer data was hampering growth

Managing £5 billion worth of property assets requires fast and flawless coordination between sales, service, and back-office staff. And to make that happen you need complete, accurate, and easily accessible customer data.


For our client, this data included customer requirements documents, tenancy calendars, meeting calendars, and customer notes. However, the customer’s existing system required staff to search manually through multiple documents to find the data they needed. This disparate data was causing inefficiencies across the company’s sales, marketing, and finance teams.


In brief, the drawbacks of this unintegrated data were:


  • no customer-centric view of customer data
  • slow processes affecting customer satisfaction
  • higher operating costs due to manual tasks


And there was another barrier: the customer data was in SharePoint 2013, which had reached the end of Microsoft support. Besides the cost of Microsoft extended support, the company also had to plan for SharePoint 2013 end of life in 2023. Another negative was the high cost of maintaining the on-premises SharePoint server.


For these reasons, it was clear that the company needed to migrate its customer data to an integrated modern platform.

The solution

SharePoint Power Apps data integration

Aware of our reputation as SharePoint experts, the client approached Influential to design a data integration and migration solution.


Our proposal was twofold:


  1. to migrate data to SharePoint online, in the cloud — avoiding the need for upgrades or on-premises maintenance
  2. to create a single page for each customer, displaying all data in an intuitive format, through Power Apps data integration


With the low-code Power Apps designer, this technology also meant we could develop the client’s integrations quickly and at low cost.


For the first part, we followed a three-phase process of discovery and design, CRM build, and data migration. This process worked as follows:


  • Discovery and design: our SharePoint consultant worked to understand the client’s customer and inventory data model, and how we could transform it into a customer-centric UI
  • Minimal viable product (MVP) build: we built a new CRM in SharePoint 365, where the client could test the functionality and prove its effectiveness
  • Data migration: we tested and automated the data mappings and transformations to load the SharePoint 2013 data into the new model


At the same time, our digital integration experts were working on the SharePoint Power Apps data integration. The result was six Power Apps, one for each type of customer data. These six Power Apps were present on each customer page in the client’s SharePoint 365 system.


By designing the customer pages to act like a filter on the Power Apps, we made each app only show data relevant to that customer. In this way, the client’s staff could see all data for a particular customer on one page. And they could also interact with that data through the Power Apps. This meant that there was a single, always updated source of record for each customer.

The benefits

Building a customer-centric business in the cloud

It’s a truism that a business is only as valuable as its customers. For this reason, meeting customers’ needs should always be the number one priority.


By bringing all customer data together, our Power Apps data integration solution empowered this client to serve its customers better. And that had a knock-on effect in terms of customer retention, upselling opportunities, and ultimately revenue.


Overall, the business benefits of this SharePoint Power Apps data integration project were:


  • more effective customer service and sales teams
  • increased visibility into customer needs and opportunities
  • no worries about SharePoint upgrades or maintenance
  • the ability to quickly scale or modify the central CRM

Unite your customer data

This property client is one of dozens that benefit from our data integration expertise. Whether it’s for CRM, HR, BI, or GDPR, we have the know-how to overcome your data challenges. For more details, visit our integration solutions page.


27th October 2020
SharePoint, Power Apps, data integration

Privacy Preference Center




Analytics cookies collect information that is used either in aggregate form to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you.

Google Analytics
The cookie _gcl_au is used by Google Analytics to understand user interaction with the website.

For example, in order for Google Analytics to determine that two distinct hits belong to the same user, a unique identifier, associated with that particular user, must be sent with each hit.

The analytics.js library accomplishes this via the Client ID field, a unique, randomly generated string that gets stored in the browsers cookies, so subsequent visits to the same site can be associated with the same user.

By default, analytics.js uses a single, first-party cookie named _ga to store the Client ID, but the cookie's name, domain, and expiration time can all be customized. Other cookies created by analytics.js include _gid, AMP_TOKEN and _gac_. These cookies store other randomly generated ids and campaign information about the user.

Google Analytics
_gcl_au, _gid, _ga, gtm_preview


WordPress uses cookies for authentication. That means that in order to log in to our WordPress site, you must have cookies enabled in your browser.

There are two types of cookies set by WordPress.
1 — Session cookies — These are ‘strictly necessary’ cookies as WordPress will not be able to function without it.
2 — Comment cookies — These are not ‘strictly necessary’ cookies and are set when users leave a comment on a post.

Wordpress Session cookies:
Users are those people who have registered an account with the WordPress site.

Wordpress comments:
Comments are usually turned off by default.
If by chance they are still active on a post, asides being turned off when spotted, data from these are not saved by Influential.
- When visitors comment on a post, they too get cookies stored on their computer. This is purely a convenience so that the visitor won’t need to re-type all their information again when they want to leave another comment. Three cookies are set for commenters:

Wordpress, Intercom
comment_author_{HASH} comment_author_email_{HASH} comment_author_url_{HASH} wordpress_[hash] wordpress_logged_in_[hash] wordpress_test_cookie wp-settings-{time}-[UID]