Dear Sir or Madam,
Specifically, can the current SailPoint Identity Security Cloud Workflow be set up so that, after each certification campaign is launched, a reminder email is automatically sent to the reviewers 7 days before the campaign’s end date, urging them to complete their tasks?
Currently, we know that it’s possible to configure workflows based on certification completion percentage, but what about time-based conditions? Should we use custom variables or other methods?
If anyone has implemented a similar use case, please feel free to share your experience.
I’ve seen many suggested solutions on the forum that rely on using the wait action. However, since each certification has a different end date, I’m wondering if it’s possible to use the certification end date to calculate or set a reminder time to send notification emails accordingly.
you can access expiration using expression $.certification.expiration
to use the certification due date for calculation and reminders you can use function spTools.formatDate() it allows you to format date
$spTools.formatDate($certification.expiration)