Re: Return to the workplace

narpad · ‎07-21-2020

(Updated 9/9/2020)

Hi Team,

We’re delighted to announce v1.1 of the Power Platform Return to the workplace solution. We’ve heard your feedback and incorporated many of the requirements our customers have been asking for with this release. The new solution will be released on AppSource today. Summary is here but please also see below for more details.

Enhancements for Location Readiness and Care Management including phase transitions and updates to the leadership and case manager dashboards
Employee Health and Safety updates including booking a daily pass by floor and area along with arrival time.
New Location Management app including capability to manage and report on capacity, arrival windows, and integration capabilities for building entry systems.

APSOURCE REL 1.1 links

App

https://aka.ms/rtw-app

Power BI

Location Readiness Dashboard

https://aka.ms/rtw-leadershippbi

Workplace Care Management Dashboard

https://aka.ms/rtw-workplacepbi

Facility Management Dashboard

https://aka.ms/rtw-facilitypbi

*****************Original Post***********************

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment. Equip facility managers and task force leaders to make informed decisions to safely reopen locations. Empower employees to return confidently with self-service tools for working safely and productively. Help health and safety leaders ensure the care and well-being of your workforce.

Learn more about the solution , watch the video and read the documentation to understand capabilities and working with the solution.

AbrahamSaldana · ‎11-23-2020

We encounter that WHO (World Health Org) has made a change in their schema and now is causing the leadership dashboard not to refresh, in the case that you downloaded the Dashboard from GitHub and need to make the updates now the following are the steps on how to make the modifications to the queries

The GitHub link is: https://aka.ms/rtw-solution

1) Open Power BI Desktop and open the PBIX for Facility Manager / Leadership

2) Transform Data and select Transform Data

3) In Non-Loaded Query, change the queries below:

- R_States (Epiforecast) - Open advanced editor and copy the code below

let

Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/epiforecasts/covid-rt-estimates/master/subnational/united-states/c..."),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None]),

#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

#"Added Custom" = Table.AddColumn(#"Promoted Headers", "country", each "United States"),

#"Changed Type" = Table.TransformColumnTypes(#"Added Custom",{{"state", type text}, {"date", type date}, {"median", type number}, {"mean", type number}, {"lower_90", type number}, {"upper_90", type number}, {"country", type text}})

in

#"Changed Type"

- WHO-NoChinaUS (WHO) - Open advanced editor and copy the code below

let

Source = Csv.Document(Web.Contents("https://covid19.who.int/WHO-COVID-19-global-data.csv"),[Delimiter=",", Columns=8, Encoding=65001, QuoteStyle=QuoteStyle.None]),

#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date_reported", type date}, {"Country_code", type text}, {"Country", type text}, {"WHO_region", type text}, {"New_cases", Int64.Type}, {"Cumulative_cases", Int64.Type}, {"New_deaths", Int64.Type}, {"Cumulative_deaths", Int64.Type}}),

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([#"Country"] <> "China" and [#"Country"] <> "United States of America")),

#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"WHO_region"}),

#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Date_reported", "Date"}, {"Country_code", "LocID"}, {"Country", "Country_Region"}, {"Cumulative_cases", "Confirmed"}, {"New_cases", "ConfirmedChange"}, {"New_deaths", "DeathsChange"}, {"Cumulative_deaths", "Deaths"}})

in

#"Renamed Columns"

ved · ‎11-25-2020

Epiforecast has just made a change in their schema and now is causing the leadership dashboard not to refresh. In case you downloaded the dashboard from GitHub and need to make the updates now the following are the steps on how to make the modifications to the queries

The GitHub link is: https://aka.ms/rtw-solution

1. Open Power BI Desktop and open the PBIX for Facility Manager / Leadership

2. Transform Data and select Transform Data

3. In COVID Pubic data group of queries, change the query below:

- Reproductive number - Open advanced editor and copy the code below

let

Source = Csv.Document(Web.Contents("https://raw.githubusercontent.com/epiforecasts/covid-rt-estimates/master/national/cases/summary/rt.c..."),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None]),

#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"country", type text}, {"date", type date}, {"type", type text}, {"median", type number}, {"mean", type number}, {"sd", type number}, {"lower_90", type number}, {"upper_90", type number}, {"lower_20", type number}, {"upper_20", type number}, {"lower_50", type number}, {"upper_50", type number}}),

#"Replaced Value" = Table.ReplaceValue(#"Changed Type","United States of America","United States",Replacer.ReplaceText,{"country"}),

#"Filtered Rows" = Table.SelectRows(#"Replaced Value", each ([country] <> "United States")),

#"Added Custom" = Table.AddColumn(#"Filtered Rows", "region", each null),

#"Reordered Columns" = Table.ReorderColumns(#"Added Custom",{"country", "region", "date", "type", "median", "lower_90", "upper_90", "lower_50", "upper_50", "lower_20", "upper_20"}),

#"Appended Query" = Table.Combine({#"Reordered Columns", R_States}),

#"Merged Countries" = Table.NestedJoin(#"Appended Query", {"country"}, Country, {"Country"}, "Countries", JoinKind.LeftOuter),

#"Expanded Countries" = Table.ExpandTableColumn(#"Merged Countries", "Countries", {"Country Code"}, {"Country Code"}),

#"Merged States" = Table.NestedJoin(#"Expanded Countries", {"state"}, #"Province/State", {"Province/State"}, "States", JoinKind.LeftOuter),

#"Expanded States" = Table.ExpandTableColumn(#"Merged States", "States", {"Province/State code"}, {"Province/State code"}),

#"Added Custom1" = Table.AddColumn(#"Expanded States", "Location ID", each if [#"Province/State code"]=null then [Country Code] else [Country Code] & [#"Province/State code"]),

#"Renamed Columns" = Table.RenameColumns(#"Added Custom1",{{"country", "Country"}, {"region", "Region"}, {"median", "Median"}, {"lower_90", "Lower 90"}, {"upper_90", "Upper 90"}, {"lower_50", "Lower 50"}, {"upper_50", "Upper 50"}})

in

#"Renamed Columns"

Alienvolm · ‎11-30-2020

Hello,

I have recently installed the app and the three Power BI reports. See versions below:

The Leadership app and the Facility management app will not upload the data and both display the following error:

LEADERSHIP:

Processing error: The column 'upper_90' of the table wasn't found.

Cluster URI: WABI-WEST-US-redirect.analysis.windows.net

Activity ID: 9333b726-842b-4e96-ac68-f7538fe0df3a

Request ID: 51a3caf0-a1be-b15c-b1ba-aeb89627e687

Time: 2020-11-30 16:12:32Z

FACILITY MANAGEMENT:

Processing error: The column 'upper_90' of the table wasn't found.

Cluster URI: WABI-WEST-US-redirect.analysis.windows.net

Activity ID: 9333b726-842b-4e96-ac68-f7538fe0df3a

Request ID: 9e5b0ac9-fb8d-5f8f-7756-b8f34af11c7b

Time: 2020-11-30 16:22:42Z

If I try to edit the reports to see the fields, the two fields are spelled like 'upper 90' with no underscore.

Unfortunately it doesn't seem to be possible to correct the name of the fields in Edit mode.

Is there a way of fixing this or is there an updated version of the app or the reports?

Thanks!

~Alienvolm

AbrahamSaldana · ‎11-30-2020

@Alienvolm We had posted some of the manual changes that fix those issues(previous post), we are planning to have that hotfix in the next release 1.3 that is coming on the first week of December.

abe

diver7 · ‎12-02-2020

Step one is to open the PBIX file. How do I get the PBIX file? If I try to download it the option to download is disabled. Why?

diver7 · ‎12-03-2020

@AbrahamSaldana Do you have any ideas about why I can't download the PBIX file? Is there another way to do it?

AbrahamSaldana · ‎12-03-2020

@diver7 you can find the PBIX files in GitHub, this the URL location for the files

https://github.com/microsoft/powerapps-tools/tree/master/Apps/ReturnToWorkplace

We just released version 1.3 and the PBIX files will be in the file ReturnToWorkplace.zip

Abe

diver7 · ‎12-03-2020

@AbrahamSaldana Please forgive me as I am not well versed in PowerBI. I looked through the ReturnToWorkplace.zip file and did not find any PBIX files. There are only the PBIT files. Can these be used to update the datasource?

When will version 1.3 be deployed to AppSource so that I can update the application using the instructions found here:

https://docs.microsoft.com/en-us/powerapps/sample-apps/return-to-workplace/upgrade

or do you have instructions on how to update it manually using the Zip file.

AbrahamSaldana · ‎12-03-2020

@diver7 The PowerBi source files are the PBIT and you can update the data source; The Release 1.3 will be available tomorrow morning for sure. You can download from Appsource directly tomorrow morning

abe

AbrahamSaldana · ‎12-04-2020

Update to Return to Workplace Release 1.3

We are thrilled to announce the latest release of the Return to Work solution (version 1.3). Four releases in 5 months with 1900 installs in 48 countries demonstrates the strength of the Power Platform and is a testament to the pace at which teams across Microsoft have worked together to meet our customers’ needs during this pandemic. This release is special for us as it has been “co-built” with customers like you who have helped us validate our hypotheses in real-time. We hope that this release provides businesses across the globe a way to safely re-open when they are ready to do so.

New workplace portal provides safe access for all visitors

Location managers can offer safe access to third parties

Enhanced safety management through manual contact tracing:

Contact tracers can quickly identify case contacts, and health and safety leaders can view case clusters and associated metrics to assess risk of an outbreak and take immediate actions

Manage facility access for employees:

Facility or case managers can manage facility access for employees and provide them guidance through the app, push notification, email, or text

COVID-19 virus activity now available at a county level for the US

Business leaders can view COVID-19 data and insights at a county level for US

[What action do I need to take?]

Review the documentation on What’s New page

What’s new in Return to the Workplace Solution - Power Apps | Microsoft Docs

Update and take advantage of all new features update to Release 1.3

Upgrade the Return to the Workplace solution for Microsoft Power Platform - Power Apps | Microsoft D...

Please use the following links for upgrading to Release 1.3

Return to Workplace Apps

https://aka.ms/rtw-app