Hi, wanna ask what is the valid patch function for dropdown/choice? I have tried with no error but data not save in my sharepoint list.
I have 2 dropdown menu with single selection which is tax & currency.. all record succesfully save in sharepointlist after submit except tax & currency which is datatype is Choice.
Clear Collect:
ClearCollect(
colApp,
{
invoiceno: "",
invoicedate: Blank(),
invoiceamount: 0,
paymentref: "",
paymentdate: Blank(),
paymentamount: 0,
days: 0,
percentsales: 0,
amountsales: 0,
tax: "6",
currency: "AUD",
ShowSaveButton: true
}
),
Patch to collection:
Patch(
colApp,
ThisItem,
{
invoiceno: TextInput1.Text,
invoicedate: DatePicker1.SelectedDate,
invoiceamount: Value(TextInput2.Text),
paymentref: TextInput6.Text,
paymentdate: DatePicker2.SelectedDate,
paymentamount: Value(TextInput7.Text),
days: Value(TextInput24.Text),
percentsales: Value(TextInput23.Text),
amountsales: Value(TextInput25.Text),
tax: Dropdown1.Selected.Value,
currency: Dropdown3.Selected.Value,
ShowSaveButton: false
}
);
If(
EditPressed,
false,
Collect(
colApp,
{
invoiceno: "",
invoicedate: Blank(),
invoiceamount: 0,
paymentref: "",
paymentdate: Blank(),
paymentamount: 0,
days: 0,
percentsales: 0,
amountsales: 0,
tax: "6",
currency: "AUD",
ShowSaveButton: true
}
)
);
Final patch onSuccess form:
If(
CountRows(colApp) > 0,
ForAll(
colApp,
If(
!IsBlank(invoiceno),
Patch(
sinc_main_payment,
Defaults(sinc_main_payment),
{
Title: Form1.LastSubmit.ID,
app_no: Form1.LastSubmit.Title,
invoice_no: Upper(invoiceno),
invoice_date: DateValue(invoicedate),
invoice_amount: invoiceamount,
payment_ref: Upper(paymentref),
payment_date: DateValue(paymentdate),
payment_amount: paymentamount,
days: days,
percent_sales: percentsales,
tax: Dropdown1.Selected,
currency: Dropdown3.Selected,
amount_sales: amountsales
}
)
)
)
);
