Unanswered

Is it possible to move a group of columns(fields not just data) from one entity(table) to another?

(0) Share

Report

Posted on by KRees

We are setting up our CRM and would like to condense the entities, so would like to move the columns, and there are many, from one table to another? For example: Move Field A & B from Table 1 to Table 2.

Table 1

Field A

Field B

Table 2

Field C

Field D

Any advice would be much appreciated

Many thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Gowri Halan 262 on at

Like (0)

Report

@Xch21 Are you trying to copy the column definition and data from one table to other? I think column definition cannot be copied.

Was this reply helpful? Yes No
adgkred 228 on at

Like (0)

Report

Hey @Xch21,

Although coping column definition isn't an out-of-the-boy functionality, I'm pretty sure it could be done with the help of XRM Tool Box, as they have a Clone Field Definition Plugin.
Hope it helps.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Xch21, If Table 1 and Table 2 have a unique identifier, you can use the Dataflows to accomplish this. You will need to setup an alternate key in the Table 2 and then create a DataFlow to load the needed columns from Table 1 and when you do that, make sure to assign the Alternate key.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

KRees on at

Like (0)

Report

Hi @AhmedSalih
Thanks so much for your reply. I did look at Dataflows but couldn't quite get how to connect Dataverse to Dataverse, sorry I'm pretty new and feeling my way around. Each table has a unique identifier but I'm not sure on how to set up an alternate key. If you get a chance would you be able to explain how to do this?
Much appreciated

Was this reply helpful? Yes No