Geschäftsmann hält Molekülmodell im Büro in Händen

Managing internal reporting fast and accurate – with Flow and Azure

Error-free reporting with Power Automate and Azure

novaCapta helps ARCONDIS to manage its internal reporting processes quickly and accurately – using the Microsoft 365 technologies Power Automate (formerly Flow) and Azure Functions.

SharePoint Report Page

Challenge

Reporting workflow was slow and prone to error

Incorrect automatic setting of permissions for documents

Solution only possible with inclusion of third-party product Qlik NPrinting

Solution

Replacement of SharePoint Designer workflows by modern O365 technologies like Flow and Azure Functions 

Automatic selection and insertion of metadata 

Consideration of permissions concept

Close and successful cooperation with developers of Qlik NPrinting

Benefit

Fast and accurate solution for the reporting in a globally active company

Reducing time and money in internal processes

Future-proof „Serverless Code“-solution that can be adapted to other processes of Operational Reporting 

Portraitbild von Michèle Kayser Senior Sachbearbeiterin Finance & Controlling ARCONDIS AG, Basel

novaCapta realized the project very well and provided us with an extendable reporting solution that can be used for other scenarios as well.

Michèle Kayser Senior Consultant Finance & Controlling ARCONDIS AG, Basel

Smart Automatization for Reporting

Today is the deadline for all cost center reports, which are generated on a monthly basis by all departments with budget responsibility and then stored in SharePoint. Everyone is looking at the SharePoint library where all reports with matching metadata are automatically stored. And yes – great joy among all parties involved: the

cost center reports are complete; the matching metadata and permissions are correct. That’s what Michèle Kayser, project manager for updating the reporting workflow, wished for: “Since novaCapta remodeled our cost center workflow with Flow and Azure Functions, the process has run fast and flawlessly.”

Set Permissions Automatically

In most companies, reports are standard procedure in everyday work. Cost center reports ensure a consistent level of information for budget managers, executives and controlling. ARCONDIS Consulting in Basel organizes the work of its employees in regular reports, too. In the first step, the employees use the third-party product Qlik NPrinting for the reporting. After their creation, the reports are being uploaded in a SharePoint library. In doing so, a filename is generated that contains information about the team, the department and the cost center according to company-wide naming conventions. Said filename is then being analyzed by the workflow and the extracted information are being stored as metadata. Permissions are derived by that information as well. In the past, this process was operated by SharePoint Designer workflow – unfortunately very slow and prone to error. ARCONDIS saw an urgent need for action here and hired novaCapta to implement a fast and accurate process in a pilot project.

SharePoint List View

Perfect Interplay of Flow & Azure

The novaCapta experts didn’t rely on typical third-party workflow products like Nintex or K2 but used the technology stack of Office 365: the process was implemented with Flow and Azure Functions. Already during the conception of the workflow, Raphael Stäheli, novaCapta project manager, and his team paid special attention to the possibility of adapting the workflow fast and easy for other scenarios.

This way, the solution can be used in all areas of Operational Reporting at ARCONDIS. “We already knew from experience that especially the automatic setting of permissions for report documents would be a challenge.” says Michèle Kayser from ARCONDIS. “But the expert team from novaCapta mastered the problem perfectly.” 

Download Case Study ARCONDIS PDF (DE)

Download Case Study ARCONDIS PDF (EN)

Company Profile ARCONDIS

Logo der Firma Arcondis freigestellt

ARCONDIS is the largest consulting company exclusively specialized in the life science industry in Switzerland, Germany and Austria. Over 90 consultants support more than 150 customers in the fields of processes, IT management and compliance worldwide.

https://www.arcondis.com/de/

 

Technologies used

freigestelltes Logo von Azure
Logo Microsoft Power Automate

We can advise you on all aspects of the Power Platform

 My team and I look forward to hearing from you.

Portraitbild von Mario Westrup, novaCapta

Thomas Kogler

Head of Intelligent Business Platforms

Autos der Marke Toyota auf einer Rennstrecke
Success Story

Toyota: Automate HR processes with the Power Platform

To simplify and automate its HR processes, Toyota Germany decided, in collaboration with novaCapta, to add useful workflows and self-service features based on the Power Platform.
Panoramaaufnahme der WENKO Hauptzentrale
Success Story

