Skip to main content

Anonymized engagement summary: a Power Apps and Power Automate task-automation program, including a well-test editing app on SQL, for an oil and gas producer (2020)

Delivered — client service acceptance on file (EPC-reported; documents private)First-pass editionAn oil and gas producer (client not named) · 2020 · Project ID EPC-2020-ANON-OILGAS-POWERAPPS

Last updated by Errin O'Connor, Founder & Chief AI Architect, EPC Group

Opening answer. In February 2020 an oil and gas producer countersigned a statement of work with EPC Group for its data integration and task automation program on the Microsoft Power Platform. The goal: automate manual business processes with custom Power Apps and Power Automate (then called Flow) applications, and train in-house staff and super users to build their own.

By April 2020 EPC Group was building a well-test editing app. It covers:

  • well data and separator calculations
  • fiscal and well-test results screens
  • gauge depth
  • a Power Automate flow that calls an API and posts the data to SQL through a custom connector

The client accepted the services delivered in a service entry sheet dated April 24, 2020.

Disclosure. This is an EPC-reported anonymized engagement summary. The client is not named. The supporting records — the countersigned statement of work, the client's purchase orders, the kickoff and program decks, the weekly status report and the client's service entry sheet — are retained privately and are not published in the Evidence Center, so this account is outside the Evidence Center's documented-engagement counts. Every engagement fact below is taken from those documents.

Verification class

Delivered — client service acceptance on file (EPC-reported; documents private). The client's technology project manager countersigned the statement of work in February 2020, and the client issued purchase orders against it. A weekly status report from April 2020 lists the work completed on the well-test app. The client's own service entry sheet records services accepted on April 24, 2020. No business-outcome measurement is claimed.

Buyer problem and scope

ItemWhat the documents state
BuyerAn oil and gas producer (client not named)
ProgramA data integration and task automation program to streamline business processes with the Power Platform
ObjectiveAutomate manual processes, improve the efficiency of daily operations and raise staff productivity across departments
ApplicationsCustom low-code applications in Power Apps and Power Automate, integrated with other Office 365 technologies as required; tailored to the environment and user preferences; scalable and easy to change later
EnablementEnvisioning workshops on Power Apps and Power Platform capabilities; advanced Power Apps and Power Automate training for technical staff and super users so they can build apps themselves; a customized learning program, including end-user training
Centre of excellenceThe program deck frames the work as a Power Apps centre of excellence, with a train-the-trainer agenda and template apps as starting points

Unknowns, not stated in the documents cited: the full list of apps delivered beyond the well-test editor, user counts and any measured result.

Approach and artifacts

Build one working app, screen by screen. The status report shows the well-test editor being built screen by screen:

1. well data and separator calculations 2. separator and fiscal results 3. drop-downs in the well-data screens 4. well-test results, including a results view in the format of the client's engineering software 5. gauge depth

Daily stand-ups and a weekly meeting ran alongside the build.

Connect the app to the system of record. The app's data reaches SQL through Power Automate. A flow consumes the app's API and uses a custom connector to post to SQL. When two fields were added to an existing table, the API and the flow were updated and post-SQL issues were fixed, then the app was retested.

Build the client's own capability. The program pairs delivery with a centre-of-excellence approach. Envisioning workshops and a train-the-trainer agenda come first. Template apps then serve as starting points for the client's own builders: meeting capture, room booking, onboarding tasks and leave requests.

Documents (dated, held privately):

DocumentDate
Statement of work, Power Platform consulting and development (countersigned)February 2020
Client purchase ordersDates on file, not cited
Kickoff presentation; program discussion deck (Power Apps centre of excellence)Undated; on file
Weekly status report, well-test editor appApril 20, 2020
Client service entry sheet, services acceptedApril 24, 2020

Results and limitations

ClaimBasisStatus
The producer contracted EPC Group for a Power Platform automation programCountersigned statement of work (February 2020) and purchase ordersContracted (EPC-reported; documents private)
EPC Group built the well-test editor's screens and its SQL integration through Power AutomateWeekly status report, April 2020Delivered (EPC-reported)
The client accepted the services deliveredClient service entry sheet, April 24, 2020Accepted (EPC-reported; documents private)
Process time saved or other measured resultsNo document citedNot claimed

Provenance

  • Sources: the countersigned statement of work (February 2020), purchase orders, kickoff and program decks, the weekly status report (April 2020) and the service entry sheet (April 2020), held privately. Engagement ID: EPC-2020-ANON-OILGAS-POWERAPPS, an alias unrelated to the client's name.
  • Anonymization: industry only, under EPC Group's anonymized-case rule; the client's name, business unit, assets, location, staff names and commercial terms are not published.
  • Not claimed: client endorsement, or any measured result.
  • Author: Errin O'Connor, Founder & Chief AI Architect, EPC Group, who signed the statement of work for EPC Group.

Revision history

  • 2026-10-25: anonymized engagement summary published from the engagement's statement of work, status report and service acceptance.

Related service

Power Platform centre of excellence · Power Platform governance framework · Talk to a senior architect

Author: Errin O'Connor, Founder & Chief AI Architect, EPC Group · Published: 2026-10-25.

AI assistant — not a human