topic Use dynamic column fields in Product Forum

Use dynamic column fields

Erika_Papp — Tue, 04 Aug 2020 10:12:00 GMT

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
------------------------------

RE: Use dynamic column fields

NicholasZejdlik — Tue, 04 Aug 2020 13:00:00 GMT

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
------------------------------

RE: Use dynamic column fields

John__Carter — Thu, 06 Aug 2020 07:56:00 GMT

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
------------------------------

RE: Use dynamic column fields

DeepakBhardwaj — Wed, 17 Mar 2021 12:52:00 GMT

Is there any example that you can share please

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

RE: Use dynamic column fields

John__Carter — Thu, 18 Mar 2021 09:50:00 GMT

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
------------------------------