Add an Element to an existing Data row

[Dhruv1594 (Dhruv Dave)]

Hello Everyone,

I wanted to add a element to an existing data row depending on a condition weather a transaction is successful or not like this:

I am using the REF and my transaction item is a data row
how to do this?

[ImPratham45 (Prathamesh Patil)]

In for each row ,
You can use write cell or Assign activity for updating value in it
Ex. assign row(“result”)=“successful” if cond meet that requirement else row(“result”)=“fail”

[Dhruv1594 (Dhruv Dave)]

I will try that out

[ImPratham45 (Prathamesh Patil)]

is it work for you??

[Dhruv1594 (Dhruv Dave)]

how to write it in an excel sheet ?

[Manjuts90]

@Dhruv1594 Once you update the values in Data-Table inside for-each loop as said by pratham, Just write the Data-Table using write range activity after for each activity. But data in excel is overwrite with data in the Data-Table.

[Dhruv1594 (Dhruv Dave)]

Alarm_Text_Fetch.xaml (16.9 KB)
i have uploaded the work flow

[Manjuts90]

@Dhruv1594 what error you getting?

[Dhruv1594 (Dhruv Dave)]

i am not getting any error. But i am not getting the output.

[Manjuts90]

@Dhruv1594 Use break after excel application scope

[Dhruv1594 (Dhruv Dave)]

i have done this will this work?

[Manjuts90]

@Dhruv1594 Run and check once bro

[Dhruv1594 (Dhruv Dave)]

not working. it writes on the same cell again and again

[Manjuts90]

@Dhruv1594 In range of write cell, make sure right variable is incremented everytime this workflow is invoked.