Fetch a lookup value from model driven app and display in embedded canvas app

[JayashreeKrish]

we are populating CDS table data into embedded canvas app.

Text fields are populating fine using this below formula

ddi_caseidentification: [@ModelDrivenFormIntegration].Item.CaseID,
ddi_casename: [@ModelDrivenFormIntegration].Item.'Case Name',

Is there a way to populate a lookup value from a CDS Table  into a canvas text box? We used the below formula (where ddi_investigatorname is column in table B of text data type  , user lookup is column in table A of lookup data type )

ddi_investigatorname : [@ModelDrivenFormIntegration].Item.'User Lookup'.'Full Name' ( we tried this, this is returning empty)

User Lookup is a column with datatype lookup in our CDS table and related table is "User"

[JayashreeKrish · Accepted solution]

ddi_investigatorname : LookUp(Cases, CaseID = [@ModelDrivenFormIntegration].Item.CaseID).'User Lookup'.'Full Name',

This helped