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 delimiter
This 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!
