Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Suggested answer

Get Parent Record Link Using Patch Function

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
Dear All, 
 
Hope you are doing well! 
 
I am using Patch function to copy / clone records for Command Bar in Main Form and further it requires to have a Parent/ Current record URL which will be populated under Custom Column (Parent Link -Text Field Column) in Cloned record. Please advise for next steps that will populate Parent Record Link under Cloned record custom Column using Power FX query.
 
Power FX Formula:
 
Patch('Accounts',Defaults('Accounts'),
{Name:"Copy of" & ThisRecord.Name});
 
Thanks & Regards
Categories:
  • Suggested answer
    Gabriel G. Profile Picture
    724 Super User 2025 Season 2 on at
    Get Parent Record Link Using Patch Function
    Hi there!
     
    My suggestion is to create a Formula column containing the parent Name (hidden). Then, in your Command bar formula, you simply get your FX field and apply it to your record Name:
     
    Patch(
        'Accounts',
        Defaults('Accounts'),
        {
            Name: Self.Selected.Item.NewFXField
        }
    )

    I hope it helps!
    ________________________________________________________________________
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics