Retriving Catalog item variables from table and sending them to approval based on the field.

[jitendrag]

Hello EveryOne,

I have requirement where we have imported around 30K records from third party tool into our custom table. In this custom table we have the name of the role, owned by , approval type ,service offerings and FID fields. Based on the FID and service offering now I am creating catalog items. I am using list collector variable and retrieving the data from the table. Now I have to configure the flow and send the selected roles from list collector based on the approval type field in the table.

For example If requested item has 5 roles with approval type regular and 5 with regular and manager and 5 with manager and service owner. For approval type regular I have to create one catalog task  and add all the 5 roles to the description. For approval type reqular with manager I need to send the approval request for each role and create catalog task. if approval is approved  Same for Approval type Manager and service owner.

Can anyone please help me how can I achieve this using flow designer. 

Thanks in advance.

Jitendra

[BillMartin]

Hi @jitendrag ,

I have created this video to guide you on how to create a flow using flow designer.

Here is how: ServiceNow Workflows: How to Create a Workflow in ServiceNow Using Flow Designer

Please like and mark as accept solution if you find it lucrative.