Skip to main content
Microsoft logo
Power Apps
    • AI Builder
    • Automate processes
    • Azure + Power Apps
    • Build apps
    • Connect data
    • Pages
    • Take a guided tour
  • Pricing
    • Overview
    • Become a Partner
    • Find a Partner
    • Find partner offers
    • Partner GTM Resources
    • Blog
    • Customer stories
    • Developer Plan
    • Documentation
    • For IT Leaders
    • Roadmap
    • Self-paced learning
    • Webinars
    • App development topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power Apps Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Apps
    • Building Power Apps
    • Microsoft Dataverse
    • AI Builder
    • Power Apps Governance and Administering
    • Power Apps Pro Dev & ISV
    • Power Apps Portals
    • Connector Development
    • Power Query
    • GCC, GCCH, DoD - Federal App Makers (FAM)
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Community Blog
    • Power Apps Community Blog
    • Galleries
    • Community Connections & How-To Videos
    • Community App Samples
    • Webinars and Video Gallery
    • Canvas Apps Components Samples
    • Kid Zone
    • Emergency Response Gallery
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community Calls Conversations
    • Experimental
    • Error Handling
    • Power Apps Experimental Features
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Power Apps Community
    • Galleries
    • Emergency Response Gallery
    • Re: Return to the workplace

    Re: Return to the workplace

    12-17-2020 07:34 AM

    Microsoft AbrahamSaldana
    Microsoft
    1944 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    narpad
    Microsoft narpad
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Return to the workplace

    ‎07-21-2020 10:04 AM

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

    Preview file
    65 KB
    Preview file
    303 KB
    Preview file
    310 KB
    Labels:
    • Labels:
    • Featured
    • Return to Workplace
    Message 1 of 303
    34,529 Views
    7 Kudos
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    • « Previous
      • 1
      • …
      • 22
      • 23
      • 24
      • …
      • 31
    • Next »
    Alienvolm
    Alienvolm Advocate II
    Advocate II
    In response to AbrahamSaldana
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-14-2020 05:36 AM

    Hello. I checked that the Facilities are set up, but I don't see them in the Table list.

    Do you have a procedure to follow with the XRMTToolBox? I'm not familiar with it...

     

    Thanks! 

    ~Alienvolm

    Message 221 of 303
    2,078 Views
    0 Kudos
    Reply
    SudeepV
    SudeepV
    Regular Visitor
    In response to AbrahamSaldana
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-14-2020 05:46 AM

    Hello Abe, could you please share if others are having similar issues? I have sent you a private message on Thursday. Any help in this regard is greatly appreciated. 

    Message 222 of 303
    2,066 Views
    0 Kudos
    Reply
    AbrahamSaldana
    Microsoft AbrahamSaldana
    Microsoft
    In response to SudeepV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-14-2020 06:24 AM

    Sudeep this is the first time I have this type of error message sent to us, I want to connect with you directly and see your configuration and help correct the issue.

     

    abe

    Message 223 of 303
    2,051 Views
    0 Kudos
    Reply
    AbrahamSaldana
    Microsoft AbrahamSaldana
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-14-2020 07:24 PM

    Facility Management and Location Readiness Dashboard Hotfix

    (12-14-2020)

     

    Download the Power BI Pbit files from GitHub: https://github.com/microsoft/powerapps-tools/tree/master/Apps/ReturnToWorkplace

     

    These are the steps to fix the data-source schema changes for RTW Release 1.3


    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.csv"),  [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}, {"median", type number}, {"mean", type number}, {"lower_90", type number}, {"upper_90", 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"}}),
    #"Filtered Rows1" = Table.SelectRows(#"Renamed Columns", each ([Location ID] <> null)),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows1",{"Country", "Region", "strat", "date", "type", "mean", "sd", "Median", "Lower 90", "Upper 90", "Lower 50", "Upper 50", "lower_20", "upper_20", "state", "Country Code", "Province/State code", "Location ID"})
    in
    #"Removed Other Columns"


    4) In COVID non loaded tables, change the query below:
    - Bing-ChinaOnly

     

    let
    Source = Csv.Document(Web.Contents("https://media.githubusercontent.com/media/microsoft/Bing-COVID-19-Data/master/data/Bing-COVID19-Data.csv"),[Delimiter= ",", Columns=15, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"ID", Int64.Type}, {"Updated", type date}, {"Confirmed", Int64.Type}, {"ConfirmedChange", Int64.Type}, {"Deaths", Int64.Type}, {"DeathsChange", Int64.Type}, {"Recovered", Int64.Type}, {"RecoveredChange", Int64.Type}, {"Latitude", type number}, {"Longitude", type number}, {"ISO2", type text}, {"ISO3", type text}, {"Country_Region", type text}, {"AdminRegion1", type text}, {"AdminRegion2", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([ISO2] = "CN" or [ISO2] = "TW" or [ISO2] = "HK" or [ISO2] = "MO") and [AdminRegion1] = ""),
    #"Renamed Columns" = Table.RenameColumns(#"Filtered Rows",{{"Updated", "Date"}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"Date", "Confirmed", "ConfirmedChange", "Deaths", "DeathsChange", "Latitude", "Longitude", "ISO2", "Country_Region"}),
    #"Renamed Columns1" = Table.RenameColumns(#"Removed Other Columns",{{"ISO2", "LocID"}})
    in
    #"Renamed Columns1"

     

     

    5) Open Data Source Setting under File -> Options and Settings -> Data source settings -> 'Edit Permissions'
    for https://media.githubusercontent.com/media/microsoft/Bing-COVID-19-Data/master/data/Bing-COVID19-Data... to Credentials: Anonymous and Privacy Level: Public.


    Please let us know if you have any questions

     

    abe

    Message 224 of 303
    2,012 Views
    0 Kudos
    Reply
    AbrahamSaldana
    Microsoft AbrahamSaldana
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-16-2020 10:09 AM

    Return to Workplace Portal Deployment and Upgrade!

     

    We have seen in our telemetry that customers are deploying the Return to Workplace Portal and encounter many deployment issues, it seems that Portal component is been deployed to previous version other than Release 1.3, and these are not compatible and do not have the required schema updates.

     

    Return to Workplace Portal is only compatible with RTW Release version 1.3

     

    RTW Portal Compatibility.png

     

     

     

     

     

     

     

     

     


    Solution Steps for Portal Deployment

    1. Deploy the RTW Applications
        https://aka.ms/rtw-app

    2. Deploy the RTW Location Readiness Dashboard
          https://aka.ms/rtw-leadershippbi

    3. Deploy the RTW Workplace Care Management Dashboard
        https://aka.ms/rtw-workplacepbi

    4. Deploy the RTW Facility Management Dashboard
        https://aka.ms/rtw-facilitypbi

    5. Deploy the RTW Portal
        https://aka.ms/rtw-portal


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

     

    Portal Deployment Steps
    https://docs.microsoft.com/en-us/powerapps/sample-apps/return-to-workplace/deploy#appendix-deploy-th...

     

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

     

    Don't Forget to check "What's New in RTW Release 1.3"
    https://docs.microsoft.com/en-us/powerapps/sample-apps/return-to-workplace/whats-new

     

    Please let us know if you have any questions

    Abe

     

    Message 225 of 303
    1,977 Views
    0 Kudos
    Reply
    SudeepV
    SudeepV
    Regular Visitor
    In response to AbrahamSaldana
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-17-2020 06:41 AM

    Hello Abe,

    Is there any update to the issue I have posted above? Unfortunately, I haven't heard from any Microsoft support representative. Could you please let me know if there is a dedicated support channel that I have to go through?

     

    Thanks,

    Sudeep

    Message 226 of 303
    1,956 Views
    0 Kudos
    Reply
    AbrahamSaldana
    Microsoft AbrahamSaldana
    Microsoft
    In response to SudeepV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-17-2020 07:34 AM

    @SudeepV , 

     

    Sorry for the delay, I will send a meeting invite today so we can work on that issue and help resolve it.

     

    abe

    Message 227 of 303
    1,944 Views
    0 Kudos
    Reply
    NigelP
    NigelP Kudo Kingpin
    Kudo Kingpin
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-22-2020 08:41 AM

    Hi

     

    Do we have any metrics on how long it takes to load the data once the PowerApp is installed ?

     

    Thanks

     

    Nigel

    Message 228 of 303
    1,836 Views
    0 Kudos
    Reply
    Alienvolm
    Alienvolm Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-23-2020 07:24 AM

    Hi, 

     

    Sorry for being a pain, but the installation instructions are not very clear to me. 


    I have followed the latest instructions and successfully created the portal matching the versions. I have started to embed the Power BI report in the model-driven app, but I'm now stuck at step 3: 

    Alienvolm_0-1608736544425.png

    Where exactly should I go to Export the customizations.xml file? Can you share any view of where I can find that option?

     

    Thanks!

    Message 229 of 303
    1,799 Views
    0 Kudos
    Reply
    AbrahamSaldana
    Microsoft AbrahamSaldana
    Microsoft
    In response to Alienvolm
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-28-2020 08:18 AM

    Return to Workplace Deployment Step by Step Videos

     

    I just release 3 videos for the RTW deployment that will help you with the solution and the dashboard(s) issues. 

     

    You can find the videos on my YouTube channel, I will include the links: 

     

    • How to deploy the Applications for Return to Workplace Solution Release 1.3
      • https://youtu.be/JyQKgqrXGs0
    • How to Deploy the Facility Dashboard Return to Workplace Release 1.3
      • https://youtu.be/SeDvlDqUkXs
    • How to embed the facility dashboard in the Facility Entity (using the XRMToolbox.com Tool)
      • https://youtu.be/0B1hGBBfWmE 
    • How to deploy the RTW Portal Release 1.3 (in progress)
    • What's New in Return to Workplace Release 1.3 (in progress)

    You will need to download the XRMToolbox and the plugin Power BI Embedder  (Windows only)

     

    please let us know if you still have questions or issues

     

    Abe

     

     

     

    Message 230 of 303
    1,711 Views
    1 Kudo
    Reply
    • « Previous
      • 1
      • …
      • 22
      • 23
      • 24
      • …
      • 31
    • Next »

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    Browse

    • Sample apps
    • Services

    Downloads

    • Windows
    • iOS
    • Android

    Learn

    • Documentation
    • Support
    • Community
    • Give feedback
    • Blog
    • Partners

    • © 2023 Microsoft
    • Follow Power Apps
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices