Send notification if account expiry in 30 days

Biddaum
Tera Guru

On our user profile we added some time ago a field called "u_account_expiry".

What I need to do is send an email notification to the user and their manager if the users account expiry will occur within the next 30 days.

 

How would I go about getting the 'list of users' that fit into that category to add as the recipient in a notification?

 

I figured I could do it in a flow or a scheduled job, but either way I don't know how to generate the list of users and their managers.

1 ACCEPTED SOLUTION

Mark Roethof
Tera Patron

Hi there,

 

You could create a daily Scheduled Flow, query through all the users where u_account_expiry is 30 days from now, and create a notification to that user and their manager.

 

Give it a try.

View solution in original post

5 REPLIES 5