WENKO: Managing order processes efficiently with Power Apps

By using Power Platform, WENKO has revolutionised its field sales operations: orders are now simply created in the low-code/no-code scan app and transferred directly to SAP.
novaCapta Mitarbeitende im novaCapta-Büro Hannover
Workshop

Workshop: Automate your Workflows with Power Automate

In just one day, you and your team will gain hands-on experience of how to use Power Automate to automate routine tasks and speed up processes.
Service

Process Transformation, Integration & Automation

Using Process Transformation, Integration & Automation to react quickly to market changes and sustainably improve competitiveness.
Blog

Function Composition in F# with Unfriendly Functions

Explore how to handle unfriendly library functions in F# by using wrappers, higher-order functions, or inline solutions to keep pipelines clean and functional.
Google Workspace administration
Produkt 6/18/20

Advanced Admin Features

All functions have been designed to focus on their simplicity and to make, otherwise cumbersome tasks, quickly performable.
Restaurant Gastraum und Kaffeebereich BONVITA Group
Success Story

BONVITA: Ask Chatbot „Bonnie“

BONVITA is committed to digital innovation and has launched ‘Bonnie’, an AI-powered chatbot that helps staff access internal knowledge quickly – simply and efficiently.
Metalloberfläche in Nahaufnahme
Success Story

Aurubis: Automated and secure administration

Aurubis, in collaboration with novaCapta, is using ScriptRunner to standardise administration within the M365 environment and thereby automate routine tasks.
Blog

Using GCP Cloud Functions with F#

Learn how to build and test Google Cloud Functions in F#, using dependency injection, configuration, and pub/sub messaging for real-world cloud apps.
Bürogebäude der Gebäudeversicherung Bern (GVB)
Success Story

GVB: Automated processes for customers and staff

Concluding contracts online and ordering policies – these are now automated processes at GVB. The project was implemented using Power Automate and Power Apps.
Referenz

Managing Vacation, Sick Leave, and Absences with Jira

From catworkx's perspective, there are virtually no limits to the flexible use of Jira applications. A somewhat atypical Jira use case, for which catworkx developed the "Leave Management" app...
Referenz

Managing projects with Confluence and Jira at ASI

In 2016, the IT department of Austrian Standards was given the task of converting 160 systems to a decentralised system in 2 years. catworkx accompanied the successful change in the corporate culture
Referenz

Flexibility in the data evaluation of a theme park

With the support of TIMETOACT, an theme park in Germany has been using TM1 for many years in different areas of the company to carry out reporting, analysis and planning processes easily and flexibly.
Blog

Women's power in IT: A conversation with Sarah

On International Women's Day 2025, our colleague Sarah shares what the motto means to her. She talks about her path to leadership, challenges in IT, and how she experiences equality daily.
Wissen 4/14/23

The "Beautiful five" and the Power of "One-Number" Reporting

Key figures are a perennial favorite in idea management, have been used for many years (decades) and are now very topical again. The reasons are obvious. You want to set performance benchmarks, define targets, follow up on where things are not going so well and measure the success or failure of idea management.
Bild des Werkhofs der Trüb für Grün AG
Success Story

Trüb für Grün: Process optimisation with Teams & Power Apps

With the introduction of Microsoft Teams, Trüb für Grün has not only created a central communication platform, but has also laid the foundations for the development of efficient Power Apps.
panoramic banner. young woman using mobile smart phone for scan and payment online with family budget cost bills on desk in home office, plan money cost saving, investment, finance, expenses concept
Workshop

Power Apps Workshop: Create Business Apps with Low Code

In our workshop, you’ll learn, step by step, how to create custom applications with Power Apps.
Blog

Girl power in IT: a conversation with Sarah about her career

On International Women's Day 2025, our colleague Sarah talks about her journey to becoming a team leader, challenges in IT and how she lives equality in her daily life – inspired by the day's motto.
Digitale Hand mit schützendem Regenschirm – Symbol für Sicherheit in Finanz- und Versicherungsdienstleistungen.
Branche

Insurance

IT solutions for modern insurance companies
Standort

Location in Berlin

Find IPG Information Process Group AG GmbH Germany and CLOUDPILOTS Software & Consulting GmbH in Berlin

Bleiben Sie mit dem TIMETOACT GROUP Newsletter auf dem Laufenden!