Microsoft Dynamics 365 | Integration, Dataverse...

How to add a column from another table to a view in another table (and with correct mapping of values)

(0) Share

Report

Posted on by JYSSB7 Microsoft Employee

Right now I have two entities, let's say Entity A and Entity B.

I want to create a new column in Entity B with the values from an existing column in Entity A (a lookup field?), mapped by a common unique id column that both Entity A and Entity B have.

For example:

If Entity A contains a columnA that has unique IDs, and a columnB that has any random values.

And Entity B contains a columnC that has the same unique IDs as columnA.

I want to create a new columnD in Entity B that is a lookup to columnB from Entity A, using columnA and columnC as the mapping keys.

This seems like a very straightforward thing but I can't figure out how to do it and I could not find any answers online.

In SQL it would be a basic JOIN command to do this but I need to know how to do this on dynamics make.powerapps

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi JYSSB7,

Which app are you using, Sales Hub or something else? If you are using model-driven app, I think this is easy to achieve. You could add a Lookup field on Entity B which is related to Entity A. And then you could create a workflow to map the value of columnB from Entity A to the columnD on the Entity B. Something like this blog: Dynamics CRM Workflow: Mapping Data Between Fields - Ledgeview Partners

Was this reply helpful? Yes No
JYSSB7 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It seems to me this is a one time thing that copies all the existing data, correct? Meaning new entries created in the future won't get copied automatically to the view, correct?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi JYSSB7,

No, it would keep working until you deactivate it or delete it. When you trick record is created, it would map that value to your Entity B when you create new Entity B record.

Was this reply helpful? Yes No
JYSSB7 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I'm following the link you sent and it seems to only be able to update the Form, I'd like to update the columns in a View, is this possible?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi JYSSB7,

This would also update columns in the view. Actually, it would change the value of columns on the Server and both views and forms get these columns' value from Server.

If the columns aren't updated in the view, please refresh your bowser to have a try.(Clear the cache would be better)

Was this reply helpful? Yes No