Unanswered

Sending email notification 10 days before the expiry date in power automate?

(0) Share

Report

Posted on by Sebey

127

I have the following Sharepoint online list( data is sample); a user should get a notification email 10 days before the expired date of the issued driving permit.

I want to automate this using power automate. a user must get an email notification before 10 days of the "expireddate" date.

the email format will be something like this:

Hello firstname,

Your driving permit was issued on "issuedate" and will be expired on "exipreddate".

Kindly issue new one!

--------

firstname	lastname	email	userid	issuedate	expireddate	status
Meaza	Hagos	meaza@mysite.com	meazaha	October 11,2020	November 05,2023	active
Helen	Mike	helenmike@mysite.com	helenm	April 20,2022	October 15,2023	Active
Petros	Haile	petrosh@mysite.com	petros	August 15,2023	December 25,2023	active
John	Gebre	johngebre@mysite.com	johngebre	July 28,2023	October 30,2023	active

each user receives email only about his own information when the 10 days to go to expire.

how can I do this, any hints?

your help is appreciable!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Michael E. Gernaey 53,325 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Sebey

Can you share your flow and what you tried? There are so many examples of doing this over and over. Did you search or just ask for help? Just want to make sure I dont rewrite a flow you already have.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Hi @Sebey ,

You can create a flow that runs every day, iterates through the records in the list, gets the email address if the expiration date is ten days away from current time, and sends the message.

I did some tests that you can refer to:
The expression in condition:
div(sub(ticks(items('Apply_to_each')?['expiredate']),ticks(utcNow())),864000000000)

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Sebey 127 on at

Like (0)

Report

thanks this works fine, but the condition does not check correctly. you used the function : "Div"(divided) instead it should be current date minus the expired date, then format to check only the day value.
the above flow sends email to each user without checking the number of days. I think it needs little amendment.
I tried to make it:
int(split(dateDifference(items('Apply_to_each')?['expireddate']), utcNow(), '.')[0])
but it gives me error.
can double check it please?

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @Sebey ,

I just modified my expression, please try it:
div(sub(ticks(utcNow()),ticks(items('Apply_to_each')?['expiredate'])),864000000000)
The above expression is used to calculate the number of days from 'expiredate' to today.

You can also modify your expression:
int(first(split(dateDifference(items('Apply_to_each')?['expiredate'], utcNow()),'.')))

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Sebey 127 on at

Like (0)

Report
here is the follow:
today is: 20/10/2023
exipreddate: 30/10/2023
since the gap is 10 days, email is expected for the user, but still i tried both of your expressions and the follow doesnot give error, but it always provide false conditions
condition expression as per your solutions, I tried both
div(sub(ticks(utcNow()),ticks(items('Apply_to_each_2')?['expireddate'])),864000000000)
int(first(split(dateDifference(items('Apply_to_each_2')?['expireddate'], utcNow()),'.')))
column: expireddate:
the result shows me always false:
Kindly assist!

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @Sebey ,

What type is 'exipredate'?
Add a compose to check the output of expression:

Was this reply helpful? Yes No
Sebey 127 on at

Like (0)

Report

int(first(split(dateDifference(utcNow(),items('Apply_to_each_2')?['expireddate']),'.')))
Now I Understand the date calculation is working fine but as long as the condition is true, it sends notification to all users.
User 3: number of days remaining for expiry date=10 [ email sent]
user 2: number of days=8 but notified

user 3, date difference is 78 but got notified:

The email sends to all users, whenever the condition becomes true, I want to send notifications only to the user whose condition is true!
I appreciate all your supports!

Was this reply helpful? Yes No
Sebey 127 on at

Like (0)

Report

I added a get item list above the condition then use the expression on the condition, it works fine now.

Was this reply helpful? Yes No