News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Send email notificatio...

Power Automate - Building Flows

Unanswered

Send email notification based on excel due date

(0) Share

Report

Report

Posted on by 3xceln4ute

5

Hi,

I'm trying to build a Power Automate flow which send an email reminder once the due date is today date.

In fact, I'm not able to find a way filtering the rows containing the today date. It seems the output is decimal rather than date format.

Excel table

Error message

Filter array step config

Condition step config

The flow

Any help would be great...kind of stuck.

Thanks !

Categories:

Business Process Flows

All responses Img

All responses (3)

Answers Img

Answers (0)

Pstork1 64,161 on at

Like (0)

Report

Send email notification based on excel due date

In your Excel file what is the formatting for the column that is returning the Serial Date? If the List Rows is set for ISO 8601 then everything formatted as a standard date should be returning an ISO 8601 string.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog
3xceln4ute 5 on at

Like (0)

Report

Send email notification based on excel due date

Hi Pstork1,

This option is already selected.
Pstork1 64,161 on at

Like (0)

Report

Send email notification based on excel due date

Make sure to set the Date format under Advanced Options in your List Rows Present in a Table action. The decimal you are getting is called a Serial Date, that's the default format. But you can choose to have it give you an ISO 8601 date, which is what you want for filtering.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 143,867

#2

RandyHayes 76,308

#3

Pstork1 64,161

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans