Trascritto
Power Apps Excel Data: The Power Apps Lie That Breaks Your Excel Data
26 nov 2025 ·
25 min. 16 sec.
Scarica e ascolta ovunque
Scarica i tuoi episodi preferiti e goditi l'ascolto, ovunque tu sia! Iscriviti o accedi ora per ascoltare offline.
Power Apps Excel Data: The Power Apps Lie That Breaks Your Excel Data
Capitoli
Descrizione
In this episode of M365.fm, Mirko Peters explains why clicking “Create app from Excel” feels smart for the first week and becomes a data‑integrity horror story once real users arrive....
mostra di più
In this episode of M365.fm, Mirko Peters explains why clicking “Create app from Excel” feels smart for the first week and becomes a data‑integrity horror story once real users arrive. Excel isn’t a database — it’s a calculator pretending to be one — and the moment you plug it into Power Apps, Dataverse exposes every hidden flaw: no keys, mixed types, fake relationships, duplicate entities, orphaned rows, and silent corruption spreading behind the scenes.
WHAT YOU WILL LEARN
This episode is ideal for Power Apps makers, citizen developers, Power Platform admins, and data‑savvy business owners who have already built (or are about to build) apps on top of Excel files in SharePoint or OneDrive. If you’re dealing with inconsistent behavior, failing imports, broken lookups, and automations that only work “on some rows,” this episode gives you a clear blueprint to remodel your data correctly and migrate to Dataverse before the next failure hits.
ABOUT THE HOST
Mirko Peters is a Microsoft 365 consultant and digital workplace architect who helps organizations move from spreadsheet‑driven operations to governed, scalable platforms on Power Platform, Dataverse, and Fabric. Through M365.fm, Mirko shares practical migration stories, data‑model patterns, and governance approaches that help IT and business teams replace fragile Excel “systems” with resilient, auditable applications that can stand in front of an auditor — and survive.
Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.
mostra meno
WHAT YOU WILL LEARN
- Why Excel feels fine for small tasks but fails as soon as Power Apps expects structure
- The five failure patterns that quietly destroy Excel‑backed Power Apps: missing primary keys, mixed data types, VLOOKUP “joins,” multi‑purpose columns, and orphaned rows
- How to design proper primary keys with surrogate GUIDs and alternate keys so imports, upserts, and automations stop duplicating or overwriting the wrong records
- How to normalize data types (numbers, currency, dates, choices, lookups) so formulas, logic, and reports behave consistently instead of breaking on “weird” values
- How to replace fragile VLOOKUP‑style relationships with real Dataverse tables and lookups for suppliers, locations, categories, and more
- How to split overloaded “Status/Notes/Flags” columns into clean, governed fields so your app can actually validate, filter, and automate reliably
- How to prevent and repair orphaned records by enforcing relationships, using “Unknown X” rows intentionally, and modeling delete behavior correctly
- A practical 12‑step remediation path you can follow to fix your Excel model, move it into Dataverse, and stop your Power Apps from corrupting data in production
This episode is ideal for Power Apps makers, citizen developers, Power Platform admins, and data‑savvy business owners who have already built (or are about to build) apps on top of Excel files in SharePoint or OneDrive. If you’re dealing with inconsistent behavior, failing imports, broken lookups, and automations that only work “on some rows,” this episode gives you a clear blueprint to remodel your data correctly and migrate to Dataverse before the next failure hits.
ABOUT THE HOST
Mirko Peters is a Microsoft 365 consultant and digital workplace architect who helps organizations move from spreadsheet‑driven operations to governed, scalable platforms on Power Platform, Dataverse, and Fabric. Through M365.fm, Mirko shares practical migration stories, data‑model patterns, and governance approaches that help IT and business teams replace fragile Excel “systems” with resilient, auditable applications that can stand in front of an auditor — and survive.
Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-a-microsoft-mvp-podcast-by-mirko-peters--6704921/support.
Informazioni
| Autore | Mirko Peters (M365 Consultant) |
| Organizzazione | m365 FM |
| Sito | www.m365.fm |
| Tag |
Copyright 2026 - Spreaker Inc. an iHeartMedia Company
Commenti