Update or Set lookup fields in Logic Apps

| Muhammad Hassan

Logic Apps is a service which allows a technical person to automate their business processes using a visual design interface. This automation may include integration with other Saas Products, third party apps, web, mobile and API apps. This integration is achieved through connectors and actions offered by Logic Apps. Today we are going to discuss the dataverse connector and how we can set or update lookup fields in Logic Apps.

For our demo, I’m using an entity called ‘Broker Licenses’ which has a lookup of Contact entity. To set this lookup field we just need to send the guid of that Contact record.

update or set lookup fields

And it’s successful.

update or set lookup fields

This was a simple scenario but things are a bit different when setting partylist kind of lookups. To show this we will use the owner field.

update or set lookup fields

This has failed because the owner field is a partylist field and it can be of type teams or systemusers. Therefore, we need to define the type as well. Whenever we are working with partylists we need to define their types as well apart from the guid.

update or set lookup fields

Now that we have defined the type it will now be successful.

update or set lookup fields

update or set lookup fields

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.

Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.

More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting