Crisis Communication solution feedback

[mabolan]

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. 😁

[lamysroe]

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?

[nvaghela]

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.

[Anonymous]

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 

[Aj789]

Hi Team,

Need your help.
When I try installing the app I see that I only can view the Top part where I am working from ,
However , the Lower pane seems to blank ,
I do not get the view where there is Company News & Faq's etc,

Also I see once of the connector  CrisisCommunication.request is Greyed out.

Need your help as we are unable to deploy this Application,.

Also Attaching the screen shot for reference

[JBOMG]

Hello,

When I get to this part of the tutorial, I can't seem to add my existing connections or create a new one. I'm stuck at this point of the tutorial. Any help is appreciated.

Thanks

[WouterHar]

Hello, I just found out about the crisiscomm.app and tried to install it. But now I get the message that it doesn't work because SharePoint 2010 workflows have been disabled. What can I do to fix that? Thanks in advance!

[SusanKelly]

I am having issues with the importing of the Power App "CrisisCommunication.zip". The connectors for Content Conversion Connection and Microsoft Teams Connection won't show my current connector nor will it refresh after I created a new one. I hav also tried the GCC version and had the same issue with Microsoft Teams Connection. Is there a trick to this? Please help or show the step by step building of the app.

[ObiRickC137]

Is there a way to get around the 999 limit when calling users from Azure AD? We have larger than 999 groups, and the notifications fail to send past 999.

[sergio_alanis]

Hi could someone help me to solve this Item in the flow of deploylistSP.