Trying to patch a nested gallery as an Edit page and having issues getting the patch to work with the ForAll

(0) Share

Report

Posted on by scottmcnitt

241

This is an edit page to linked records from two lists.

gallery1 list patches correctly

gallery2 is the items gallery with multiple items involved and will not patch

Here is the update button for the second gallery. I am trying to match the IDs from the list:

ForAll(colEditItems,
Patch('CP-ITEMS', LookUp('CP-ITEMS', ID = ID,
{
itemName: tiEditRequestsItemName.Text,
itemDesc: tiEditRequestsItemDesc.Text,
LUvendorName: {Id: LookUp('CP-VENDORS', vendorName = cbbEditRequestsItemVendor.Selected.vendorName).ID,
Value: cbbEditRequestsItemVendor.Selected.vendorName},
qty: Value(tiEditRequestQty.Text),
LUuom: {Id:LookUp('CP-UOM', unitOfMeasure = cbbEditRequestsItemUom.Selected.vendorName).ID,
Value: cbbEditRequestsItemUom.Selected.vendorName},
pricePerUom: Value(tiEditRequestPricePer.Text),
itemUrl: tiEditRequestItemUrl.Text,
itemNotes: tiEditRequestsItemNotes.Text,
itemNetAmount: Value(lblCPREditItemAmount.Text)
}
)
)
);

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @scottmcnitt ,

What is the Items property of both the main and nested galleries (how are they linked ?)
scottmcnitt 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Main:
Items > galRequestsMain.Selected

Nested:
Items > Filter('CP-ITEMS', LUmID.Value = galRequestsMain.Selected.ID)

They are linked with LUmID on the Items List which is the same value as the ID from Master.
scottmcnitt 241 on at

Like
a
(0)

Report
Copy link

Link copied!

Right now OnVisible properties of the screen we are collecting the IDs
ClearCollect(colEditItems, Filter('CP-ITEMS', LUmID.Value = Text(galRequestsMain.Selected.ID)))

and the Update button is as follows:
Patch(
'CP-MASTER',
LookUp('CP-MASTER', ID = Value(lblEditRequestID.Text)),
{
LUreceivingDepartment: cbbEditRequestsReceivingDept.Selected,
LUdeliveryAddress: cbbEditRequestsDeliveryAddress.Selected,
wbs: tiEditRequestsWbs.Text,
LUstatuses: {
Id: 2,
Value: "SUBMITTED FOR APPROVAL"
},
notes: tiEditRequestsNotes.Text,
netAmount: Value(lblCPREditNetAmount.Text)
}
)
;
ForAll(colEditItems,
Patch('CP-ITEMS', LookUp('CP-ITEMS', ID = ID,
{
itemName: tiEditRequestsItemName.Text,
itemDesc: tiEditRequestsItemDesc.Text,
LUvendorName: {Id: LookUp('CP-VENDORS', vendorName = cbbEditRequestsItemVendor.Selected.vendorName).ID,
Value: cbbEditRequestsItemVendor.Selected.vendorName},
qty: Value(tiEditRequestQty.Text),
LUuom: {Id:LookUp('CP-UOM', unitOfMeasure = cbbEditRequestsItemUom.Selected.vendorName).ID,
Value: cbbEditRequestsItemUom.Selected.vendorName},
pricePerUom: Value(tiEditRequestPricePer.Text),
itemUrl: tiEditRequestItemUrl.Text,
itemNotes: tiEditRequestsItemNotes.Text,
itemNetAmount: Value(lblCPREditItemAmount.Text)
}
)
)
);
Verified answer

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@scottmcnitt ,

You posted this was a nested gallery, so should the Items of the second one be

Filter( 'CP-ITEMS', LUmID.Value = ThisItem.ID )

as this would then have a sub-gallery on each item or is this a separate sub-gallery with a one-to-one relationship with the main gallery ?