List-based data model
Lists with lookup columns, required fields, validation, and indexes - set up so that apps and flows work on them quickly and reliably.
SharePoint · Microsoft Lists
Organize your data and documents.
For many companies, SharePoint and Microsoft Lists are the natural data foundation of their Power Platform solutions - they are already included in Microsoft 365. So that this does not turn into a collection of random lists, I plan structure, columns, views, and permissions from the start.
- Lists as a data foundation for apps
- Libraries with metadata instead of folder chaos
- Permissions well thought out and documented
01Use cases
What I use SharePoint & Lists for
Document storage with metadata
Libraries with content types, metadata, versioning, and retention instead of deeply nested folders.
Permission models
Who sees what? Groups, sharing, and - where necessary - item-level permissions, automated with Power Automate.
Connecting Teams and SharePoint
Channels, files, lists, and apps in one place, with clear rules for new teams and sites.
Replacing Excel and network drives
Systematically migrate existing Excel spreadsheets and file storage to SharePoint - with cleanup and a sensible structure.
Views and formatting
Clear views, status colors, and buttons with JSON formatting - often that is enough without a custom app.
02Approach
From the first conversation to a solution in production.
Consulting and implementation from a single source: whoever writes the concept also builds it - with no friction between consultant and developer.
-
Initial consultation
Free and without obligation via Microsoft Teams: What is the challenge, what is the goal, and which licenses do you already have? Afterward, you will know whether and how the Power Platform fits your needs.
-
Process analysis
Together with the people who run the process every day: How does it work today, and where do manual handoffs between systems or media, delays, and errors occur?
-
Solution concept
Data model, screens, flows, permissions, and licensing - in writing, easy to understand, and with a clear effort estimate.
-
Implementation in stages
Short iterations, each with a working interim result. You see early on what is being built and can adjust course.
-
Rollout and handover
Acceptance, deployment to production, documentation, and handover to your team - so the solution does not depend on me.
-
Further development
If you wish, I will continue to support the solution afterward: enhancements, new requirements, and updates from Microsoft.
03Toolbox
Technologies in this area
- SharePoint Online
- Microsoft Lists
- Document libraries
- Content types
- JSON formatting
- SharePoint REST API
- Microsoft Graph
- Permissions
- Retention
- Teams integration
04Real-world projects
Projects in this area. No names, real substance.
As a rule, I do not name clients - their industry, size, and project requirements say enough.
Specialist retailer of fireplaces and stoves with delivery and installationsince 02/2022
Order processing for a stove retailer with Power Apps and SharePoint
For almost five years, I developed the central order processing system for a fireplace and stove retailer with several companies and locations, based on SharePoint, Power Automate, and Power Apps, and I still support it today. Quotes with digital signatures, invoices and payment reminders via sevDesk, Planner tasks, customer surveys with Forms, Power BI, and a mobile installation report on tablets all work together. The solution gave rise to the industry platform FLAMOX365.
more than 50 employees
SharePoint Online (lists and libraries)Power Automate (cloud flows)Power Automate approvalsPower Apps (canvas apps)Forms (customer surveys)
Read case study
Industry06/2026 - 09/2026
Order approval in manufacturing with Power Automate and SharePoint
For a manufacturing company, I implemented a multi-stage approval process for customer orders with Power Automate and SharePoint. Engineering, installation, order management, purchasing, and a second purchasing review handle approvals in sequence; rejections are routed back to the appropriate step with a required explanation. Nine flows, eight SharePoint lists, escalation, and an audit trail form the core system.
Part of a group of companies with more than 12,000 employees
Power Automate (cloud flows)Power Automate ApprovalsSharePoint Online (lists)Office 365 OutlookPower Platform solutions (managed and unmanaged)
Read case study
Metalworking - precision turned and milled partssince 11/2025
Digital quality inspection with Power Apps in precision machining
For a manufacturer of precision turned and milled parts, I designed and implemented a responsive canvas app for quality inspections in production. It determines which inspection characteristics are due for each machine, part, and inspection trigger, evaluates measured values against tolerances, and stores the results in an auditable form in SharePoint, with versioning and restricted editing rights. In addition, I advise on migrating an existing production app that has evolved over time into separate environments.
more than 100 employees
Power Automate (cloud flows)Power Apps (canvas app, responsive design)SharePoint OnlineAzure SQLEntra ID and Microsoft 365 groups
Read case study
01/2019 - 03/2022Implementation
Distribution of ultra-fresh food
more than 4,500 employees · more than 2,500 locations in 7 countries
Building a central data foundation on Microsoft Dataverse and Dynamics 365, developing model-driven and canvas apps for location and quality management, and automating processes that affect revenue, such as multilingual online ordering and a delivery service, with Microsoft Power Automate, Web API, and Graph API. In addition, customer feedback with Customer Voice and Power BI, as well as training.
more than 200 automated flows - partially automated maintenance of data for more than 1,000 locations
- Dataverse
- Dynamics 365
- Power Automate (cloud flows, desktop flows)
- Power Apps (model-driven, canvas)
- Web API
- Graph API
- Power BI
- Customer Voice / Forms
- SharePoint Online
07/2023Consulting
Facade construction (metal)
around 300 employees, group of companies with around 500 employees · internationally active group with several production sites
A mid-sized facade builder manages production and shipping with several canvas apps on tablets, using SharePoint lists as the data foundation. I analyzed the apps and formulas and developed recommendations on performance, data integrity, usability, and the unambiguous mapping of ERP data.
- Power Automate
- Power Apps (canvas apps)
- SharePoint Online (lists)
- Power BI
06/2023 - 12/2023Consulting
Manufacturer of shading systems
more than 5,000 employees · international sales
For a manufacturer of shading systems, I supported the rollout of the Power Platform. I developed an environment strategy with sandbox and production environments, gathered the first use cases from the business units, and equipped business users to implement a use case of their own.
- Power Platform admin center (environments, security roles)
- Entra ID (security groups)
- SharePoint Online (lists)
- Power Automate (cloud flows, approvals)
- Power Apps (canvas apps)
- Forms
- Teams
05Questions and answers
Frequently asked questions
SharePoint or Dataverse - which is better?
For many departmental solutions with manageable data volumes, SharePoint is ideal: it is included in Microsoft 365 and quick to set up. Dataverse is particularly well suited to complex relationships, large numbers of records, fine-grained permissions, data-level business logic, and model-driven apps, but it requires premium licenses. I make a recommendation based on your requirements.
Where does the 5,000-item limit apply?
The well-known threshold of 5,000 items limits certain views and database operations, not storage: a list can contain up to 30 million items. Indexed columns with sufficiently restrictive filters, filtered views, and delegable queries in Power Apps help keep even large lists usable within the limits.
Can you clean up existing SharePoint structures?
Yes. I document the current state, propose a target structure, and migrate step by step so that day-to-day operations are disrupted as little as possible.
Your process. My solution.
Tell me where things get stuck today - in a free, no-obligation initial consultation via Microsoft Teams, we will clarify what the Power Platform can do for your process and what a sensible first step looks like.