Answered

Retrieve values from Excel Document in Email

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Using connectors

All responses (6)

Answers (1)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

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

Thanks
v-litu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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).
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.