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?

Categories:

Building flows

I have the same question (0)

All responses (21)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Hawksmoor

26-Mar-25 is this means

26-03-2025?

Could you make the Excel data as follows:

26-Mar-2025?

Then it will be easier to convert to Date using ParseDateTime()

formatDateTime(parseDateTime(outputs('Compose')), 'yyyy-MM-dd', 'en-US')

This will return 2025-03-26

Then to find 30 from Todays Date use the below expression

addDays(utcNow(),30,'yyyy-MM-dd')

Finally compare both dates from the expression to check whether it is matching the date or not.

Note: To read the excel sheet you need to have a table associated with it.

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report
Copy link

Link copied!

Are you able to explain in a little more detail? Sorry Im not very well versed in this so not sure what steps to use

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

Like (0)

Report
Copy link

Link copied!

Hi @Jtaylor95

Will update soon.

Thanks

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

Like (0)

Report
Copy link

Link copied!

Hi @Jtaylor95 @Hawksmoor

Follow the below steps:

Above expressions are as follows:

formatDateTime(item()?['Expiry Date'], 'yyyy-MM-dd')

addDays(utcNow(), 30, 'yyyy-MM-dd')

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report
Copy link

Link copied!

Hi I am getting the following error:

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(formatDateTime(item()?['Expiry Date'], 'yyy-MM-dd'), addDays(utcNow(), 60, 'yyyy-MM-dd'))' failed: 'In function 'formatDateTime', the value provided for date time string '45742' was not valid. The datetime string must match ISO 8601 format.'.

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

Like (0)

Report
Copy link

Link copied!

Hi @Jtaylor95

Check the DateFormat and set to ISO 8601.

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (0)

Report
Copy link

Link copied!

I had done that already but no joy

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (1)

Report
Copy link

Link copied!

I think I need to convert my the date time string but not sure how!

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

Like (0)

Report
Copy link

Link copied!

Hi @Jtaylor95

Could you post a screenshot of your flow history and would like to see the dates getting from List Rows present in a table action step.

Thanks

Was this reply helpful? Yes No
Jtaylor95 126 on at

Like (1)

Report
Copy link

Link copied!

These are the error details:

Was this reply helpful? Yes No