As we continue working with PowerApps, Power Automate, and Dataverse, I wanted to share some practical tips for those new to using Power Automate with Dataverse. Today, we’re focusing on handling Lookup Columns, which can be a bit tricky if you’re unfamiliar with their nuances.
Handling Lookup Columns in Dataverse
Unlike SharePoint or other data sources, Dataverse Lookup Columns operate differently. If you try to update a lookup field using just the ID in Power Automate, you might encounter errors and your flow could fail.
How to Update Lookup Columns?
To update a lookup column in Dataverse, you need to use the following format.
Contacts(83c259e2-1039-4110-af70-79f353dc92a5)
![Update]()
Here’s a breakdown of what you need to do.
- Specify the Dataverse table name: For example, "Contacts".
- Include the GUID: This is the unique identifier for the record you want to link to.
When configuring the Add New Item or Update Action in Power Automate, make sure to use the source table name followed by the GUID of the lookup record. This approach ensures that your lookup columns are updated correctly without causing errors.
Hope this tip helps streamline your Power Automate flows with Dataverse.
For more updates, connect with me on LinkedIn