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?
Solved! Go to Solution.
I should be able to help you out with any embedded canvas app issues.
One simple question before we get started though: have you tested this app from within a model-driven app form or are you just expecting to see values within the editor? Embedded canvas apps need not necessarily show values within the editor (most of the time they display values for the 1st record of the entity that the embedded canvas app is tied to).
So let's get this out of the way first. If it still doesn't work, I have another way that I think should make it work but let's hear back from you first.
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand