How to automate creation of catalog item using flow designer?

Sathwik1
Tera Expert

I’ve created a catalog item that all business leaders can use to automatically submit requests for creating new catalog items.

 

The process is as follows.

Business leaders will prepare an Excel file, where

i) Sheet 1 includes details such as the 'Name,' 'Short Description,' 'Description,' 'Meta,' 'Category,' and other relevant information.

ii) Sheet 2 will contain the variables related to the catalog item.

 

Once the Excel file is ready, business leaders simply upload it and submit the request. The Flow Designer will then parse the Excel file and automatically create the catalog item along with its associated variables.

 

Can anyone help with implementing this requirement?

 

@Ankur Bawiskar 

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

@Sathwik1 

this is achievable but somewhat complex requirement.

If any business person gives incorrect details such as variable types then logic might break

see this link for starting point and enhance

Bulk Catalog item request using an excel file 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

1__PrabakaranC
Tera Contributor

Hi @Sathwik1 

Just to clarify — when someone uploads the Excel sheet, are you looking to automatically create a new Catalog Item in the system ?

GlideFather
Tera Patron

Hi @Sathwik1,

 

wouldn't it be more effective to have (maybe a bit complex) catalog item where you would have all the fields?

For example variable with options: Create, Update, Deactivate and based on these values you would have another fields displayed and you would be already checking the types and everything within a form, so it couldn't for example happen that you would receive an empty value because that would be mandatory.

 

You would have there MRVS for the fields, their type, order, mandatory/visible

 

We had something like this and I must say this was very good method how to unify many requirements of catalog items or even record producers, you always get the same form which is easier to develop. Excel will be always little bit different and some fields might be empty, here you would have the direct check on mandatory field(s)....

 

Consider doing this, it might be high efforts but it can save much energy and time in future.

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Di Zhang
Tera Guru

This one should used import set to implement. Combine your sheet 1 and sheet 2. and add transform map and after transform script to it .  the catalog item will be add by transform map. the variables and others will be added by after transform script. But there is no client script and UI policy.