You’re offline. This is a read only version of the page.
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
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)
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.
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?
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (