Retrieve values from Excel Document in Email

[Anonymous]

I receive daily reports that contain operational information I need to easily access.  I have been able to create flows to pull text from any text file attachment, but cannot seem to find a connection from "Get attachment" to pass to an Excel step to pull the data. 

Any insight into how to create this connection would be most appreciated.

[abm]

Hi @Anonymous 

Are you looking to insert the attachment content to Excel Rows?

Thanks

[v-litu-msft]

Hi @Anonymous,

I am not sure understand your requirement, could you please give more information about ""Get attachment" to pass to an Excel step to pull the data."?

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.

[Anonymous]

I am not trying to add to a spreadsheet, I am trying to read from it. 

When I get an email with a .txt attachment I can run:

"When a new email arrives" -> "Get attachment(reference to email)" -> "Send email(text of attachment)"

This flow does not work with a .xlsx attachment as the data is not stored as a string.  I cannot seem to pass the attachment reference from an outlook step to an excel step.  I also do not see anything in the outlook step options to process the binary data to something I can put into another email or table (which is what I'm doing with the .txt attachment).

[Anonymous]

Here's the flow that works for pulling text attachments for reference. Trying to do the same thing but with an attachment that comes as a spreadsheet.

[v-litu-msft]

Hi @Anonymous,

Yes, currently in Flow, it is unfortunate that there is no way to get content of a dynamically Excel file. You could put the Excel file into the attachment field, send it as an attachment.

https://powerusers.microsoft.com/t5/Building-Flows/Email-Attachments-in-Flow/m-p/194363

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.

[Anonymous · Accepted solution]

Since I am trying to get the values from a spreadsheet already being emailed to me, reattaching to a new email will not be helpful, thank you though.

I can resolve this - No Resolution.