cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mabolan
Power Apps
Power Apps

Crisis Communication solution feedback

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

272 REPLIES 272
lamysroe
Regular Visitor

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.

Anonymous
Not applicable

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 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (10,414)