web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Not able to access the...

Power Apps

Answered

Not able to access the relation using the ModelDrivenFormIntegration for the Lookup type

(0) Share

Report

Report

Posted on by DT-29040811-0

9

Any help would be appreciated here.

Trying to get the Field value of the Lookup type Entity (Account) through the ModelDrivenFormIntegration (Opportunity) in a Canvas App.

LookUp(
Accounts,
Account = [@ModelDrivenFormIntegration].Item.Account.Account,
AccountName
)

When trying this, able to access "AccountName" in the editor of Canvas App.

However, when i Saved and Published it, not able to get the same value in the Unified Interface of DY.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

DT-29040811-0 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Got the solution.
Issue was ModelDrivenFormIntegration control does not provide a value for fields of a related entity.
But, don't know why it was showing the value in Canvas Editor.
However, if someone got stuck in same situation, then, he needs to follow little bit different approach:
LookUp(
Opportunities,
Opportunity= [@ModelDrivenFormIntegration].Item.Opportunity
).Accounts.Name

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rahulshukla ,
We tried the same approach with 'Work Order' table and we want to get the Display Name of 'Customer Assets' which is present in relational table of 'Work Order'.

Below is the formula that we are applying

LookUp( 'Customer Assets', 'Customer Asset'=[@ModelDrivenFormIntegration].Item.'Primary Incident Customer Asset'.'Customer Asset' ).Name

"[@ModelDrivenFormIntegration].Item" refers to Work order table.

We are able to see the Customer Asset's name in Canvas app but it is not reflecting in D365 Field Service.
Can you please help us if we are missing any step here?

Was this reply helpful? Yes No

Join the conversation