How to import Excel and set values in "Multi-Row Variable Set"

[Takumi Ando]

We use a record producer to originate requests to the Workforce Admin table[sn_hr_core_case_workforce_admin] for employee transfers.

I am using the Multi-Row Variable Set to enter multiple employee information in it, but I would like to register the information in a batch in Excel due to the large number of cases.

Is it possible to attach an excel file with user information on the request page and then add the contents of that excel file to the MRVS after the request is submitted?

I would like to know how to do this.

[Community Alums · Accepted solution]

Hi @Takumi Ando ,

Not possible directly.

A multi row variable set needs to have data entered manually and only stores data temporarily.

The excel load involves server side actions. Think of like this. There needs to be a feature that receives the excel sheet, then system has to attach the document in the Attachment table, then read data from the excel and finally do a redirect to your form containing the Multi Row Variable set. A Client script needs to re-populate the data in the Multi row variable set.

In short, it's possible, but involves bad UI and elaborate architecture 

Refer to this video in the article to kickstart : https://www.servicenow.com/community/developer-articles/service-catalog-import-spreadsheet-info-mult...