web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Duplicating parts of a...
Power Apps
Unanswered

Duplicating parts of a record onto a new record in a new table in dataverse

(0) ShareShare
ReportReport
Posted on by
HI Everyone. 

I have two dataverse tables

Risk - containing all the base dataverse columns plus a variety of other columns such as initial, residual, and true risk scores (true being an automated column for reporting purposes that self populates with initial or residual depending on whether or not the user marks controls as being in place), Risk Owner, Category of risk
 
Issues - containing all the base dataverse columns plus a variety of other columns such as Impact of Issue, Issue owner, Category of issue
 
 
Because risks can become issues if they materialise I am looking for a 1 button solution to move all the key details from the risk, into the issue table. 
And if I am being fancy, Close the risk at the same time. 
 
I have tried using Patch(Risk, Defaults(Issues),but I am having errors related to unexpected variables, 

I'll be honest while I am ok with table, form, and app works, even some basic PCF, the Fx coding for commands doesn't seem to work for me.
 
I have been able to do a copy details to same table as a new entry command  but the act of copying to a new table seems to be illuding me.

Any support would be greatly appreciated.
 
 
Categories:
I have the same question (0)
  • timl Profile Picture
    36,383 Super User 2025 Season 2 on at
    Hi Thomas18,
     
    If you want to create a new record in the Issue table based on an existing Risk record, you need to specify the Risk record that you want to use.
     
    The formula below shows how to LookUp a Risk record based on ID, and shows the syntax to create a new record in the Issue table.
     
    Hopefully, that'll get you started on this.
     
    With({sourceRecord:LookUp(Risks, ID=<the ID of the record you want to copy>)},
         Patch(Issue,
               Defaults(Issue),
               {TargetColumn1: sourceRecord.Column1,
                TargetColumn2: sourceRecord.Column2
               }
          )
    )
     

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard