Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Extract data from Exce...
Power Automate - Building Flows
Suggested answer

Extract data from Excel attachment into a SharePoint list using Power Automate

(0) ShareShare
ReportReport
Posted on by CU31101853-0 12
I receive a daily Excel document in email form from Outlook weekly. I was wondering if there is a way to extract the data from the Excel attachment and have it added onto a list on SharePoint using Power Automate. 
 
Thanks!
Categories:
Business Process Flows
  • AlexEncodian Profile Picture
    AlexEncodian 4,261 on at
    Extract data from Excel attachment into a SharePoint list using Power Automate
    The native "List rows in Excel" action only works with xlsx files that have table content types.
     
    Its a bit more involved to parse CSVs natively (see links posted in another response) or you can use a tool like Excel - Extract Rows which works on different excel files types including CSVs and works with or without table content types.
  • Suggested answer
    Optimizer Profile Picture
    Optimizer 2 on at
    Extract data from Excel attachment into a SharePoint list using Power Automate
    You can parse a CSV with just expressions & a Select action like what is shown here
  • CU31101853-0 Profile Picture
    CU31101853-0 12 on at
    Extract data from Excel attachment into a SharePoint list using Power Automate
    Yes, it is CSV. It does also have table content types
  • AlexEncodian Profile Picture
    AlexEncodian 4,261 on at
    Extract data from Excel attachment into a SharePoint list using Power Automate
    Yes, this should be simple to do. What does your excel look like, what format is it (csv, xlsx, etc)? Does it have table content types?

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

Welcome to the Power Platform Communities
Give Back to the Community this Month

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans