Answered

Email password expiration notification using Power Automate

(2) Share

Report

Posted on by RADical

164

I have the flow below which fetches the lastPasswordChangeDateTime from Microsoft Graph and filters an array of users by their UPN and lastPasswordChangeDateTime. The current flow sends out a password expiration notification to end users one day before their password expires which works. I wanted to expand this; however, to find users with passwords about to expire between a specific start and end date and then send daily emails until the password expires. for example, 7 days before the password expires I want to start sending a password expiration email daily with the days counted down in each consecutive email with the last email stating their password has expired.

Email 1: your password expires in 7 days
Email 2: your password expires in 6 days...

...

Email 7: Your password has expired.

Any help with this would be much appreciated. Thank you!

Categories:

Building flows

I have the same question (2)

All responses (50)

Answers (2)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Hello @RADical ,
you can follow these steps:
1. Filter the array based on these condition:
expiring date less or equal than:
formatDateTime(addDays(utcNow(),7),'yyyy-MM-dd')
expiring date greater than or equal to:
formatDateTime(utcNow(),'yyyy-MM-dd')
all the dates must have the same ISO 8601 format;

2. Add a Compose action in which put the following expression (instead of my sample data, put yours):
div(sub(ticks(formatDateTime(items('Apply_to_each')?['DueDate'], 'yyyy-MM-dd')),ticks(outputs('Compose-Today'))),864000000000)
The expression is useful to count the days between two dates (the expiring date and the current date).

3. Add a Condition control: if the previous Compose action is not equal to 0, send an email telling that "your password expires in X days" (instead of "X", put the Compose outputs), otherwise send an email telling that "Your password has expired.".

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
RADical 164 on at

Like (1)

Report

Hello @MarconettiMarco

Thank you for your reply!

I'm still a little new to Power Automate and the concept of using tick is new to me, so please forgive my ignorance. I wanted to clarify a few things.
1) Currently, I can only extract the last time the user changed their password and not when the actual password expires (90 days from when their PW is first changed). So I'm using the below action to filter output of all users who last changed their password 83 days ago. This would give me all users who will need to change their password which will expire in 7 days.
2) I need to send an email to the users outputted in the action above on the 83rd day (7 days prior to their PW expires) letting them know their password will expire in 7 days. This will run daily to find all users who fall within the 7 day PW notification period.
3) I want to generate daily reminders to everyone who fall within that notification period and count down the days until the password expires in the email.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@RADical Were you able to set it up? It will be of great help if you can share the complete flow details for reference. We have similar requirement and this seems to be the best option.

Was this reply helpful? Yes No
RADical 164 on at

Like (1)

Report

@Anonymous I ended up going a different route by using a branched action approach. It's not ideal if you're doing more than a handful of reminder days, but it satisfied my requirements.

Was this reply helpful? Yes No
GSTew0828 5 on at

Like (1)

Report

@RADical
trying to set this up as well and currently banging my head against the wall.
would you be able to share your flow details so I can see where I'm going wrong?

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report

Hi @GSTew0828,

please show your flow.

Was this reply helpful? Yes No
RADical 164 on at

Like (3)

Report

@GSTew0828

See below:

High level:

Expanded:

Branches:

I hope this helps. Private message me if you have questions.

Was this reply helpful? Yes No
surya3727 2 on at

Like (1)

Report

Send me full work flow..

Was this reply helpful? Yes No
GSTew0828 5 on at

Like (1)

Report

just looking through yours, I wasn't reformatting the last change date so it still had the time assigned, which when I'm trying to match just the date wouldn't produce an output.
That's what I get for doings late at night.

appreciate the help, can finally move on to the next stage.

Was this reply helpful? Yes No
ITSYS 28 on at

Like (1)

Report

HI RADical,
Thank for your share. Please let me know action ' Get GrapAPI' is free or must have purchase for it ?

Was this reply helpful? Yes No