Set(varItemToFindOrCreate,
LookUp(
'Course Calendar',
'Class RN' = gal_Calendar_Events_3.Selected.'Class RN' And 'Course Start Date' = ThisItem.Value
)
);
If(
IsBlank(varItemToFindOrCreate),
Collect(
'Course Calendar',
{
'Assessor Status': DropdownCanvas3_1.Selected.Value,
'Course Name': DropdownCanvas3_1.Selected.Value,
Assessor: {Value: "Gajender"},
'Off Date': ThisItem.Value,
'Course Start Date': ThisItem.Value,
'Course End Date': ThisItem.Value
}
),
Patch(
'Course Calendar',
varItemToFindOrCreate,
{
'Assessor Status': DropdownCanvas3_1.Selected.Value,
'Course Name': DropdownCanvas3_1.Selected.Value,
Assessor: {Value: "Gajender"},
'Off Date': ThisItem.Value,
'Course Start Date': ThisItem.Value,
'Course End Date': ThisItem.Value
}
)
);
Refresh('Course Calendar');
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.