'Append Range' activity writing multiple copies of same data

Help
1

I have a process that:
(1) Reads an Excel spreadsheet consisting of Numbers
(2) Uses this Number to query and return a Date from a website.
(3) Writes the Date into an Excel file

Part 3 fails - it keeps writing the Date for the first Number again and again.

XAML and source data sheet attached - help appreciated.

APCExpiryCheck.xaml (22.1 KB)
APC Status Report.xlsx (11.4 KB)

2

Are you providing the dynamic range to write the values in the excel

3

Hi @bhatnagar
Make sure you are using the value which Increment every time in the loop and provide that value to write in the excel.

4

Thanks, @HareeshMR - I did that, however, now it:

  • Keeps writing the same extracted line on Row 11 then, Row 21 and Row 23 into the Export File.

  • It also writes the line on the Row 11 of the Import File.

Updated XAML attached.APCExpiryCheck.xaml (21.1 KB)

5

Thanks, @jitendra_123 - I did that, however, now it:

  • Keeps writing the same extracted line on Row 11 then, Row 21 and Row 23 into the Export File.

  • It also writes the line on Row 11 of the Import File.

Updated XAML attached.APCExpiryCheck.xaml (21.1 KB)