Get data from email attachment and append these rows to an excel file in Sharepoint

Like (0) Share

Report

Posted on 30 Apr 2024 00:28:25 by rushkarausch

I get an auto email with a CSV attachment every day. I need to get this data and append to the bottom of the table in an existing file i Sharepoint. The excel file in Sharepoint is in a table format and all columns and titles match exactly what i get in an email.

Does anyone know how i can achieve it, please?

Categories:

Process Advisor

All responses (2)

Answers (0)

takolota1 4,863 Super User 2025 Season 1 on 30 Apr 2024 at 02:20:25

Like (1)

Report

Re: Get data from email attachment and append these rows to an excel file in Sharepoint

That one can convert CSVs to new Excel tables. However I think he may be looking to append rows to an existing table, so this template may be more helpful: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191
SudeepGhatakNZ 14,318 Most Valuable Professional on 30 Apr 2024 at 02:10:49

Like (0)

Report

Re: Get data from email attachment and append these rows to an excel file in Sharepoint

@rushkarausch

Try this template provided by @takolota

CSV To New Excel Table - Power Platform Community (microsoft.com)