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)
Anonymized engagement summaryOil and gas producer · 2020
Opening answer. In 2020 EPC Group was engaged by an oil and gas producer 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.
During the engagement 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 recorded its acceptance of the services delivered.
This is an anonymized engagement summary published under EPC Group's anonymized-engagement rule: the client is not named, no commercial terms are published, and every statement is EPC-reported. Named, documented engagements are in the Evidence Center.
Problem and scope
| Item | Scope |
|---|---|
| Organization | An oil and gas producer |
| 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 |
Not reported: 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.
What EPC Group delivered and what is not claimed
| Claim | Basis | Status |
|---|---|---|
| The producer contracted EPC Group for a Power Platform automation program | EPC engagement record | Contracted (EPC-reported) |
| EPC Group built the well-test editor's screens and its SQL integration through Power Automate | EPC delivery record | Delivered (EPC-reported) |
| The client accepted the services delivered | Client correspondence on file (2020) | Accepted (EPC-reported) |
| Process time saved or other measured results | Not reported | Not claimed |
Related services
Power Platform · All case studies · Talk to a senior architect
Last updated by Errin O'Connor, Founder & Chief AI Architect, EPC Group
Related service: Power Platform Center of Excellence — Governance
Author: Errin O'Connor, Founder & Chief AI Architect, EPC Group · Published October 25, 2026 · Project alias EPC-2020-ANON-OILGAS-POWERAPPS · Published under the anonymized-engagement rule.