Others

How to Automatically Post Excel Data to a Microsoft Teams Channel

Olivia MillerOlivia Miller Oct 10, 2026 872 views

Question details

The user wants to automate the process of posting selected data from an Excel spreadsheet to a Microsoft Teams channel whenever a specific status column is updated to 'In Progress'.

How to Automatically Post Excel Data to a Microsoft Teams Channel
Product
Microsoft Excel, Power Automate
Device & OS
not provided
Scenario
Setting up a workflow to monitor an Excel document and automatically send notifications with row data to a Teams channel based on a specific cell value.
Observed behavior
The user needs to configure a Power Automate flow that accurately filters Excel records for the 'InProgress' status and posts those values to Microsoft Teams.
Before you start

Ensure your Excel data is formatted as a Table (Insert > Table), as Power Automate requires formal tables to read rows properly. Also, verify that your Excel file is saved in OneDrive for Business or SharePoint.

Solution 1Recommended

Use Power Automate to Post Excel Data to Teams

Set up a flow in Power Automate to check your Excel table for specific statuses and send automated messages containing the row data to a Teams channel.

Power Automate connects Excel Online to Microsoft Teams seamlessly. By using an OData filter query, you can instruct the workflow to pull only the rows that meet your specific criteria (e.g., 'In Progress').

1
Format your Excel data as a table

Open your Excel file, highlight the range containing your data, go to the 'Insert' tab, and click 'Table'. Make sure your table has clear column headers, and save the file in OneDrive or SharePoint.

2
Create a new Power Automate flow

Log in to Power Automate, click 'Create' on the left menu, and choose 'Scheduled cloud flow' (to check the file at regular intervals) or an 'Automated cloud flow' if using an exact trigger event.

3
Retrieve and filter the Excel rows

Add the 'List rows present in a table' action for Excel Online. Select your Location, Document Library, File, and Table. In the advanced options, use an OData Filter Query to select the specific rows, such as `Status eq 'InProgress'`.

4
Configure the Teams post action

Add an 'Apply to each' control for the retrieved rows. Inside it, add the 'Post message in a chat or channel' action for Microsoft Teams. Choose the desired Team and Channel, and use the dynamic content menu to insert the Excel column values into the message body.

5
Test your automation flow

Save your flow and click 'Test' in the upper right corner. Perform a manual test by ensuring at least one row in your Excel table has the 'In Progress' status, and verify the message appears correctly in Teams.

Filter Expression Syntax: Ensure your OData filter query matches the exact column name without spaces. For example, if your column is named 'Column10', your expression should be: Column10 eq 'InProgress'.
Free Microsoft Office alternative

Looking for a fast and lightweight Office alternative?

While advanced workflows like Power Automate require the Microsoft 365 ecosystem, WPS Office provides a powerful, free, and highly compatible alternative for your everyday spreadsheet, document, and presentation needs. It fully supports Microsoft formats and offers a familiar, easy-to-use interface.

  1. 1. Download WPS Office: Visit the official WPS website and click 'Download WPS Office Free'.
  2. 2. Install the software: Run the downloaded installer and follow the on-screen instructions to complete the setup.
  3. 3. Open your files seamlessly: Launch WPS Spreadsheets to instantly open, edit, and save your existing Excel documents without losing any formatting.
100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight design ensures smooth performance even with large datasets.Familiar user interface guarantees a zero-learning-curve migration.Built-in PDF toolkit and advanced spreadsheet templates for enhanced productivity.
microsoft office alternative - wps office

Frequently Asked Questions

Why is Power Automate not recognizing my Excel data?

Power Automate can only read data that is formatted as an official Excel Table. To fix this, open your spreadsheet, highlight your data, press Ctrl+T (or Insert > Table), name your table, and ensure the file is saved in an online location like OneDrive or SharePoint before building your flow.

Do I need a premium license to connect Excel and Teams?

Standard connectors for Excel Online and Microsoft Teams are generally included in most standard Microsoft 365 business and enterprise subscriptions, so a premium standalone Power Automate license is usually not required for this basic flow.

Can I format the automated message posted in Teams?

Yes. In the 'Post message in a chat or channel' action within Power Automate, you can use the rich text editor or basic HTML to format your message. You can also mix static text with dynamic content blocks representing specific Excel columns to fully customize the output.