Unanswered

Display lookup field text from D365

(0) Share

Report

Posted on by sdnd2000

173

Hi, I am looking to search one entity in D365 through business number, and display account or contact field text and managing entity text on gallery, however, it is difficult to display since the two fields are lookup fields, please advise.

Screenshot 2022-03-18 133203.jpg

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @sdnd2000 ,

Are you trying to get the output in Model-Driven App or Canvas App.

Let's say it is Model Driven App,

If you want to store the Text Values of the Lookup, write JS/Plugin/Field-Map to achieve this.

In-case, you don't want to store value in text field but want text value of lookup. JS will help, use formula as

formContext.getAttribute("<attributeName>").getValue()[0].name;

Let's say its Canvas App,

If the Lookup Name already has Text value, you will get directly.

If you need some different Text Value, then use <Field>.Name. This '.' operator will access the fields within that entity/table

Hope this is understandable

Was this reply helpful? Yes No
sdnd2000 173 on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R
It is canvas app, I got the below error with the formula, the same error with managing entity.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (1)

Report
Copy link

Link copied!
Yes @sdnd2000 ,

ThisItem.'Account or Contact' is your Lookup Field

Now use '.' operator and access all the fields within 'Account or Contact' Table.

ThisItem.'Account or Contact'.Name or ThisItem.'Account or Contact'.Status

and so-on...

Hope this helps

Was this reply helpful? Yes No
sdnd2000 173 on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R
Sorry, 'Account or Contact' is a customer field in D365, while 'managing entity' is a lookup, and there is no other field after "."

Was this reply helpful? Yes No
sdnd2000 173 on at

Like (0)

Report
Copy link

Link copied!

@Ethan_R
Any ideas?

Was this reply helpful? Yes No