reminder before the due date

[Rehab_Hassan10]

I need to build a flow to send a reminder before a week of an Expiration date (date coloumn in a sharepoint list). Flow to be run daily but the reminder to be send on the same item every 1 week till the expiration date renewed.

I did already the simple scenario as below:

1. Recurrence

2. Get items

3. Apply to each --> Condition (ticks(item()?['ExpirationDate']) is less than ticks(utcNow())

but it doesnt satisfy my scenario, any help?

[RezaDorrani]

Hi @Rehab_Hassan10 

 Condition (ticks(addDays(utcNow(),7)) is greater than or equal to ticks(item()?['ExpirationDate'])

This will start sending the expiration email 7 days before the expiration date 

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Rehab_Hassan10]

it keeps sending me email for every entry

[Anonymous]

hi @Rehab_Hassan10 

i suggesting you to using filter array,

@lessOrEquals(formatDateTime(addDays(item()?['set with your date field'], -7), 'MM/dd/yyyy'), utcNow('MM/dd/yyyy'))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-bacao-msft · Accepted solution]

Hi @Rehab_Hassan10 ,

Please try to use the following method to achieve your needs.

Expression reference:

formatDateTime(item()['ExpirationDate'],'yyyy-MM-dd')

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

Image reference:

Best Regards,

[Moin89]

But condition will become a false. what i can write in filter query of GetItems Action