Send Email to each CI owner with CI name

[Community Alums]

Hi,

I have a catalog item to let user chose different type of CIs in 3 list collector variables.

Using flow designers, once request submitted and approved by CMDB team

1) We have to update CI status based on type 

2) group by CI 'Owned by' from all 3 list collector, then send email to each owner with details of all 3 types of CI

Ex of email - 

Dear owner,

Below CIs are retired [from List collector 1]

xxx

yyy

Below CI are in Stock for disposal. [from List collector 2]

ssss

Below CI are in in stock available [from List collector 3]

oioio

dfsdfdsf

sdfs

CMDB team

I am not sure which action to use to do the grouping and then draft the email.

Appreciate your help.

[Anshu_Anand_]

@Community Alums 

You may need to write an email script.

access each list collector and send notifications.

[Gomathi Kannan]

Hi @Community Alums ,

Just a thought, I haven't tried this solution

1. Create a hidden variable with type multi row variable set (include 4 questions like owner, Retire, in stock, Disposal) in your catalog item

2. Configure the On-submit catalog client script with logic to populate MRVS dynamically with CI owner & CI details

3. Finally configuration a notification on Requested Item(sc_req_item) and you can look up into MRVS to get the details and send the notification

BR,

Gomathi K