Hi, I am stumped as to what the solution is here.
I have an SP list which is to capture Timesheet details from an app. List is called TimesheetDetailsNew.
I have a column in this list that looksup to another list, BillingItemsNew, that contains all of the Billing Item codes users can select from.
On the app, there is a combobox that displays all of the billing items, using BillingItemsNew as the Items.
I need to be able to patch all data entered to the TimesheetDetailsNew SP list. I can get most of the data working apart from the Billing Items.
What I have is:
Patch(
TimesheetDetailsNew,
gblTimesheetCurrent,
LookUp(TimesheetDetailsNew, ID='Billing Item'.Id),
{'Billing Item': comboBillItems.Selected,
Status: {Value: "Submitted"},
Mon: Value(txt_Monday.Text),
Tues: Value(txt_Tuesday.Text),
Wed: Value(txt_Wednesday.Text),
Thur:Value(txt_Thursday.Text),
Fri:Value(txt_Friday.Text),
Sat:Value(txt_Saturday.Text),
Sun:Value(txt_Sunday.Text),
'Employee Email': Text(txtUserEmail.Text),
'Employee Manager': Text(txtUserManager.Text),
Organisation: Text(txtOrg.Text),
'Employee Job Title': Text(txtJobTitle.Text)
}
);
Which was close but still won't work.
Any advice will be appreciated
