Adding Rows from Email Table to Excel Table - Duplicate Records

(0) Share

Report

Posted on by kariseightytwo

374

Hello, I have emails coming in automatically each morning that contain tables. Here is an example image:

Example table in email

I have accomplished everything I wanted to, for the most part. I've extracted the data from the table and parsed the resulting JSON into rows and columns for use:

This is where my rows are split by delimiterThis is where it reads the JSON and separates them in to appropriate columns

The problem arises when I check my Excel table. It is putting the right data in each row and column, but it's duplicated and there are 16 identical rows.

This is where it adds each new row to the Excel table

In the image above, the first "Output" in "Apply to each" is from 'Select' where I split by delimeter.

The second 'Body' in "Apply to each 2" is from 'Parse_JSON'

Any help is greatly appreciated. Thank you!

I have the same question (0)

All responses (2)

Answers (1)

kariseightytwo 374 on at

Like (0)

Report

Re: Adding Rows from Email Table to Excel Table - Duplicate Records

I have tried removing the first Apply to Each and it seems to be doing the same thing. Just keeps dumping rows into the Excel file.

Was this reply helpful? Yes No
Verified answer

kariseightytwo 374 on at

Like (0)

Report

Re: Adding Rows from Email Table to Excel Table - Duplicate Records

I have resolved the issue. The Apply to Each step was not needed apparently. Just directly go to the Add New Row step was all I needed to do.

Was this reply helpful? Yes No