How to Set Lookup Columns in Dataverse Using Dataflows | Power Platform Data Migration Tutorial

Learn step-by-step how to set lookup values and alternate keys in Microsoft Dataverse using Power Platform Dataflows — a must-know skill for anyone doing data migration, environment deployment, or integration between environments. In this in-depth tutorial, Microsoft MVP Nathan Rose walks you through: Creating alternate keys in Dataverse tables Using existing GUIDs to maintain record integrity across environments Deploying solutions with Power Platform Pipelines Using Dataflows to populate lookup columns in your target environment Two proven methods for linking related tables with lookups Whether you’re working with Dynamics 365, Power Apps, or Power BI, this walkthrough will help you understand how to manage relational data at scale in Dataverse — without writing a single line of code. 💡 Perfect for: Power Platform solution architects, data migration specialists, and makers who want to avoid common Dataverse lookup and GUID pitfalls. 🔗 Tools Used: Microsoft Dataverse Power Platform Maker Portal Power Platform Pipelines Dataflows Model-Driven Apps 👍 Like this video if it helped you, and subscribe for more Power Platform deep dives, tutorials, and agentic AI demos! ⏱️ Chapters 00:00 – Introduction: Why Dataflows are awesome for data migration 01:05 – The challenge: Setting lookup columns in Dataverse 02:10 – Understanding alternate keys and why they matter 04:30 – Creating alternate key columns in your tables 07:15 – Populating alternate key values using Dataflows 10:50 – Configuring merge vs. append in Dataflows 13:30 – Using GUIDs as alternate key values 16:10 – Deploying solutions to target environments 18:45 – Setting lookup values in the target environment 22:30 – Verifying GUID preservation after migration 25:00 – What to do when lookups don’t populate automatically 29:10 – Method 1: Linking related tables via alternate keys 33:40 – Method 2: Merging queries to map lookup relationships 38:00 – Testing and verifying lookup relationships in target Dataverse 40:30 – Recap: Keys, Dataflows, and deployment best practices 42:00 – Shout-out to Rami Mounla & closing thoughts