How to automate creation of catalog item using flow designer?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2025 06:39 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2025 07:22 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2025 08:28 AM
Hi @Sathwik1
Just to clarify — when someone uploads the Excel sheet, are you looking to automatically create a new Catalog Item in the system ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2025 10:37 AM
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! */
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-13-2025 07:27 PM
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.