Answered

Help with flow to get Excel data from email attachment and copy to MS List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have this scenario where each day a new email arrives in Outlook with an Excel attachment. I need a flow to get the data in the attachment (only 1 tab/sheet in the file) and copy the data to a MS List. The flow needs to be triggered each time an email with Excel attachement arrives.

I did some research and found out that the Excel data needs to be in a table format and in order to acheive this, you need to create an office script. So I recorded and saved the script called "Convert to Table" as per screenshot below.

Now my issue is how do I incorporate this into a flow? I didn't get far as per screenshot below as I got stuck at the "File" stage i.e. what file am I referencing here?

@Rhiassuring appreciate any direction on how to fix this step and finish the flow if possible.

Thanks in advance.

Categories:

Building flows

All responses (2)

Answers (1)

Sort by

Verified answer

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there,

When an attachment comes in via Outlook, it comes in as the file name, and the file content.

You are going to need to use "Create a File" either in SP or OneDrive, and use that file name and file content to save your Excel file there, so you can reference it.

Now - is your Office Script in the attachment itself, or is it something you are hoping to run from one Excel in other Excel files?

I am going to assume the prior, in which case once it's loaded into SP or OneDrive you'll be able to run the script.

What I like to do when I'm working with Excel files that'll turn into variables is create it off of a hard-coded thing first and then replace with variables after I confirm it works.

Try the steps above first and let me know where you get stuck next (if you do!) -- and, there are other ways to do this too but of course it depends on your data. (Ie, Create a CSV, split it, create table in excel file (through an action), and then add all the data to the table.)

R
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Rhiassuring , sorry for the delayed response. Appreciate your feedback.