How do I create a Remote Working Location Dashboard for Teams to see WFH Schedules

Question

Hi there, 

My team is currently at the stage where we tend to WFH 1-2 days per week, and each of us decides our own schedule. However, something we are struggling with is trying to find a way for us to all easily monitor team wide locations when people choose to go to the office or WFH. Ideally I would like to be able to find a solution that can extrapolate each team member's "Work hours and locations" settings from Outlook/Teams and display them in an easy format so we can get a simple overview of when most people will be in the office. I'm thinking something as simple as a dashboard with some kind of heatmap, or even just a straight table in spreadsheet. 

Does anybody have any thoughts as to how that might be achieved? Is there some kind of 365 service that I am missing? 

I have tried to look at ways to automate this and use the Power Apps platform to streamline a system (i.e. Power BI or Power Automate) but have not had much luck with it. I couldn't see an obvious system in place for this. I also don't want to have to create a system that is too complicated, in order to encourage adoption across the company. I have even looked into changing calendar visibility settings across the company, but it still doesn't seem to work well as solution to this issues.

Thanks in advance for any help you can offer, I'm open to suggestions.

Answer 1

Thanks Inema, I will try that!

Edit:

https://powerusers.microsoft.com/t5/General-Power-Automate/How-do-I-create-a-Remote-Working-Location-Dashboard-for-Teams-to/td-p/2298212

Answer 2

Dear Dale Garland,

Good day!

Thank you for posting to Microsoft Community. We are glad to assist.

As per your mentioned description about "How do I create a Remote Working Location Dashboard for Teams to see WFH Schedules" For you to be assisted properly, I would like to share information with you. We have specific dedicated forum who are handling Microsoft Power Automate related queries, and they have special expertise in it. So, it is recommended to kindly post your query to dedicated Microsoft Power Automate Forum via General Power Automate Discussion - Power Platform Community (microsoft.com) Engineers who are dedicated into Microsoft Power Automate with rich experience and more resources can then assist efficiently. We believe they would conduct in-depth research on the problem you encountered and provide you with more professional assistance.

In the meantime, I would also like to invite community members and MVPs in the forum to share their knowledge or any workaround and insight on this topic.

Best regards,

Inema | Microsoft Community Moderator