My multi-line gallery is only submitting the first line (3 times) vice submitting 2 lines that is requested. Below are pictures for reference>
This is not a form, but text inputs. I have a drop-down box for the Vendor (which this also needs to be put into the patch function, but don't know how to do that as of yet).
The below picture shows that I have two lines that I want to submit into the sharepoint list:
On submit, I should have two new records in my sharepoint list, but the below picture shows that only line 1 is being submitted three times:
Here is the code for the submit button:
ForAll(
Gallery2_1.AllItems,
Patch(
PurchaseOrders2023,
Defaults(PurchaseOrders2023),
{
ProjectName: TextInputTitle.Text,
PurchaseOrder: Value(TextInputPurchaseOrder.Text),
OrderDate: DatePickerOrderDate.SelectedDate,
VendorQuote: TextInputVendorQuote.Text,
ShipTo: TextInputShipTo.Text,
OrderNotes: TextInputOrderNotes.Text,
Description: TextInputDescription.Text,
PartNumber: TextInputPartNumber.Text,
UnitCost: Value(TextInputUnitCost.Text),
Quantity: Value(TextInputQuantity.Text),
Hardware: ToggleHardware.Value,
Software: ToggleSoftware.Value,
Cables: ToggleCables.Value
}
);
If(
ToggleHardware.Value,
Patch(
'HARDWARE PER PROJECTS',
Defaults('HARDWARE PER PROJECTS'),
{
ProjectName: TextInputTitle.Text,
PurchaseOrder: Value(TextInputPurchaseOrder.Text),
OrderDate: DatePickerOrderDate.SelectedDate,
VendorQuote: TextInputVendorQuote.Text,
ShipTo: TextInputShipTo.Text,
OrderNotes: TextInputOrderNotes.Text,
Description: TextInputDescription.Text,
PartNumber: TextInputPartNumber.Text,
Quantity: Value(TextInputQuantity.Text),
UnitCost: Value(TextInputUnitCost.Text)
}
)
);
If(
ToggleSoftware.Value,
Patch(
'Software Purchase Orders',
Defaults('Software Purchase Orders'),
{
'Project Name': TextInputTitle.Text,
'Purchase Order': Value(TextInputPurchaseOrder.Text),
'Order Date': DatePickerOrderDate.SelectedDate,
Description: TextInputDescription.Text,
'Part Number': TextInputPartNumber.Text
}
)
)
);
ForAll(
Gallery2_1.AllItems,
Patch(
'PO Tracking',
Defaults('PO Tracking'),
{
'Project Name': TextInputTitle.Text,
'Purchase Order': Value(TextInputPurchaseOrder.Text),
'Order Date': DatePickerOrderDate.SelectedDate,
Description: TextInputDescription.Text,
'Part Number': TextInputPartNumber.Text,
'Unit Cost': Value(TextInputUnitCost.Text),
Quantity: Value(TextInputQuantity.Text)
}
)
)
and here is the code for the save icon:
Patch(
DescriptionCollection,
ThisItem,
{
Description: TextDescriptioninput.Text,
Unit: textinputunit.Text,
Quantity: Value(textquantityinput.Text),
UnitCost: Value(textunitcostinput.Text),
PartNumber: textinputpartnumber.Text
}
);
Collect(
DescriptionCollection,
{
Description: "",
Unit: "EA",
PartNumber: "",
Quantity: 0,
UnitCost: 0
}
)
So the end result is that when submitting the canvas app, I should have 2 new records (or more depending on the order) with the different descriptions: i.e. Line 1, Line 2, etc.
Thank you for you help in this endeavor. I am new to this program and it is a big learning curve
