Power Automate - Email w/ excel spreadsheet extract row 2 and add to table 1 of document X

(0) Share

Report

Posted on by nmrich6130

I have a few emails daily that include an excel spreadsheet with all of the information I need on row 2. I would like to take that data and place it into an existing document on onedrive. I've created the excel spreadsheet and table (table 1) but I don't know how to get the information into it. I tried to follow several similar things I found online to no avail.

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Power Automate - Email w/ excel spreadsheet extract row 2 and add to table 1 of document X

Hi @nmrich6130,

When a new email arrives, you could get these attachments content first. then store then into the OneDrive as a file to get the File identifier. After get the identifier of the file, you could use Get tables action to get table id in the Excel file.

Both table id and identifier, we could get the rows of the Excel table by using List rows present in a table action.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.