Using the Patch Command in Power Apps for Parent Child Table Inserts [Episode 32]

Показать описание

in this tutorial, you'll learn how to use the Patch command to take the primary key value from inserting into one table and inject it into a second table. This example is perfect for apps like shopping carts or inventory systems.

Here's the code:

ClearCollect(
colStageCustomer,
Patch(
'[dbo].[Order]',
// Defaults('[dbo].[Order]'),
{OrderID:Blank()},
{
CustomerName: inpCustomerName.Text,
OrderDateTime: Now()
}
)
);

ClearCollect(
colStageOrderLine,
ForAll(
colOrderLineItem,
Patch(
'[dbo].[OrderLineItem]',
{OrderLineItemID: Blank()},
{
OrderID: First(colStageCustomer).OrderID,
ProductID: ProductID
}
)
)
)

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 413-1911

---------

Рекомендации по теме

Комментарии

Where can I find the video where the collect " colOrderLineItem " was created? I've followed all the steps since my scenario is exactly the same (SQL - two tables, parent/ child, ) but I'm missing that piece of information to fully understand the solution. Thanks

blaschkesita

Thank you for the video, it's really cool to have so many options to achieve this. I am using sharepoint in my apps (have no access to real database engines) so I am doing this via Flow, sending the parameters from powerapps.

tenisviejos

Thanks for the video, I am using Azure SQL DB where I wanted to edit customer details and item details all in one screen once changes made need to be updated on different DB. Is it Possible?

ashwinidas

where the colStageCustomer and colStageOrderLine collections created before? Where do they come from? Can you pls clear that part? Than you.

hizke

The data is stored in Azure, is it SQL Server or what is it?
Why don't you use SharePoint Lists in your examples?
Why do you prefer a database?

calbertop

I have a sharepoint list with multiple row, one of the column is a list of communications. One of the other column is call 'Seen by' that will be fill with a 'x' when the communication is seen. How with a onselect button i could add the 'x' in the SeenBy column base on the communications select in a listbox in my app? Thanks a lot

guillaumechandonnet

How can I do this for sharepoint list?

leonghz

Using the Patch Command in Power Apps for Parent Child Table Inserts [Episode 32]

Using the Patch Command in Fusion 360

Using the Patch Command in Power Apps for Parent Child Table Inserts [Episode 32]

Wrap Your Brain around 'Patch' and 'Diff' on Linux

How to use PATCH Function in Power Apps | Insert and Update data

Fusion 360 Patch Workspace Tutorial! FF105

Linux Patch Management || How to Patch Linux OS vulnerability

Linux Command - patch

Power Apps Patch function with SharePoint Columns

Let's fix Generals Zero Hour 0189 - Thyme - unassemblize: Replace getopt.c with cxxopts

The Patch Tool: Does More than You Think | Complete Photoshop Guide

The BEST git command you've never heard of | GIT ADD PATCH

Using Power Apps Patch to Insert and Update (with People Pickers and Choice columns)

Autocad Tutorial How To Use Patch Surface Command

siemens nx tutorials how to use patch command

How to use PATCH coomand in NX || PATCH coomand in NX || NX Tutorial

Create and apply a patch file from git diff

How to use patch command in nx, patch in nx, nx1953 patch, how to apply patch in siemens nx

Patch Openings command in NX

Patch Function in PowerApps | Add/Edit/Update in SharePoint List using Patch Function in PowerApps

How to Use Comm, Diff, and Patch: Linux Terminal 201 - HakTip 169

Linux | Patch Source Files With Diff Files

AutoCAD 3D - How To use Surface Patch Command in AutoCAD | AutoCAD Tutorial | #145

Using the Extract, NURBS and Patch Commands in Altair Inspire

Using the Patch Statement in Power Apps for Teams [Building Power Apps In Microsoft Teams Ep.9]