Auto task generation for user account extension which are going to be expire

[bisht231988]

Hello, I have one requirement in my console that whenever any user account going to be expire I need an auto task ticket will generate for the particular team who can work on that task. Please give me some solution for this.

[Bhavya11]

Hi @bisht231988 ,

is any custom field holds  expiration date of user?

if yes then scheduled job  then run everyday to check any user going to be expired if so then create task for particular team .

if my response was useful, I would appreciate a "helpful" and an accepted solution

Thanks,

BK

[Ankur Bawiskar]

@bisht231988 

if some field is holding the expiration date then you can use daily scheduled flow and trigger a task creation

No scripting required

check below

You can use Flow Designer which would run Daily and check if today's date is same as Due Date

If yes then send the email to your recipients, subject and email body

1) Flow Trigger Daily 23:00:00

2) Use Lookup Records action on your table to check if that expiration date is today

3) Then use For Each to iterate over those records

4) then use "Create Task" flow action (In example I used "Send Email" action) but you can change that

check link in case images cannot be seen, that link has post from me where you will see the same steps

I cannot seem to get an Email Notification when a record's due date is reached 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@bisht231988 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.