SmartLearningAI

  Knowledge shared is power squared! Microsoft Power Apps documentation: Discover how to make the most of Power Apps with online training courses, docs, and videos covering product capabilities and how-to articles. Learn how to quickly build low-code apps that modernize processes and solve tough business challenges in your organization using Power Apps  *power-apps maker | Microsoft Learn   The power platform and power apps are amazing tools that finally allow citizen developers to create solutions and innovate using low-code/no-code tools often without the "evil corporate IT" environment that wants to block everything and make us wait forever and charge a fortune...  "Heck, If I have to pay IT to be blocked and wait forever, I can find other ways to get stuff done...." Inviting all Power Apps Makers to create, learn, share, and connect! Join our Power Apps Community on Discord for free and discuss all things Power Apps!   

This article is a quick overview of the process of making an ORDER & ORDERDETAIL  Clone button in one Action. When the user clicks on the Clone  button, the system will automatically create a copy of the order with all the related orderdetail (line items). This in the context of Model-Driven Power Apps using Dataverse and Power-Fx low-code tools. Prototype ERD for this Order Entry System Visit https://online.visual-paradigm.com/ if you want to use this tool  Now, Let's make a custom command bar button Start Here: make.powerapps.com Make a new command bar, command button, on the command bar. Then, on the Main Form using Power Fx formula below, we will build a Clone function that not only Clones the Parent Order Record but also the related Child OrderDetails (line items). It also sets the OrderDate to the current date.  Model-Driven Apps: Modern Command Bar Customization  Credit to Scott Durow for the original version. Below is modified version. (Link:   https://youtu.be/Jq2GLgNE

Model-Driven Apps: Modern Command Bar Customization SOURCE: Credit to Scott Durow Link:   https://youtu.be/Jq2GLgNEcp0?si=K4xodRYmI_fvjNVd Summary of Topics: ✨How to clone a record including child records Note: Instead of editing the fx formula directly, select ... Edit next to Table Name, Edit Command Bar Form and +New Command called 'Clone' and give it the Clone icon. OnSelect FX formula can be edited easily via the Component Library (similar to Canvas App experience). The trick is to use the With syntax to also clone the child records for the Purchase order line item in this example! 1) Create a Clone Button: 2) Action: Run formula (fx open formula bar), Save and Publish 3) Open component library and edit your fx formula their (easier) and similar to canvas app designer 4) First, We can make the formula just copy the Parent record, then enhance it for child records later This will make a copy of the entire parent record. Optionally you can select just certain fields. or