web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Change title column of...

Power Apps

Unanswered

Change title column of lookup field when selected in other table

(0) Share

Report

Report

Posted on by jorenchristiaen

52

Hi everyone,

In my model driven application I have a table workorder and a table Machine.

Machine has a machine Number and a name.

Workorder has a lookup field of table Machine.

When i select my machine in the workorder screen then i can see the name of the machine and not the number.

Can i change this in any way?

See screenshot below for a visualisation of my problem.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Jose Ramon 107 on at

Like (0)

Report
Copy link

Link copied!
You will have two options, you will have to evaluate which one best suits your needs, as the Lookup will show you the name of the machine, not the name and number.
Create some flow or plugin or javascript, so that when a new machine is created or the name or number is updated, the name field has the concatenation of the machine name and the number.
Create a JavaScript for the onchange event of the existing lookup in the WorkOrder table, so that when a new machine is selected, make a query to obtain the selected machine (returning the name and number) and then, with the value obtained, modify the name property of the lookup.

let machineColumn = formContext.getAttribute("new_machineid"); let machineValue = (machineColumn === null) ? null : machineColumn.getValue(); //Retrieve machine row: Xrm.WebApi.retrieveRecord("new_machine", machineValue) machineValue[0].name = 'VALUE WITH RESULT OF Xrm.WebApi with name + number' machineColumn.setValue(machineValue);

Was this reply helpful? Yes No

Join the conversation