topic Re: Fetch Collection Field Data in Product Forum

Fetch Collection Field Data

Babjee24 — Thu, 31 Aug 2023 11:30:36 GMT

Hi,

I've a collection that has certain fields, I've a field name in a text data item, now while looping through the collection I want to update certain field data in-order to do this I should access the field name from the data item I have, how should I use the field name to fetch the data if I use [Collection.[Field Name]] it's giving me an error.

Re: Fetch Collection Field Data

harish.mogulluri — Fri, 01 Sep 2023 15:45:32 GMT

Hi Babjee Vangipurapu,

I faced similar challenge in the past to work around this issue, I used code stage to manipulate the data instead of using decision or calculation stage....

Waiting to see if some one have different approach.

Re: Fetch Collection Field Data

Babjee24 — Sun, 03 Sep 2023 06:33:01 GMT

Hi Harish,

Thank you for the reply can you please send me the code that you've written I'll see if I can use it from my end.

Tagging other active community people @Tejaskumar_Darji, @Mukesh Kumar, @Emerson Ferreira, @Vipul Tiwari please let us know if you've any other approach

Re: Fetch Collection Field Data

harish.mogulluri — Mon, 04 Sep 2023 04:09:23 GMT

HI Babjee Vangipurapu,

That code might not be available for me, but I would try to recreate and share it with you. t will be most likely some time after tuesday.

Thanks,

Harish

Re: Fetch Collection Field Data

Tejaskumar_Darji — Mon, 04 Sep 2023 07:07:04 GMT

Hello Babjee Vangipurapu

You can use Utility Collection Get Collection Fields and Read Collection Field action to achieve this instead of a calc stage where it does not allow to use field name from a data item.

You will have to know the row index somehow to get this work.

Re: Fetch Collection Field Data

Babjee24 — Mon, 04 Sep 2023 07:13:57 GMT

Hi @Tejaskumar_Darji

Thanks for the answer, I'm not trying to read the collection data instead trying to update the value of a field while looping the collection.

Re: Fetch Collection Field Data

Tejaskumar_Darji — Mon, 04 Sep 2023 08:09:45 GMT

Oh okay that also will work with Set Collection Field action using the same approach.

Re: Fetch Collection Field Data

harish.mogulluri — Tue, 05 Sep 2023 12:28:07 GMT

Hi Babjee Vangipurapu,

Sorry for the late response.

Here is the code and steps

I have used Coll_1 as Input collection and FieldName as text and passed these two values and updated collection fieldName "Field2" by using "FieldName" data item.

4) Code:

foreach (DataRow row1 in Coll_1.Rows){
row1[FieldName] = "This is test";

}
Coll_2= Coll_1;

Hope this helps.