Send email notification based on excel due date

(0) Share

Report

Posted on by 3xceln4ute

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:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
3xceln4ute 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Pstork1,

This option is already selected.

Was this reply helpful? Yes No
Pstork1 69,397 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
3xceln4ute 15 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The cell format is set to be compatible with ISO8601.

As you can see, the date still decimal despite the fact thta the format is correct in excel table.

But in the other hand, the date of starting (column B) is correct, same cell format as column M.

I'm having a headache to figure out a solution.

Thanks

Was this reply helpful? Yes No