web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send messages on speci...
Power Automate
Answered

Send messages on specific days to specific people

(0) ShareShare
ReportReport
Posted on by 25

Hello!
I need to create a flow that sends messages to teams on a weekly basis to specific people on certain days of the week according to a table in Excel. As shown in the screenshot below, the message should be sent when the value of a cell is different from "-".

vinimareco0311_0-1706016795323.png

I would like to know how I can do this filtering to send the message only to the right collaborators on their respective days. Making a table for each employee is out of the question, as this changes routinely.

Categories:
I have the same question (0)
  • Verified answer
    bscarlavai33 Profile Picture
    752 Super User 2026 Season 1 on at

    You can make a Flow that runs each day and then use the expression "dayOfWeek(utcNow())" to get the day of the week.  1 is Monday, 2 is Tuesday, 3 is Wednesday etc. So based on the result of that expression, you can then use the Excel connector to parse the excel table for the column of that specific day and email the people without the "-" value.

  • vinimareco0311 Profile Picture
    25 on at

    thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 60 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 54

#3
Expiscornovus Profile Picture

Expiscornovus 47 Most Valuable Professional

Last 30 days Overall leaderboard