Click here to Skip to main content
15,664,272 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I created a flow which imports records from the SQL table "Movies" to the entity "CrmMovies" in a Dynamics CRM Source.

"CrmMovies" has a lookup field "collectionID"

The SQL table "Movies" doesn't have a foreign key "collectionID", but I added a Lookup transformation block so that input data will match with the records of another SQL table "Movies 2", which contains the field "collection name" too.

What I want to achieve is to set the field "collectionID" in "CrmMovies" depending on whether the input movies are linked to a collection, and then export all data to "CrmMovies". As a final result, the movies not connected to a collection will have the corresponding lookup field set to Null.

What I have tried:

I designed the flow as follows:

The blocks "Collection not null" is a Derived Column, I'm not sure if it's a good choice and how I should create the expression in order to achieve my goal.

I set the Lookup block as follows:
Updated 22-Jan-21 6:29am
Gerry Schmitz 14-Jan-21 10:29am    
This is a Dynamics CRM question.
xhon 22-Jan-21 12:29pm    
Hi, ok, I corrected the tags, thanks.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900