From Microsoft Forms to Fabric – how surveys get into reporting automatically

Five surveys on the company anniversary, different fields - one central solution: Microsoft Fabric and Power Platform are used to automatically merge and visualize the data and make it editable directly in reporting.

Customer

Customer benefits

Technology stack

"The new solution allows us to keep an overview at all times - and saves us a lot of time and effort when planning our company event."

Challenges of the customer

For a company anniversary, guests were invited via five different Microsoft Forms surveys – depending on the language, target group and event day. The surveys had different structures and some contained individual fields.

Manual evaluations would have been time-consuming, error-prone and not up to date. There was also a desire to be able to process registrations retrospectively – for example, in the event of transposed numbers or last-minute changes.

The goal was a flexible, automated solution: all login data should be consolidated, up-to-date and directly changeable in reporting – with maximum transparency.

Our approach

Together with the customer, a solution was developed that was immediately ready for use – and remains reusable in the long term.

Planning & Architecture

At the beginning, requirements, data sources (Microsoft Forms, SharePoint) and use cases were analyzed. The result: a two-tier data model based on Microsoft Fabric that can be flexibly expanded.

Data connection & consolidation

All forms were automatically connected to SharePoint using Power Automate. The data was regularly updated in Microsoft Fabric, stored in a lakehouse and standardized using flexible mapping.

Dynamic processing & change history

An EAV model (Entity-Attribute-Value) enables the consolidated storage of responses including processing history. Changes do not overwrite original data, but are saved in a versioned format.

Editing function with Power Apps

A Power App has been integrated into Power BI that allows individual fields to be edited directly in the report - without premium licenses for all users. For example, participant numbers or names can be corrected live.

Visualization & acceptance

The final report interface was coordinated and approved together with the customer. Metrics such as registration status, duplicates and average completion time can now be viewed at any time.

Results for the customer

Automated data update

0 %

Processing time of individual responses in the live system

< 0 min

Further results:

Do you have a specific project in mind?

Your decision would be the same as that of renowned companies:

Similar case studies

Case studies Switzerland, Data analytics, Process automation

Central event and survey platform: automated processes, live data and maximum efficiency

Inconsistent tools, manual exports and limited survey functions slow companies down. With an integrated event and survey platform, jovoco creates automated workflows, flexible logics and real-time data for more efficient event management.

Case studies Switzerland, M365

Office migration to 64-bit: stable applications, tested VBA compatibility and future-proofing

Smooth migration to 64-bit Office: jovoco checks VBA, add-ins & database connections and ensures the functionality of all applications.

Case studies Switzerland, Data analytics

Centralized logging with Kafka – transparency, efficiency and fewer outages

Distributed log files delay troubleshooting and increase downtime. With a central logging system based on Apache Kafka, jovoco creates transparency, accelerates analyses and reduces development and operating costs.