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
| Item | What the documents state |
|---|---|
| Buyer | An oil and gas producer (client not named) |
| Program | A data integration and task automation program to streamline business processes with the Power Platform |
| Objective | Automate manual processes, improve the efficiency of daily operations and raise staff productivity across departments |
| Applications | Custom 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 |
| Enablement | Envisioning 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 excellence | The 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):
| Document | Date |
|---|---|
| Statement of work, Power Platform consulting and development (countersigned) | February 2020 |
| Client purchase orders | Dates on file, not cited |
| Kickoff presentation; program discussion deck (Power Apps centre of excellence) | Undated; on file |
| Weekly status report, well-test editor app | April 20, 2020 |
| Client service entry sheet, services accepted | April 24, 2020 |
Results and limitations
| Claim | Basis | Status |
|---|---|---|
| The producer contracted EPC Group for a Power Platform automation program | Countersigned statement of work (February 2020) and purchase orders | Contracted (EPC-reported; documents private) |
| EPC Group built the well-test editor's screens and its SQL integration through Power Automate | Weekly status report, April 2020 | Delivered (EPC-reported) |
| The client accepted the services delivered | Client service entry sheet, April 24, 2020 | Accepted (EPC-reported; documents private) |
| Process time saved or other measured results | No document cited | Not 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.