Bulk user selecting in catalog item through excel sheet importing

[Manohararuna]

Hello Everyone,

        I have one requirement,

In catalog item having the Requested for field  and it is a list collector type abd reference table is sys_user table.

But suppose at the time selecting 100+ user it will take time ,so in place of this client going tp import users list through Excel sheet , that list user data visible into Requeted for field then he will able to select all user at time 

2) Catalog item havinng the attachement symbol, if attached excel sheet , in side excel  sheet users related email address can be populated into Task description filed(whatever task created under RITM) 

Provide solution to the above requirement.

Thanks,

manohararuna

[Ankur Bawiskar]

@Manohararuna 

If you are using workflow for your catalog item then you can use workflow run script

parse the excel and create those many sc_task

Parsing the Excel Sheet data & Use the data In automation via Request Item(Catalog Item) 

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

[Ankur Bawiskar · Accepted solution]

@Manohararuna 

based on rows in the attached excel you want those many catalog tasks?

If yes then in your flow you will have to create flow variable of type Integer, use GlideExcelParser and determine the number of rows

Then use For Each based on that count and create tasks

check this link

Increment integer flow variable in each loop until variable reach 5 not working with below approach 

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

[Ankur Bawiskar]

@Manohararuna 

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.

[Rafael Batistot]

Hi @Manohararuna 

If you want to handle excel spreadsheet to filled some fields via catalog I suggest that you use GlideExcelParserScoped API

https://www.servicenow.com/docs/bundle/zurich-api-reference/page/app-store/dev_portal/API_reference/...

Create a Business Rule, after > insert 

condition: item > <name_of_catalog> and provide some scrip as documentation mentioned 

I already did in a project, it not easy because you need to mapping each column with each value and reference in your field In ServiceNow. 

This work, but it’s a hardcode method