cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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

5 REPLIES 5
Dual Super User II
Dual Super User II

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

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

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

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,148)