Skip to content

FDU-FDC Finance Data Update and Compare Canvas Apps

Enterprise client

Built and deliveredFinanceCross-industry

In short

How can finance users update database records without writing SQL?

Finance users who are not technical had to write SQL formulas to load Excel data into a database, so a simple task became slow and hard. The client needed an easier way to update and compare finance data. We delivered canvas Power Apps that connect to the existing data source and keep Excel export.

At a glance

  • SQL formulas replaced by canvas apps
  • Direct connection to the existing data source
  • Excel export kept for finance users

The client

The users are in the finance department, which keeps its data in Excel files and a department database.

What it was costing them

  • Hard to use: adding data with SQL formulas was not intuitive for non-technical employees.
  • Time lost: employees spent too much time on a process that was meant to be easy.
  • Error risk: typing formulas by hand to load data invites mistakes in finance numbers.
  • Key-person risk: the process depended on the few people who could write the formulas.

What we built

We built canvas Power Apps for finance users to update and compare data, connected directly to the department's data source.

  • No SQL needed: finance users add and change data in a friendly canvas app.
  • Same data as before: the apps connect directly to the department's existing data source.
  • Easy corrections: users can view and update previous rows in the app.
  • Compare in one place: the apps support both updating and comparing finance data.
  • Excel kept: the displayed list can be exported to Excel, so users can still store and save data as before.
  • Simple filtering: finding the rows you need takes a few clicks.
  • A look that fits: the interface is designed to match the organisation.

Results

  • A user-friendly interface designed to fully match the organisation.
  • Finance staff can view and update previous rows because the apps use the existing data source.
  • The process is no longer confusing for non-technical users.
  • Employees can still store and save data in Excel through the export feature.
  • Filtering of data is simpler.

The risk most teams miss

Canvas apps that talk straight to a database struggle as data grows. By month three, tables pass the delegation limit, users change rows they should only read, and every user needs direct database access. We use views and indexed filters, role-based write access and a log of who changed what.

What we would add today

Improvements we would add on top of what is live.

  • Route writes through a validated flow or stored procedure with a change log, instead of direct table writes.
  • Move reference data to Dataverse with row and field security and auditing, or keep the database and add Dataverse virtual tables.
  • Add an approval step in Power Automate before a change reaches the finance data, with a visible history.
  • Connect with a service principal or shared connection reference instead of personal credentials, and plan the premium licence cost for the database connector.
  • Show differences between versions in a compare view with a Power BI review report, and release through Power Platform pipelines in a Managed Environment.

Technology

Power Apps canvas apps connected to the department's existing database, with Excel export.

Tell us which finance data your team still loads with formulas or scripts, and we will tell you how to put a simple app in front of it.

Products and capabilities

  • Power Apps
  • canvas app
  • SQL
  • Excel export
  • finance data
  • data update

Related use cases

Finance

Have a Microsoft project in mind?

Tell us what you need built, fixed or supported. A senior consultant replies within one business day.