Flow designer - Automate the Submission of Service Catalog

[SingL]

Hi everyone! 

I have few steps to automate 

Step 1 - Check for all expiring certificates which will be expiring in next 30 days in xyz_table.

Step 2- For all expiring certificates( in next 30 days) submit an existing Service Catalog with the certificate number field available from the Service catalog. 

Step 3 - First level of approval goes to abc_table support group.

Conditions - If anyone approves the RITM then create a new certificate in the same table with all details from old certificate and additional details of new expiring date in the new certificate record. 

If anyone rejects - the certificates will be allowed to automatically expire

Step 4 - Second level of approval if none approves or rejects first level in 1 weeks of time - trigger approval to 'TEST GROUP'.  

Please let me know if this can be achieved using a flow designer or any other approach will be fine.

Thanks in advance. 

[Uncle Rob · Accepted solution]

Yes, should be pretty easy too:
Step 1 sounds like simple Look Up Records action.
Step 2 will use a combo of For Each (of Step 1's lookup) and then the Submit Catalog Item action.
Step 3 and everything after wouldn't be part of the main flow, but rather whatever flow governs the Catalog Item you're wanting to submit.

You need to split this up into TWO things.
"What is the flow to do this one at a time" (that's step 3 and 4)
"What is the step to orchestrate them?" (that's step 1 & 2)