Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
🌸May 8th | You're Invited: Community Spring Festival Awards Celebration🌸
May 14th | Power Platform Community AMA: Power Apps Edition
News and Announcements icon
Community site session details

Community site session details

Session Id : w8BJddA3e8QbCLQffoTIeN
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Copy value from field1...
Power Apps - Microsoft Dataverse
Unanswered

Copy value from field1 to another field2 d365

Like (0) ShareShare
ReportReport
Posted on 2 Nov 2022 16:18:25 by CrmUser101 180


‘Hello,

 

what is best way to copy field1 value to field2 for all records?

I have created field2 and I am going to delete field 1 after copying to field2.

 

 

Thanks,

 

Categories:
Microsoft Dataverse
Entities
Tables
  • Fubar Profile Picture
    Fubar 7,860 Super User 2025 Season 1 on 02 Nov 2022 at 22:10:05
    Re: Copy value from field1 to another field2 d365

    The answer may depend on how many records you need to process and your technical ability, some options

    • Create view with only the 2 columns in it, Export to Excel, copy Column to the other Column and then import as an update
    • Create a workflow or Flow (approach and how this is done may depend on how many records, due to the default record limits)
    • Write some custom code
    • Use other tools such as XrmToolBox or SSIS, or others
  • Mira Ghaly Profile Picture
    Mira Ghaly 11,409 Super User 2025 Season 1 on 02 Nov 2022 at 20:12:53
    Re: Copy value from field1 to another field2 d365

    @Shafdev 

    You can try creating asynchronous process ,then use xrmtoolbox to run the process on all records using Bulk workflow execution 

    https://www.xrmtoolbox.com/plugins/AndyPopkin.BulkWorkflowExecution/

     

     

     

     

  • a33ik Profile Picture
    a33ik 3,304 Most Valuable Professional on 02 Nov 2022 at 18:12:48
    Re: Copy value from field1 to another field2 d365

    Hello,

    I would say you can try XrmToolBox and SQL4CDS plugin and write an update statement.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
🌸May 8th | You're Invited: Community Spring Festival Awards Celebration🌸
May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#2
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 9

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans