Working with Lookup block – Dynamics 365 CE – Nishant Rana’s Weblog

Let us continue with our previous post in which we created a solution to pull data from SQL On-Premise and create lead records in Dynamics 365.

Let us create a new table which will be our source here.

Table Name – Transaction

2 columns – ID and Brand.

Transaction and Brand have n -1 relationship i.e. Transaction record have a Brand lookup field in it.

The brand value will be used for two things here.

• We’d set the Brand lookup field based on its text.
• The brand record has another…