Add Row Button:
Collect(
colRowUpdates1,
{
Quantity: "",
CostType: "",
ItemDescription: "",
ReasonforPurchase: txtReason.Text,
FullName: txtFullName.Text,
BusinessUnit: txtBusinessUnit.Text,
JobNumber: cmbJobNumber.Selected.'JOB #',
Supplier: cmbSupplier.Selected.Supplier,
DeliveryAddress: TextInput1.Text,
DeliveryInstructons: txtDeliveryInstructions.Text,
CreatorEmail: Label3.Text,
CostperItem: "",
TotalLineItem: TextInput6.Text,
RowNumber: CountRows(colRowUpdates1) + 1
}
)
Gallery Items:
UpdateIf(colRowUpdates1,RowNumber=ThisItem.RowNumber,{CostperItem:TextInput2,TotalLineItem:Qty*TextInput2})
Trash Can
Remove(colRowUpdates1,ThisItem)
Submit Button:
Patch(
'PR Summaries',
Defaults('PR Summaries'),
{
Name: txtFullName.Text,
'Job Number': cmbJobNumber.Selected.'JOB #',
Supplier: cmbSupplier.Selected.Supplier,
ProcurementType: Dropdown1.Selected.Value,
DeliveryAddress: TextInput1.Text,
DeliveryInstructions: txtDeliveryInstructions.Text,
ReasonforPurchase: txtReason.Text,
DateRequired: DatePicker1.SelectedDate,
Email: Label3.Text,
BusinessUnit: Dropdown2.Selected.Value,
Quote: {
FileName: First(DataCardValue3_1.Attachments).Name,
Value: First(DataCardValue3_1.Attachments).Value
},
TotalValue: Value(TextInput5.Text)
}
);
ForAll(
colRowUpdates1,
Patch(
'Purchase Requisitions',
Defaults('Purchase Requisitions'),
{
Quantity: Quantity,
'Business Unit': BusinessUnit,
Supplier: Supplier,
'Item Description': ItemDescription,
'Job Number': JobNumber,
'Delivery Address': DeliveryAddress,
'Delivery Instructions': DeliveryInstructons,
'Full Name': FullName,
'Cost Type': CostType,
'Reason for Purchase': ReasonforPurchase,
CreatorEmail: CreatorEmail,
'Cost per Item': CostperItem,
'Procurement Type': Dropdown1.Selected.Value,
'Date Required': DatePicker1.SelectedDate,
'Req Summary ID': First(
Sort(
'PR Summaries',
'Summary ID',
SortOrder.Descending
)
).'Summary ID'
}
)
);
ClearCollect(
colRowUpdates1,
Defaults('Purchase Requisitions');
Notify(
"Success",
NotificationType.Success
)
);
Reset(cmbJobNumber);
Reset(cmbSupplier);
Reset(txtDeliveryInstructions);
Reset(txtReason);
Reset(TextInput1);
Reset(Dropdown1);
Reset(DatePicker1);
Reset(DataCardValue3_1);
Reset(Dropdown2);
Reset(Gallery2);
Set(varSuccessPopUp,true)
Does that help?
