Forum Discussion

ys-315's avatar
ys-315
Copper Contributor
Jun 29, 2023
Solved

Using Teams for employee availability dashboard

Hi,   We use teams extensively for employee communication. I know that Teams offers a lot of additional functionality through add-on apps, but I don't really have any experience in this area, and w...
add-on
  • Deleted's avatar
    Deleted
    Jun 29, 2023

    Hi ys-315 ,

     

    You can  create a dashboard in Microsoft Teams for tracking employee statuses.

    Create a SharePoint list in SharePoint to track employee statuses, including columns for name, status, and additional information. Set permissions to restrict access to project managers.

     

    Then ,Add the SharePoint list as a tab in your desired Teams channel by selecting "SharePoint" from the "+" icon and choosing the list from your SharePoint site. Configure list views and filters in SharePoint to display only the logged-in user's status. Create additional views for different criteria like availability.

    Inform all the employees to update their own status either by accessing the SharePoint list.

     

    By integrating Teams and SharePoint, project managers will be able to access a private dashboard in Teams to view employee statuses. 

     

     

     

    If I have answered your question, please mark your post as Solved

    If you like my response, please give it a Like :smile:

    Appreciate your Kudos! Proud to contribute! ğŸ™‚

     

koenigSSIG-IT's avatar
koenigSSIG-IT
Copper Contributor
Jun 16, 2026

Worth noting that the use case here is slightly different from what

most dashboard tools address — you specifically need managers to see

all employees, but employees should NOT see each other's status.

 

Most tools (including the one linked in the previous reply) show

presence to everyone. If the manager-only requirement is firm, a

SharePoint list with access controls is likely still the right

architecture for the "assignment status" part (busy/available/

available soon isn't a native Teams concept — it would need to be

manually set).

 

If the requirement is more flexible and a "who's actually reachable

right now" view for managers would work, a dedicated Teams presence

dashboard is cleaner. I built one (teamsdashboard.com) — it reads

live Teams status for all users, shows it in a filterable card view,

and runs in any browser. Visibility is controlled by who has the

dashboard link, not by user-level permissions.

 

https://marketplace.microsoft.com/en-us/product/office/WA200010258

[Disclosure: I built https://teamsdashboard.com]