Unanswered

Reminder email 30 days before date on excel

(0) Share

Report

Posted on by CU30070936-6

Hi Im looking for help building a flow that triggers an email reminder to be sent 30 days before a date listed on an excel file (30 days before expiry date)

Screenshot 2023-03-06 at 22.10.16.png

containing details of the excel row in question.

Can anyone assist?

All responses (21)

Answers (0)

abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

So you don't have any filter? See below.
Jtaylor95 126 on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

I dont have anything in the filter query box. Can you advise what I need to put in here please?
abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hi @Jtaylor95

Could you post a screenshot and the expression of your filter query?

Thanks
Jtaylor95 126 on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

Its now sending me the email reminder for every data line. I need the flow to only trigger if the expiry date is 60 days from today. Im not sure where Im going wrong here

Sorry!!
abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hi @Jtaylor95

Yes that's causing the issue.

Thanks
Jtaylor95 126 on at

Like (1)

Report

Re: Reminder email 30 days before date on excel

All the other lines are coming through the same.

There are some bits of missing data but thats because its not been filled out in the excel table yet (see lines 14-16). Is this whats causing the problem? Do I need to remove all data lines that arent fully filled in?
abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hi @Jtaylor95

I can see the expiry date. Could you check all other expiry dates? Is that any missing any info?

Thanks
Jtaylor95 126 on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hoping this is what you need - thanks!
abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hi @Jtaylor95

Could you check the run history and see what's the value of Expiry Date? Post a screenshot please?

Thanks
Jtaylor95 126 on at

Like (1)

Report

Re: Reminder email 30 days before date on excel

Hi I am having the following error:

The 'start index' for function 'substring' must be equal to or greater than zero and must be less than '0' which is the length of the string.