Email password expiration notification using Power Automate

[RADical]

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!

[MarconettiMarco]

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

[RADical]

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.

[Anonymous]

@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.

[RADical]

@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.

[GSTew0828]

@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?

[VictorIvanidze]

Hi @GSTew0828,

please show your flow. 

[RADical]

@GSTew0828 

See below:

High level:

Expanded:

Branches:

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

[surya3727]

Send me full work flow..

[GSTew0828]

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.

[ITSYS]

HI RADical,

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

[Sheetla]

are the same solution works for synced users from on-premises to the cloud and cloud-only users?

[RADical]

The solution works for synced users as well. The environment I set this up in was running AD Connect to sync AD users to AzureAD.

[RADical]

Sorry for the late reply. The HTTP action is a premium function and requires a premium license. 

[VictorIvanidze]

Hi @RADical,

in fact you can use the non-premium action " Send a HTTP request" from "Office 365 Groups" connector.

[EmrahGultekin]

Hello my friend

Can you share your flow?

[RADical]

It's a very large flow. Which portion of the flow do you need help with?

[EmrahGultekin]

Hello RADical

I need all of your flow.

Can you share your workflow or can you share workflow's screenshots?

My email is below.

emrah.gultekin@argela.com.tr

Thank you so much

[Ayotunde]

Hello RADical,

I know you have heard this a thousand times. Would you be so kind to send me the flow too? My email is ayotunde161@gmail.com. Thanks in advance

[nadian]

Hi @RADical ,

Can I have the entire flow as well please? email is rnadia10aug@gmail.com.

Thank you so much