Answered

Automatic Flow - Email Attachment -> Create CSV Table -> Write Data to SharePoint List

(0) Share

Report

Posted on by Hussein

Hi Experts,

I receive an email everyday in the morning titled "Background Job Notification" from an email address let's say 'abc@123.com' with an excel file as an attachment titled "SEP Mandatory eLearnings Report".

The csv file has the following columns:

Staff ID

Staff Name

Course ID

Course Title

Last Completion

Validity

Status

I want to create an automated flow to convert the CSV file into an Excel table and write new rows to a sharepoint list to include the data from the table in the excel file. I cannot use premium connectors.

Desired outcome:

Receive the email with attachment (CSV file)
Write the data from the CSV file to a SharePoint list

I am new to Power Automate so please be mindful of technical expressions :)

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Lagortinez 130 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi,

Welcome to Power Automate! You're absolutely on the right path. Here's a beginner-friendly way to achieve your goal using only standard connectors (no premium required).

✅ What you want:

Receive a daily email with a CSV attachment

Extract the content of the CSV

Add each row into a SharePoint list

Step-by-step: No Premium Connectors Needed

1. Trigger: "When a new email arrives (V3)"

From: abc@123.com

Subject Filter: "Background Job Notification"

Has attachment?: Yes

2. Get the attachment content

Use "Apply to each" for attachments

Inside: Add "Get Attachment Content (V2)"

Store the file in OneDrive for Business temporarily ("Create file" action)

3. Convert CSV to Excel Table (manually once)

Prepare a blank Excel file in OneDrive with a table already created.

The table must have the same column headers as your CSV:

Staff ID, Staff Name, Course ID, Course Title, Last Completion, Validity, Status

4. Overwrite table data using Power Automate

Use "List rows present in a table" to extract the data.

5. Write to SharePoint List

Use "Apply to each" for the Excel rows

Inside the loop: use "Create item" for SharePoint

Map each column to the corresponding SharePoint column

⚠️ Notes:

Power Automate cannot read raw CSV without premium connectors, but this workaround using Excel in OneDrive works perfectly.

You must define a table in the Excel file before using it in your flow (Insert > Table).

Make sure your SharePoint list has all the columns ready.

If this post helped you, please click "Does this answer your question?" and give it a like to help others in the community find the answer too!

José Martínez Lago
Solution Architect | Dynamics 365 & Power Platform
Empowering low-code consultants to deliver high-impact solutions
Blog: thatsagoodquestion.info
LinkedIn: martinezlago

Was this reply helpful? Yes No
Hussein 65 on at

Like (0)

Report
Copy link

Link copied!

Hi @Lagortinez,

Thank you for your reply.

Please be aware that I only managed to complete step 1. Can you please provide detailed step by step and what to write in each field? I tried to follow your instructions but I got lost after step 1.

Please be mindful with the actions names as "Get Attachment Content (V2)" does not exist. Apologies but I am new to Power Automate :)

I have created a blank Excel file in OneDrive with a table already created with the same column headers as the CSV file received by email. The file is stored in a SharePoint document library.

Thank you and I look forward to your reply.

Was this reply helpful? Yes No
Suggested answer

Lagortinez 130 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please check out this video, it is going to be easier :D

https://www.youtube.com/watch?v=fI9S5781P3o

Was this reply helpful? Yes No
Hussein 65 on at

Like (0)

Report
Copy link

Link copied!

Hi @Lagortinez,

Thank you once again for your reply.

Unfortunately, the video does not help. Are you able to provide a simpler explanation of how to achieve the desired outcome?

Thank you.

Was this reply helpful? Yes No
Verified answer

Hussein 65 on at

Like (0)

Report
Copy link

Link copied!

I finally managed to find the answer.

https://www.youtube.com/watch?v=pmQkeFeSkiw

Thank you.

Was this reply helpful? Yes No