Forum Discussion

Copper Contributor

Jun 29, 2023

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
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
Appreciate your Kudos! Proud to contribute! 🙂

Maggala

Copper Contributor

The next step would depend on how you want the list to function. If you want all users to be able to see each others 'status' and other information. Essentially you would give users access to this list and they would go in and change their own status and it would show when it was modified in the modified column. You can add a notes column so they can leave notes or any specifics about what they're working on. You can set the list to save up to a certain amount of versions (I can't remember what they cap it at the moment) so that you can see all the edit history made to each users 'line'. You can write flows for notifications when a certain user changes their status or for a summary of daily status changes. I know bts0004 wanted their Team presence to show, and hopefully they got that figured out. I did not incorporate my users Teams status because they just don't use it as proficiently as they should.

bts0004

Copper Contributor

Mar 15, 2024

We heavily rely on Teams, since most of us work remotely, so integration with Teams presence is a must-have for us. In the end, I ended up purchasing a license for Simple In/Out, with the sole intention of the dashboard available to us with Teams presence integration. They are very reasonably priced, and for the amount of time I've spent banging my head on the desk over this, it is worth it. Hopefully Microsoft improves in this area at some point. Having a dashboard view of users doesn't seem like an unreasonable request.