Populate lookup column in dynamics 365 ce

[Shaxa]

Hi,

I am using copy activity in fabrics pipeline . My source is fabrics warehouse , destination is dataverse . I am trying to populate column called fm_transaction in Transaction Line Item , which is related to Transaction table . 

My query is  :

SELECT

    tli.*,

    CASE

        WHEN fm_transaction IS NULL THEN NULL

        ELSE '/fm_transactions(' + CAST(fm_transaction AS NVARCHAR(100)) + ')'

    END AS 'fm_transaction@EntityReference'

FROM dbo.TransactionLineItem tli

Mapping : 

fm_transaction@EntityReference - fm_transction@EntityReference

I have remove column which is directly populate GUID ( fm_transaction) from mapping  , it cause issue . Before i was able to acoomplish this in ADF using @odata.bind , but here pipeline runs successfully but lookup column still empty ,however related table has value .

[v-menakakota]

Hi @Shaxa ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience, after reviewing the issue of the pipeline runs successfully but the lookup column in Dataverse is still empty, here are a few things worth double-checking:

 In your mapping, there’s a small typo,  it looks like you wrote fm_transction@EntityReference instead of fm_transaction@EntityReference. Just adding that missing “a” can make a difference, so be sure to correct it.

In the reference string you’re building (e.g., /fm_transactions(GUID)), make sure the table name matches the actual plural name of the Dataverse table ,exactly as it appears in Dataverse, including casing.

Since you're already using the @EntityReference format, make sure the original fm_transaction GUID column isn’t included in the mapping. Having both can confuse Dataverse and prevent the lookup from being set.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.