cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fuzzy
Level: Powered On

Array Items Append to Excel Table

Hi,

 

In my flow, I am trying to retrieve data table received in an email (HTML format) which I receive every day. I take that data and append to an existing Excel table.

 

I have figured out the middle part - which is using some HTML table data and up to the point where I have created an array which stores each table data. I am now trying to figure out how to take the array items and append to an existing Excel table. And I am having some trouble doing that.

 

My table will always have 4 columns and so I really need to create a new row for every set of 4 items in the array (if that makes any sense):

index[0] -> Column 1, row 1

index[1] -> Column 2, row 1

index[2] -> Column 3, row 1

index[3] -> Column 4, row 1

index[4] -> Column 1, row 2

index[5] -> Column 2, row 2

index[6] -> Column 3, row 2

index[7] -> Column 4, row 2

...and so forth depening on how many "multiples of 4" sets of data I get from that email every day.

flow-email-to-excel.png

 

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,735)