Skip to content

Reserves Data Submission App with Approvals and Power BI

International oil and gas company

In short

How can an energy company replace Excel data submissions with an approval app?

Reserves data was collected in Excel files that several people had to fill in, and any change to the file layout risked mismatches between templates. Collecting and consolidating the data took a long time and needed many follow-up emails. We built a model-driven app that generates each submission, validates the data and routes it for approval, with Power BI reports on top.

Results in numbers

specification pages
70+

At a glance

  • Complex Excel submission files replaced by one app
  • Seven linked data tables with country and field logic
  • Approval with comments built into the process

The client

The client is an international oil and gas company based in the Middle East. Each country team submits reserves data in mid-year and year-end reporting cycles, and a function head approves it.

What it was costing them

  • Time: data collection took a long time because several people had to fill in one file.
  • Errors: manual consolidation could produce mistakes and inconsistencies.
  • Chasing: submitters and approvers needed repeated follow-up emails.
  • Fragile templates: a change to the Excel layout could leave templates out of step and make cycles hard to compare.

What we built

We built a model-driven Power Apps app that orchestrates each reserves submission, supports data validation and automates a multi-level approval, with Power BI reports on the structured data.

  • The right form for each country: the app generates a submission per reporting cycle and emails the submitter for that country.
  • Less retyping: production data is carried over from the last cycle and pre-filled, read-only where it should not change.
  • One model instead of many Excel files: seven linked tables cover submissions, production data, resources, input profiles, variation analysis, reserves movements and economic assumptions.
  • Several views of one record: gross, working interest and entitlement tabs show the same data the way each reviewer needs it.
  • Project reserves captured properly: project-based reserves and prospective resources are created from the submission, with economics fields such as NPV and IRR.
  • Approval where the work is: the function head, or a delegate, approves or rejects from the ribbon with a comment, and a rejection returns the submission to the submitter.
  • Consolidated reporting: Power BI reports use the structured submission data.

Results

  • Excel submission files were replaced by a single model-driven app on Dataverse.
  • The approval process was automated across several levels, with approve or reject and a comment.
  • The solution was documented requirement by requirement in a functional and technical specification of more than 70 pages.

The risk most teams miss

The month-three risk is structure drift. When someone adds a field or changes a reference list, templates and reports fall out of step, and custom JavaScript buttons can break after a platform update. We kept the data in related tables and documented every requirement. We add change control and a master data check before each reporting cycle.

What we would add today

Improvements we would add on top of what is live.

  • Replace custom JavaScript ribbon commands with command bar actions in Power Fx, which are easier to maintain.
  • Add Dataverse row and field security by country team and role, with audit enabled on submissions and approvals.
  • Link Dataverse to Fabric so Power BI reports read the data without custom extracts.
  • Use AI Builder prompts to draft the explanation of movements between cycles from the variation analysis data.

Technology

Power Apps model-driven app on Dataverse, Power Automate and workflows for notifications and approvals, custom JavaScript commands, Power BI.

Tell us which Excel templates your teams still fill in and send around, and we will tell you how to turn them into one governed submission process.

Products and capabilities

  • Power Apps
  • Dataverse
  • Power Automate
  • Power BI
  • model-driven app
  • business process flow
  • approval workflow
  • data submission

Have a Microsoft project in mind?

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