Display column from related table on Form

(0) Share

Report

Posted on by 365-Assist

2,327 Moderator

I have 2 Dataverse Tables.

Requests

- Request Name (Text)

- Request Type (Lookup)

Request Types

- Request Type Name (Text)

- Request Description (Text)

Do you know a way I can display the Request Definition field (From Requests Type table) to show on the Requests Form.

Here is a mocked up screen to show what I want.

Categories:

Microsoft Dataverse with Power Apps

All responses (5)

Answers (1)

Sort by

Ram Prakash Duraisamy 5,891 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @365-Assist,

You need to use Custom JavaScript to achieve this type of Behavior

function getDescriptionField(executionContext){ var formContext = executionContext.getFormContext(); Xrm.WebApi.online.retrieveRecord("REQUEST ENTITY TYPE LOGICALNAME", formContext.getAttribute("REQUEST TYPE FIELD LOGICALANME").getValue().replace("{","").replace("}",""), "?$select=REQUEST DESCRIPTION FILD LOGICALNAME").then( function success(result) { formContext.getAttribute("DESTINATION ENTITY FIELD LOGICAL NAME").setValue(result["REQUEST DESCRIPTION FILD LOGICALNAME"]); }, function(error) { Xrm.Utility.alertDialog(error.message); } ); }

As we are using inside Form it will be good to go with Async Call.

You need to write this Script in OnChange Request Type Field.

My Youtube Video for Step by Step behavior on how to Write JS : https://www.youtube.com/watch?v=x8kYNCkikgs&t=14s

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @365-Assist ,

Since the Requests table has a lookup column to the Request Types table you can utilize a Quick View Form to display any columns from the Request Types table on the Requests form. Please see the following for details: https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-edit-quick-view-forms
Ram Prakash Duraisamy 5,891 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @dpoggemann,

Yes you are perfectly correct 🙂

@365-Assist : You can use quick view form to display data without script. if you want to retrive value from script you can use below code

https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Retrieve-Quick-View-Value-using-JavaScript-in-Dataverse/ba-p/1391689
Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @rampprakash ,

It is actually Quick View vs. Quick Create 😀. Microsoft and their names...
Ram Prakash Duraisamy 5,891 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @dpoggemann

Alteration done ✅