Please see the screenshots, I used the following examples from previous messages and Microsoft guides and any variant that I could think of:
LookUp(Accounts, Account = GUID(First(ModelDrivenFormIntegration.Data).ItemId)).'Primary Contact'.'Full Name'
LookUp(Accounts, Account = ModelDrivenFormIntegration.Item.Account).'Primary Contact'.'Full Name'
I have an embedded a canvas app for Work Order entity and every Work Order has a Vessel associated with it. I am aware that I can retrieve any field from the work order, except the lookup fields and vessel is a look up field in the Work Order record. Please see embedded 3 screenshot, where I am trying to retrieve the vessel identifier. I have entered the formulas given as examples, but they give me errors - I thought it may be because its a list of items (which by the way show if I click on the dropdown) , so I added a label and entered the following:
LookUp('Work Orders','WO Number'=[@ModelDrivenFormIntegration].Item.'WO Number').'Service Account'.'Account Name'
As you can see in attachment, I have no errors but no value is returned. No matter what field from the vessel entity I am trying to retrieve , the results are the same. I attached another example with no lookup: [@ModelDrivenFormIntegration].Item.Vessel.'Hull Number'
I know answers have been provided in previous posts and even guidance from Microsoft, but it does not work for me....
What should I do?
WarrenBelz
285
Most Valuable Professional
MS.Ragavendar
146
stampcoin
130