Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

On new file (Excel) write rows into Sharepoint List

(0) ShareShare
ReportReport
Posted on by 85

Hello,

 

I've got an Excel file with fixed structure and one table; I have created a SP List to match the Excel structure.

 

Now I would like to write all the rows from the Excel file to the Sharepoint list but I got stuck because I miss the dynamic content from the "Get rows in table".

 

I understand the PowerAutomate "doesn't know" what header will be present as the trigger is "When file is created".

 

When I run the flow, the header and data gets loaded; how do I match the content from the output to the SP List?

 

Thank you!

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >