Beyond Power Automate's Limits: Endless Approval Flows

Power Automate flows increase operational efficiency, accelerate decision-making processes in the company and minimize human errors in repetitive activities. But even Power Automate has limitations, even harmful for some companies. Especially when compliance with strict regulations such as pharmaceuticals is involved. Is a solution possible? A customer asked us for it, and here's how it went.

Beyond Power Automate's Limits: Endless Approval Flows

The customer's problem: automating approval for individual documents, without worrying about Power Automate's limitations

Operating in the pharmaceutical sector, our client had implemented an automation to manage the approval of documents inserted in a SharePoint list dedicated to ongoing projects. The flow created with Power Automate was intended to address a series of crucial issues to ensure compliance with industry regulations.

The approval of documents plays an important role in the compliance of a pharmaceutical company, allowing greater traceability and transparency in operations. Given the large number of documents included in the archive, the need to implement automation soon emerged to speed up the approval process and lighten the workload of project managers.

However, the automation was not working as expected. This is because:

  1. The approval request bundled multiple documents.
  2. The contacts had 30 days to approve or reject the requests, after which the flow would stop and require a manual restart.

If in the first case, the problem was specific to the flow implemented by the customer; in the second, the limitation was specific to Power Automate. All automations built with this tool stop by default after 30 days of inactivity by the users involved.

We therefore had to think of a radical solution, to compensate for the 'flaws' of Power Automate and allow our customer to no longer have to worry about malfunctions and recurring interruptions in the management of business documents.

Our solution: a double automation, capable of repeating itself over time

To meet customer requirements and solve the problems underlying Power Automate flows, we have developed combined automation. These are two flows that interact with each other to:

  1. Send the request to the project contact person, keeping the approval ID in the SharePoint list that acts as a document repository.
  2. Repeat open requests every 29 days and 23 hours, changing the status of the active flow from 'Timeout' to 'In progress'. This creates an execution queue for all the documents added to the archive and for which the approval request is automatically renewed until satisfied.

Both malfunctions were resolved in one fell swoop, with a minimum use of time and resources.

In one fell swoop, we made Power Automate automation, in fact, infinite.

The results obtained

Together with the customer, we tracked the number of requests automatically distributed in the company, to understand if the solution was really the right one to improve the employee experience. The answer?

Let's take a look at a significant fact together:

  • To date, around 1,000 documents have been approved without interruption.

Since our solution was implemented, no negative feedback from users has yet been shared.

Get in touch with the team

Modern Apps

The Modern Apps team specializes in development and integration across the entire Microsoft 365 ecosystem. We design native applications for Microsoft and Azure platforms, and implement business processes that integrate with and maximize the investment in Microsoft 365.