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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Fetch excel from email...
Power Automate
Answered

Fetch excel from email, format as table, key each row into SharePoint list

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I have a question re. what might seem like a simple flow to the more experience users, but as a beginner, I'm struggling to put this together properly. I have an excel file that comes to me every week, always has the same first row and number of columns, but with data below being updated or more data rows being added. I'm looking to do the following with it:

  1. Format the received excel range (say all data is within range A1:D10) into a table to allow us to key the rows into a SP list
  2. Read each row and key it into an existing SP list

The excel's table columns have the exact same titles as the SharePoint list columns.

If we want to use a sample data set, let's imagine a table as below.

 

NameTypeQuantityPrice
AppleFruit5$1.00
BananaFruit10$0.50
CeleryVegetable20$0.75

 

Any help is most appreciated!

Categories:
I have the same question (0)
  • Verified answer
    eltibu Profile Picture
    on at

    It ended up being simpler than expected. Flow below. Resolved myself.

     

    eltibu_0-1669305237577.png

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#3
David_MA Profile Picture

David_MA 270 Super User 2025 Season 2

Last 30 days Overall leaderboard