Use dynamic column fields

[Erika_Papp]

Hi All, 

During the business process I need to read value from a 1 row collection and based on the criteria I always need to read different column.
I dynamically generate the column name I need to use: 

This calculation gives back the correct expression but is is handled as a string not as a collection expression so the output will be [Country list.Country Code] instead of a value like GB. 

Could you please help how should I use this?

------------------------------
Erika Papp
RPA Specialist
Winformatics
Europe/Budapest
------------------------------

[NicholasZejdlik]

The Collection Manipulation utility should have an action called Read Collection Field. It will allow you to use a string expression to read a field, so you could pass in the value of [Column Name].

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

[John__Carter]

Hi Erika - the expression you are attempting will not work, you cannot dynamically build a collection reference from text in that way. If you need to do this, the approach suggested by Nicholas is best option.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

[DeepakBhardwaj]

Is there any example that you can share please

------------------------------
Deepak Bhardwaj
Senior Consultant
EY
Asia/Kolkata
------------------------------

[John__Carter]

Deepak use the Read Collection Field action of the Utility - Collection Manipulation VBO. The input parameters should be self-explanatory but you can use the blue 'i' button on the screen.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------