Not able to add multiple rows only one row using add data row

Help
, , ,
1

I am using add data row but it not add record for example I have 10 records I am using for loop first time I add record in add data row and then for first record replace by second at the end I am getting only one record ie last record.only got one row instead to 10 records

2

Hi @Aditya10989

I got your problem,
Make sure to keep Build Datatable activity outside the loop.

1 Like
3

@Aditya10989

Is Build DataTable Activity outside loop or not ?

As @sharique.khan said, i guess you kept it in inside the loop. Please check it once and then try.

1 Like
4

@lakshman @sharique.khan thanks for reply I try both firstly I try inside I am getting value only last inserted then I try outside I am getting null value.Actually I am using in this two workflow one is main and second workflow I am using for loop So I create build data table in main outside work flow but I am getting null value

1 Like
5

Hi @Aditya10989,

Can you please attach the screenshot of for each loop and add data row activity.

Thanks,
Shenki

6

yes sure I am using build data table and for loop in main workflow and add data row in claim shield work flow as mention in attached screen shot

Untitled
Untitled1920×1080 65.1 KB
Untitled1
Untitled11920×1080 64 KB

7

Please insert your add data row in foreach. And iterate through each row and pass it in Add data row.

8

yes my workflow invoke claim shield is already inside the for each loop where I add data row. as mention in screen shot

Untitled
Untitled1920×1080 73 KB

9

Oh sorry.

I thought it’s outside.

Can you please attach your workflow and excel.

10

yes sure I will send you but you can’t run this because its run on server

11

Please find enclosed file of attachment ClaimStatusCheck.xaml (179.2 KB) Main.xaml (55.1 KB) New Lexis Nexis Invoice 2019.xlsx (21.8 KB)

12

@ShenkiSinghai Hi,did you find any solution…?

13

Hi @Aditya10989,

Apologies for late reply as I was outside.

In your attached main.xaml I am unable to find for each loop.

But for your reference please find attached xaml and data sheet. I have included two way to add row in data table.

  1. By Invoke method.
  2. By Add Data row.

Whatever reference you find suitable please use it in your workflow.

Data.xlsx (8.2 KB) Main.xaml (12.2 KB)

Thanks,
Shenki

14

NP but I did not got solution.For each activity next where I mention build data as mention in screen shot

Untitled
Untitled1920×1080 82.5 KB

15

Hi @Aditya10989

I have opened your xaml but for eac activity was not there, so didn’t able tfind exactly where the issue was. But if you see my attached xaml then you will get the idea how it needs to done.

Thanks

16

if you see my code I have done the same may be issue related to xaml workflow argument.I try but I am not able to find solution it will helpful if you provide any solution

17

Hi @Aditya10989,

I cannot find for each in your main.xaml. please resend you all workflow in zip

Thanks