Hi everyone,
I created a super simple birthday notification in Power Automate, but it seems to be skipping the "Post message in a channel or chat" step. What should I do to ensure the post is made in the Teams channel
Compose 2 input is :
@tiger10 Your condition has returned as false meaning no items matching your condition were found. You'll need to troubleshoot this. However, I would recommend that you use a Filter Array action instead of looping through each item returned from the Get Items action and running a condition check.
The Filter Array action will first filter your items before looping through them. Take a look at this YT Tutorial: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate
Although, I cover how to send an email in this flow, you can replace that action with the Post a Teams Message in a Chat or Channel action.
In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.
This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:
đź“… Student Birthdays
đź“… Project Due Dates
đź“… Contract/Membership Renewals
đź“… License Expirations
đź“… Client Anniversaries
IN THIS VIDEO:
âś… How to Send an Email based on a Date Column in SharePoint
âś… Using the Recurrence Trigger in Power Automate
âś…How to Use the Filter Array Action with multiple conditions
âś… How to Get Dynamic Content from a Filter Array Action
âś…How to Get a Date Three Days from Today
âś… How to Create a Dynamic Date Based on utcNow()
âś… How to Return a Count of Items
âś… How to initialize and set a variable
âś… How to use the Send an Email (V2) action
âś… How to send test emails
---
For more flow troubleshooting tips—check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!
IN THIS VIDEO:
âś… How to troubleshoot a false Condition action result
✅ How to get dynamic content when it isn’t selectable from the list of dynamic content
✅ How to troubleshoot an Apply to Each action that isn’t looping through
âś… How to troubleshoot a skipped Apply to Each action
âś… How to troubleshoot a Filter Query
âś… How to use a SharePoint yes/no column in a Filter Query
âś… How to use Compose actions to troubleshoot a Power Automate flow
âś… How to troubleshoot multiple emails being sent
âś… How to troubleshoot multiple Teams messages being sent
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2