Reminder email 30 days before date on excel

Like (0) Share

Report

Posted on 6 Mar 2023 22:11:14 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,506 Most Valuable Professional on 28 Mar 2023 at 11:44:21

Like (0)

Report

Re: Reminder email 30 days before date on excel

So you don't have any filter? See below.
Jtaylor95 126 on 28 Mar 2023 at 10:04:05

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,506 Most Valuable Professional on 23 Mar 2023 at 23:37:12

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 23 Mar 2023 at 12:11:34

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,506 Most Valuable Professional on 23 Mar 2023 at 10:52:34

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hi @Jtaylor95

Yes that's causing the issue.

Thanks
Jtaylor95 126 on 23 Mar 2023 at 10:02:33

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,506 Most Valuable Professional on 23 Mar 2023 at 09:48:21

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 23 Mar 2023 at 09:30:46

Like (0)

Report

Re: Reminder email 30 days before date on excel

Hoping this is what you need - thanks!
abm abm 32,506 Most Valuable Professional on 22 Mar 2023 at 23:20:10

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 22 Mar 2023 at 18:34:00

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.