On Monday afternoon, as news of COVID-19 cases spread globally, we pulled together a team to help customers coordinate their own information sharing and team collaboration in response to evolving conditions in times of crisis. Today, less than 48 hours later, we’re releasing the first version of that solution for any customer organization to quickly implement. You can read more about the solution in our blog post or get the full instructions for how you can implement your own Crisis Communication app here.
We're extremely excited to hear how the community leverages this app, so we've created this thread to hear directly from you. Feel free to share your experience customizing the solution and altering it for your own needs. Over the next few weeks, we'll take your responses to make the app even better and post incremental updates. 😁
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?
I've followed the instructions to the tee and it seems like the share your status screen / doesn't seem to be working.
It also doesn't show the icons either.
Same here. @mabolan The "share status" page doesn't work, the icons aren't shown and the response isn't recorded. Could you please help? Best regards / Axel
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
208 | |
187 | |
82 | |
56 | |
36 |
User | Count |
---|---|
287 | |
244 | |
119 | |
80 | |
55 |