Hi - Until recently I haven't had issues with formulas. A few days ago I started getting errors on the Submit button on the calendar picker. The error says that the portion below is invalid.
PresenceStatus: LookUp(colWorkStatus,Value=WorkStatusComponent.Selected.Value)
UpdateContext({locSaveDates: true});
// Store the output properties of the calendar in static variables and collections.
ClearCollect(
submittedDates,
Sort(
Filter(
selectedDates,
ComponentId = CalendarComponent.Id
),
Date,
Ascending
)
);
Set(
varStartDate,
First(submittedDates).Date
);
Set(
varEndDate,
First(
Sort(
submittedDates,
Date,
Descending
)
).Date
);
//place holder for get manager
Set(varmanageremail, Office365Users.ManagerV2(User().Email).mail);
Set(varmanagername, Office365Users.ManagerV2(User().Email).displayName);
// Create a new record for work status for each date selected in the date range.
ForAll(
Filter(
RenameColumns(
submittedDates,
"Date",
"DisplayDate"
),
ComponentId = CalendarComponent.Id,
!(DisplayDate in colDates.Date)),
Patch(
'CI_Employee Status',
Defaults('CI_Employee Status'),
{
Title: varUser.userPrincipalName,
Office: varUser.officeLocation,
Department: varUser.department,
Date: DisplayDate, 'Staff Name': varUser.displayName,
Notes: "",
'Manager Email': varmanageremail,
'Manager Name': varmanagername,
PresenceStatus: LookUp(
colWorkStatus,
Value=WorkStatusComponent.Selected.Value)
// To implement location, add a comma to the line above and uncomment the lines below for latitude and longitude.
//Latitude: Text(Location.Latitude),
//Longitude: Text(Location.Longitude)
}
)
);
// Update existing dates with the new status.
ForAll(
AddColumns(
Filter(
RenameColumns(
submittedDates,
"Date",
"DisplayDate"
),
ComponentId = CalendarComponent.Id,
DisplayDate in colDates.Date
),
// Get the current record for each existing date.
"LookUpId",
LookUp(
RenameColumns(
colDates,
"ID",
"DateId"
),
And(
Title = varUser.userPrincipalName,
Date = DisplayDate
)
).DateId
),
Patch(
'CI_Employee Status',
LookUp(
'CI_Employee Status',
ID = LookUpId
),
{
PresenceStatus: LookUp(
colWorkStatus,
Value = WorkStatusComponent.Selected.Value
)
}
)
);
If(
IsEmpty(Errors('CI_Employee Status')),
// Update the list of work status for the logged-in user.
ClearCollect(
colDates,
Filter(
'CI_Employee Status',
Title = varUser.userPrincipalName
)
);
// Case: Successful submitting work status
Notify(
"You successfully submitted your work status.",
NotificationType.Success,
3000
);
Navigate(
'Home Screen',
LookUp(
colStyles,
Key = "navigation_transition"
).Value
),
/*
// Send an email receipt to the logged-in user.
UpdateContext(
{
locReceiptSuccess:
Office365Outlook.SendEmailV2(
// To: send an email to oneself
varUser.mail,
// Subject
Proper(WorkStatusComponent.Selected.Value) & ": " & varStartDate & If(varStartDate<>varEndDate," - " & varEndDate),
// Body
WorkStatusComponent.Selected.DateRangeReceipt & ": " &
// Create a bulleted list of dates
"<ul>" &
Concat(submittedDates,"<li>" & Date & Char(10)) &
"</ul>"
)
}
);
If(
locReceiptSuccess,
Notify("You successfully submitted your work status. An email has been sent to you with a summary.",NotificationType.Success,3000),
Notify("There was an error sending an email summary, but you successfully submitted your work status.",NotificationType.Success,3000);
);
Navigate('Share to Team Screen',LookUp(colStyles,Key="navigation_transition").Value),
*/
// Case: Error submitting work status
Notify(
varString.WorkStatusError,
NotificationType.Warning
)
);
UpdateContext({locSaveDates: false})
Any thoughts?
