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

Notifications

Announcements

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 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard