web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automatically extract ...
Power Automate
Answered

Automatically extract data from an Excel Report in to a SharePoint list

(2) ShareShare
ReportReport
Posted on by 4
Here is my situation:
Periodically, i receive a structured Excel report (not in a table format) which has records which I want to then extract and import in to a current SharePoint list.
How can i do this using Power Automate? Preferably, i'd like to place the Excel report in to a SharePoint folder and when a new report is identified, then the Flow would kick off.
Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,969 Moderator on at
     
    If I understand, you are saying you want to just manually move it and thats no issue.
     
    Let's start with the easy part
     
    1. Add a Trigger for When a file is created or modified (SharePoint)
    --Make sure to target the SharePoint site and Folder you plan to move the file too
     
    This will cause the Flow to trigger whenever you put the file in that location
     
    Now... we are already at the hard part.
     
    You said it's not in Tablet format, so you have a few options, but I recommend you share what it looks like in a picture, so we have a way to tell you what to do for sure.
     
    Option 1
    Create your own Table using Create Table action for Excel Business
    Then use List Rows Present in a Table action for Excel Business to get the data.
    Then use an Apply to each to loop through the data
    --Inside the Apply to each with the input being the data returned in List Rows Present in a Table
    ------Use Create Item Action for SharePoint, using the data from the Apply to each Iteration (it's a loop over your data).
     
    Essentially that's it for option 1
     
    Option 2
    You can use Graph api to work with the data but. in this instance I don't think I would
     
    Option 3
    This is a great option for you
    You would create 1 or More excel scripts, which would pass back data.
    So you would create an Office Script in Excel, then call it from Power automate, like the belo
     
     
    I hope these provide you with direction and help.
     
    If this resolves your issue, Please Mark as such and maybe a like.
     
    If you have issue after, please come back.
     
    Thanks
     
  • DD-10041941-0 Profile Picture
    4 on at
    I'm open to option 1 or 3 - in option 3, i followed the link but have the same question/issue one of the reply's had in the post - what if i dont know how many rows/records will be in the report. It could be 1 or it could be 4 - how would i code that?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard