Extracting .CSV Email Attachment from Outlook and Importing into SharePoint

(0) Share

Report

Posted on by RP2

Hello all,

I'm working on building an automated flow and I'm not sure where to start, as I'm still very new to PA.

I need to export a .csv attachment (9KB) that arrives via email (Outlook), and have that data entered into a SharePoint list for tracking and analysis. I'm not sure how to establish this flow or what the best way to approach it would be. I already have a SharePoint list with the elements that would be in the .csv attachment. This data would be dynamic, so I'm trying to keep one master list in SharePoint that could be written to every time a new attachment is fetched from the email (essentially, I do not want to create a new file each time, I would like to enter the new data into new rows in SharePoint each time). It would be best if I could automate this flow based upon a subject line trigger (i.e. every time an email comes in with "XXXXX" check for attachments and export data to SharePoint master list).

The naming format for the attachment could be the same each time or it could be changed, whichever is easier.

I could also extract the .csv into Excel then import it into SharePoint if that would be easier. If anyone has any suggestions please let me know.

Thank you for your help

Categories:

Building flows

I have the same question (0)

All responses (23)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @RP2 get cvs data unfortunally is not supported in PA, to get data inside excel you need a new format time that is xlsx and inside a table created.

See the topic that recently solved.

https://powerusers.microsoft.com/t5/Building-Flows/Calculate-total-of-CSV-cell-and-populate-SharePoint-list-every/m-p/532258#M68729

Was this reply helpful? Yes No
RP2 50 on at

Like (0)

Report

@ChristianAbata

Thank you for responding so quickly. If I had the attachment coming in as an .xlsx format would it be easier to export the attachment data points to a SharePoint list this way?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

yes @RP2 .

See this example

Was this reply helpful? Yes No
RP2 50 on at

Like (0)

Report

Hello,

I'm not sure if this is what I was looking for. I'll have an incoming .xlsx attachment coming in from an Outlook email that I need to extract into a master SharePoint list. I do not want to create a new file each time separately.

For example, say the incoming .xlsx attachment has the following fields. Name - Open Time - Description - Resolved Time - Status.
I already have those columns populated in my SharePoint list ("TestList"); however, each time this .xlsx attachment is sent via email I want to add the new data to the master SharePoint list "TestList," instead of creating individual files or overwriting any prior data in the "TestList." I hope that makes sense.

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

shure @RP2 I understhand you but there are no way to read a file that is in a email, you need allways to create that file in somewhere to get the data inside.

Was this reply helpful? Yes No
RP2 50 on at

Like (0)

Report

@ChristianAbata Gotcha.

I ran the flow as described and it ran successfully; however, it doesn't look like it populated either the SharePoint or Excel list. Any ideas?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@RP2 could you show me an screanshot?

Was this reply helpful? Yes No
RP2 50 on at

Like (0)

Report

"When a new email arrives (V3)" -The new email arrives into a Test mailbox with a subject line trigger.

The "Create File action" - SharePoint folder path is the list that I want all of my data to be extracted into and the column values in that SharePoint list match with what's being extracted from the .xlsx attachment.

"List rows present in table" - The file is my Excel document that also contains all of the same fields as the attachment from the email, and the table is the proper table for the aforementioned list.

Additionally, When I look at the output of the last action (Excel) all of the values look like this - "Open Time": "",

@ChristianAbata

Was this reply helpful? Yes No
RP2 50 on at

Like (0)

Report

Removed

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@RP2 please create list rows inside apply to each

Was this reply helpful? Yes No