Update constant smart service

The "New Value" parameter is a list type. Did you try to pass a list like {1, 2, 3}?

What you cannot do, is to change the constant from a non-list to a list type.

what I am doing like ,I am uploading a excel sheet where I have 2 column name and value .And after fetching data from excel , I stored the names in one variable and values in another variable .i am using update constant service as MNI on the basis of values stored variable .

How can i achieve in this scenario ?

Please help me understand why you update a constant multiple times?

We need more details. Any code snippets or screenshots?

I am using that constant in a interface for showing helptext for any field in the interface. If the business wants to show different text in future the business only have to upload the excel with new value and the interface will show the updated helptext .

bisheswar01 , you don't need to run update constant smart service multiple times here.

For your scenario you can have a constant of array type and use the same in the smart service.

If you are extracting multiple values from excel, just push those (pv where you have all the values) into NEW value and the smart service should update as needed.

It's Unclear what you are saying , Are you trying to Update multiple constants at single go, Based on names ? . 

I have an alternate Approach for your use case , Maintain all the tooltips in Separate table and give admin (Site Admin) option to download whole or required bunch in Excel  format and let him do the updates on downloaded file and Use WriteExcelToDB(I'm not sure about update command , give it a try) 

if there is two constants and there are 5 values to be stores as an array and all these are in a single excel sheet ,then how you are going to do ?

You can run multiple update constant smart service nodes to store these values.

Better approach:

Instead of creating many constants in this scenario, try having a table which holds different values in different columns. 

And in your process, you can write the document extracted data in your table and query the saved data in your interface.

You can run multiple update constant smart service nodes to store these values.

Better approach:

Instead of creating many constants in this scenario, try having a table which holds different values in different columns. 

And in your process, you can write the document extracted data in your table and query the saved data in your interface.