question

MS-5605 avatar image
0 Votes"
MS-5605 asked MS-5605 edited

Read excel and run Powershell for MS teams

Hi Experts,

Would you please suggest any Microsoft tools to automate the below requirements to executive the PowerShell for Microsoft Teams.

  1. Read to the user data in excel sheet saved in the Share point and shows in the dashboard (for easy view)

  2. And, Run the MS teams PowerShell script automatically (or can trigger manually) when user data changes (may be SIP address) in the excel sheet.

  3. Update the changes done by the PowerShell as an output in the dashboard or data output.

Is there any Microsoft tool you can suggest to start with the above requirements?

Thanks in Advance

Regards,
MS




office-teams-windows-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JimmyYang-MSFT avatar image
0 Votes"
JimmyYang-MSFT answered JimmyYang-MSFT commented

Hi @MS-5605

What is your meaning of Dashboard? Do you mean Teams admin center Dashboard?

We did not find such official tool to complete your requirements of export user data to Dashboard. But we find Power BI could connect Excel Files in Microsoft Teams. The following blog show the ways of how to connect Excel file in Microsoft Teams with Power BI for your reference:

https://www.epcgroup.net/how-to-connect-excel-file-in-teams-to-power-bi/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MS-5605

It has been a while, how is everything going?
If you have any update about this issue, please feel free to post back.

0 Votes 0 ·
MS-5605 avatar image
0 Votes"
MS-5605 answered MS-5605 edited

Sorry for the delay in reply. We are exploring with the power BI to have the dashboard. Thank you so much for the information.

Regards,
MS

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.