How to Automatically Post Excel Data to a Microsoft Teams Channel
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'.

- 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.
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.
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').
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.
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.
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'`.
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.
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.
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. Download WPS Office: Visit the official WPS website and click 'Download WPS Office Free'.
- 2. Install the software: Run the downloaded installer and follow the on-screen instructions to complete the setup.
- 3. Open your files seamlessly: Launch WPS Spreadsheets to instantly open, edit, and save your existing Excel documents without losing any formatting.

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.




