Power Automate set Dataverse Lookup on Alternate Key (Use another column instead of GUID)

Опубликовано: 08 Апрель 2026
на канале: Sean Astrakhan
3,916
37

Tired of dealing with long GUIDs when setting lookup fields in Dataverse? In this video, I’ll show you how to set a lookup using another unique column—like an SQL ID—instead of the default GUID.

Free Solutions Architect Training:
https://www.untethered365.com/freetra...


You’ll learn step by step how to:
✅ Create an alternate key in Dataverse
✅ Use the logical name of your column (not the schema name!)
✅ Format your expressions correctly for text or numeric fields
✅ Build a cleaner, more maintainable Power Automate flow

Whether you’re integrating data from another system or just want to simplify your lookups, this approach makes your flows easier to read and maintain.

🔗 Watch now to streamline your Dataverse automations!

#PowerAutomate #Dataverse #Dynamics365 #AlternateKeys #Automation