Update Records via excel through catalog item

VuchiV
Tera Contributor

‎08-27-2024 08:48 AM

Hello All,

 

I have a requirement to create a catalog item which will be submitted with an excel sheet attached. In the excel , there will be list of KB articles and their corresponding managers list to be updated. 

 

Once, catalog item is submitted, the attached list of KB's needs to be updated with the managers mentioned.

 

Please provide me a solution to configure this requirement.

0 Helpfuls
  • 344 Views
1 REPLY 1

Hajar BENJAHHAR
Mega Sage

‎08-27-2024 01:29 PM

Hello VuchiV, 

 

You can create a catalog item that accepts only an Excel file, and automate the process using flow designer, you can refer to this article as a starti,g point for configuring your requirement:   https://www.servicenow.com/community/developer-blog/data-load-and-transform-via-catalog-item/ba-p/22... 

 

Remimber to use flow designer instead of workflow and ensure you set coalesce to true for number field in your transform map. 

 

I hope this helps!

 

Best regards, 

Hajar

0 Helpfuls