Issue getting my flow to trigger based on cert expiration date.

[Casey_Walgren]

Hey everyone, SNOW noob here, I am having issues with Flow designer triggering. I am trying to get it to trigger every time a cert pulled from Digicert is 45 days from expiring. The action will be to update the priority from PRI 3 to PRI 1. The flow I designed works when use the test function on flow desiger OR if I go in and manually update ANY field within the CERT Task table. I would like this to automatically trigger for any cert task as soon as the 45 days threshold is reached. Any suggestions? 

[Anthony78 · Accepted solution]

Hi @Casey.Walgren 

You can create a flow like this

1.This will Tigger the flow on daily and then look up the record which are going to expire based on your  condition.

2.Then you can create a action to update the priority .

If this answered your question, please Mark Helpful and Mark as Correct Answer .

[dericwu]

Hi @Anthony78 ,

For this example, since the trigger runs daily, would it mean the notification will get sent everyday once past the 45 day mark?

thanks

[Anthony78]

Hi @dericwu ,

It won't send multiple notification . it will send one notification once it met the condition .

It's up to you to put or set condition for notification in loop or other condition to send on daily basis till they renew.

[SingL]

Hi I have one question to @Casey_Walgren  how are you testing your development works on the expiring certificates?