Many business-critical processes still live in Excel files and informal messages: no versioning, untracked approvals, delegations that are hard to manage.
The flow
With Power Automate, uploading a file to a SharePoint folder starts the chain: each approver gets a card in Teams, approves or rejects, and the flow moves to the next person. Delegations are handled automatically and everything ends up in a searchable history.
Why low-code
Shorter development times, tools people already use every day, and the ability to evolve the process without rewriting an application.
The case study: Product Formulary Approval
The context
Marketing plays a crucial role in creating a new product formulary, defining positioning, pricing strategy, promotion and communication. The approval chain involves several departments and hierarchical levels, follows a specific path and must handle delegations: it calls for automation that ensures traceability, order and policy compliance.
The problem
Formularies used to be managed through Excel files and informal communication between departments, which led to:
- No formal constraints or versioning
- Risk of errors and untracked approvals
- Difficulty managing delegates and approvers
- Difficulty communicating between the different roles
The new automated process
- Uploading the Excel file to the SharePoint folder «To be approved» starts the flow; each file contains the list of approvers
- The first approver is notified via Microsoft Teams, following the hierarchical order
- Each approver can download the file, approve or reject it; with a delegation, the first response received is valid
- A formulary is «APPROVED» only with positive responses along the whole chain; one negative response moves it to «NOT APPROVED»
- An approval history is generated automatically: approver or delegate, outcome, email, dates received and answered
Benefits
- Fully automated approval chain
- No more bottlenecks
- Control and traceability of every decision
- Accessibility and collaboration through Teams
- Greater efficiency and fewer errors



