How Can I call the Value from Config Excel in enterpriseframework

[Maryam_Almushikes]

Greeting UiPath Community,

How can I call a constant “Apple” value “Green” into the workflow. Please see the image below:

I used many methods and it always shows me this error message

Assign: Object reference not set to an instance of an object.

I tried to assign to variable same message. I tried to use the below code always shows same message Assign: Object reference not set to an instance of an object.

in_TransactionItem.SpecificContent(“Apple”).ToString
in_TransactionItem.(“Apple”).ToString
in_Config.SpecificContent(“Apple”).ToString
Config.SpecificContent(“Apple”).ToString

Kindly advice

[Yu_Richmond]

I am assuming you are using the initAllSettings workflow to output the dictionary.

you can use in_Config(“Apple”).tostring.
You cannot convert it to an integer using CINT since the value is not an integer character.

To check the value use a log message.

[vrdabberu (Varunraj)]

Hi @Maryam_Almushikes

Please Create the constant Apple and Value Green in Settings Sheet like below:

After that you can use like Config("Apple").ToString to get the value Green. Since the value is not an Integer you need not use CInt. See the below image for better understanding.

Please Specify in which process are you using this Apple constant? According to that I will help you with syntax.

Regards

[Jayesh_678 (Jayesh)]

Hi @Maryam_Almushikes

First fetch the constant value using:- in_Config(“Apple”).tostring

Then try to convert the same in integer, if it has numbers.

Thanks