Unanswered

Email based on due date in Excel

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone!
I saw a lot of topics but none fit with I need.
On this topic: https://powerusers.microsoft.com/t5/Building-Flows/Reminder-email-based-on-due-date-in-excel/m-p/1028705#M136778 MS Flow send me an e-mail with all the dates, but not the actual due date.

It's possible to receive the real due date? For example, line 1 due date is 01/01/2023, line 2 is 05/05/2023 and I receive only one e-mail on that date.
I also tried to insert a "reminder" column but no success.

I'm running a flow everyday and somethings that have due date in 2024 are sending e-mails. Basically MS Flow is sending 1 email per line informing the due date everyday.

I want to send on the actual due date. I've tried many things but no success 😞
Flow keeps me sending all my 25 rows thru e-mail.

Any tips?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Could you please post some sample Excel due date data? Is this stored as dd/mm/yyyy format? or just year only?

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Thanks for the reply!
It's dd/mm/yyyy. It's a simple excel file:
Subject Reminder Due Date
Test 1 01/01/2023 02/02/2023
Test 2 10/10/2023 11/11/2023
Test 3 05/05/2023 06/06/2023

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

What's the data type of your Excel column Due Date?

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

There are couple of videos I made related to this. Hopefully this is useful.

https://www.youtube.com/watch?v=r1LhHU5lXkM&t=191s

https://www.youtube.com/watch?v=uFZxXMuLj-E

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi!
It's in Date format.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Didn't worked very well.
I've created just like you did on YT and sent me 25 emails again (one for each line) lol 😞

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

hi @Anonymous

Could you post a screenshot of your flow please?

Thanks

Was this reply helpful? Yes No