Skip to main content

Notifications

Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Help us with Power Pages Makers & Tenant Admin
Announcing Forum Attachment Improvements!
News and Announcements icon
Power Platform Community / Forums / Power Automate - General Discussion / append data from a mai...
Power Automate - General Discussion
Unanswered

append data from a mail attachment to an existing Excel file in SharePoint using Power Automate

(1) ShareShare
ReportReport
Posted on by GG-21081205-1 2

How to append data from a mail attachment(CSV file) to an existing Excel file in SharePoint using Power Automate.

Categories:
Process Advisor
  • AlexEncodian Profile Picture
    AlexEncodian 4,316 on at
    append data from a mail attachment to an existing Excel file in SharePoint using Power Automate
    1) New email received trigger
    2) Get attachments
    3) Parse CSV content to JSON
    4) Add data to Excel
     
    (3) Parsing CSV content
    There are are few different ways. Natively, you can use expressions to parse CSVs but it can get quite complicated. A no code option is Encodian's Parse CSV action that returns the CSV data in JSON format ready for the next step.
     
    (4) Adding data to Excels
    Natively, you can use the Excel connector to add rows to an excel table. Whether this is a viable solution will depend whether your data is in a table content type in the destination excel and how large the data set that you are adding is. This action requires you to loop through each row so is not suitable for large data sets. Alternatively, you can use Encodian's Add Rows to Excel action to add bulk data in a single step and it can add data to tables and unstructured data alike.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Help us with Power Pages Makers & Tenant Admin
Announcing Forum Attachment Improvements!

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans