Catalog item attachment(Excel) added into Multi Row variable set.

[dhineshkumar]

Hi Experts 

I have the attachment of the catalog item and I added the attachment excel sheets to that catalog item and I want that data in my catalog item multirow variable set.

Thanks in advance.

[Sohail Khilji]

Hi @dhineshkumar ,,

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.

-Thanks to sandeep

In short, it's possible, but involves bad UI and elaborate architecture see this > https://www.servicenow.com/community/developer-forum/populate-mrv-in-a-record-producer-with-data-by-...

[Sumanth16 · Accepted solution]

Hi @dhineshkumar ,

https://www.servicenow.com/community/developer-forum/how-to-populate-data-in-multirow-variable-set-f...

https://www.servicenow.com/community/developer-articles/service-catalog-import-spreadsheet-info-mult...

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda