Excel and Teams Integration: getting Channel name from Excel

Slava Shamak 0 Reputation points
2024-01-26T06:12:15.8266667+00:00

I have an Excel spreadsheet that I embed as a tab on Teams Channel. The worksheet has many columns, one of them is "Project". I'd like to automatically filter our rows on the Excel by Project Name = Channel when the user opens the tab. Is it possible to get Channel Name where the file is embedded from the Excel file

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,321 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
3,692 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Wajeed-MSFT 311 Reputation points Microsoft Employee
    2024-01-31T06:27:39.66+00:00

    If you have a custom app then you can get the channel name in a configurable tab using Teams JS SDK.More Info: Get context by using the Microsoft Teams JavaScript library
    User's imageExcel app provided by Microsoft does not provide option to filter data based on channel name.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.