Creating a flow designer and generating csv

[vbalaji2]

See i want a flow designer -
See i have a catalog item with one filed as server name as lookup select box having reference table as cmdb_ci_server table with lookup field as name .
Through this catalog item if i select server name and order it then service now will automatically create a requested item right.
My flow designer condition is if i select any server name and send the requested item right in flow designer it shoukd automatically fetch the details of Operating system, owned by, ram , status along with server name and that i selected and dump this details in csv file and export it .

Please give me a solution i am trying this from past 4 days- 

[Ankur Bawiskar]

@vbalaji2 

you will have to use Flow action and handle this via scripting

check my article and enhance it as per your requirement

Generate csv file with the catalog variables and attaching to RITM record 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@vbalaji2 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@vbalaji2 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[yuvarajkate]

Create a new Flow in Flow designer and add a Trigger for Requested Item Created and add Condition as your Catalog Item. Add an Action to fetch records {Get Records Action}, add condition like [current.Requested_Item.variables.server_name], then add a Script Action to run a Script to get the required data in CSV file and then Send it to the Requested User via Email Notification.