cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rehab_Hassan10
Frequent Visitor

reminder before the due date

Flow.PNG

 

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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

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:

40.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
RezaDorrani
Dual Super User
Dual Super User

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

 

 

it keeps sending me email for every entry

Anonymous
Not applicable

hi @Rehab_Hassan10 

 

i suggesting you to using filter array,

 

CaptureCm.PNG

 

@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
Community Support
Community Support

 

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:

40.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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

caloykokoy
New Member

I need a flow like this but the scenario is:

 

Flow will be applied in my SharePoint List

Flow reoccurrence is everyday (Philippine Standard Time)

It will send an email reminder 90 days, 60 days and 30 days before the expiration date

My expiration date is auto-calculated so it is not in Date format

 

Please Help. Thank you.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,963)