How to create a dashboard based on data from multiple Teams channels

[PowerAutomater]

I have a Teams team/group setup, each channel within the group is essentially a project, and each project has a project plan (at the moment created using MS Lists). I would like to create a dashboard which visualises and summarises the project information from all of the plans across these channels, to save the time consuming task of going into each one and trying to make sense of it. I understand I could use Power Automate to create a new data source that compiles of this data into a single one, but the conditions to set up such updates would be very complex and need to handle duplicates and many other edge cases.

Is there a way to get the data from across multiple Team channels in this way?

[PowerAutomater]

Sorry I should have mentioned that they are private channels. Apparently private channels create their own site.

[danextian]

I've read somewhere that you can use Power Automate to get a list of sharepoint sites from all Teams channels. I can't think of ways other than that.

[PowerAutomater]

Yes I was hoping to not have to use Power Automate, but it looks like there is no other way, thank you for your help.

[danextian · Accepted solution]

Hi @PowerAutomater ,

There is an existing Teams connector which is still in Beta but I doubt you'll find the information you need using it as it shows user activity only.

If your project plans were created using a Sharepoint list, I suggest you use the Sharepoint list connector instead.  If you have multiple sites, maintain ist of those sites, connect to that list using Power BI (enter data, excel online, etc)  and create a custom column to access the sharepoint sites  using SharePoint.Tables function

This will create a column containing tables of available SharePoint lists from those SharePoint sites. You can expand the column and filter to the data you need

It will be a process of exploring which columns/tables have the  data needed

[PowerAutomater]

The only issue is that multiple users can create channels in the Team and put new plans/lists in these as they need, so wouldn't I need to manually maitain the list of sites since each new channel creates a new site? I was hoping that maybe there was a way to get all of the lists dynamically be querying the actual Team and searching down it's hierarchy through all of the channels?

[danextian]

My tests shows that each channel in a Team points to the same SharePoint site assigned to that team. You can test it yourself.