SmartLearningAI

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:...

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...