FDU-FDC Finance Data Update and Compare Canvas Apps
Enterprise client
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
The service behind this work
Power Platform development
Related use cases
FinanceSchools Division Integrated Planning in the Accountability Framework App
Each year, the schools division network of the client had to plan business, manpower and finances for all of its schools and centres, in separate spreadsheets that someone had to merge by hand. The cycle had a fixed calendar and a presidential review, so late or inconsistent plans cost real time. We added integrated planning to its existing Accountability Framework app.
- 30+
- schools on shared templates
- c. 90
- departments imported
Bank Reconciliation Proof of Concept for Oracle
Matching bank transactions to finance records by hand costs time every day and ties the process to the people who know the rules. The client was moving to a new Oracle system and asked how reconciliation could work on it. We ran a short proof of concept on its own data.
Weighbridge Integration and Automated Invoicing for Quarries
At a quarry every load is weighed, but the weight often stops at the gate. When tickets are keyed in again for invoicing, bills go out late, mistakes slip in and stock figures lag behind what has left the site. We linked the weighbridge to invoicing and to a live view of reserves.
Have a Microsoft project in mind?
Tell us what you need built, fixed or supported. A senior consultant replies within one business day.