cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sterbella
Frequent Visitor

Importing excel table into SharePoint list

I have a process that drops an excel file into a document library in SharePoint online. I want to import the data in this excel file into an existing SharePoint List. I've created a flow as seen below and it works great, except it only imports 256 records when there are over 4000 records in the table.

 

 

flow.png

 

Does anyone know what I'm doing wrong here?

1 ACCEPTED SOLUTION

Accepted Solutions
Jcook
Super User III
Super User III

Hello @sterbella

You will need to increase the threshold.
To do this:
Click the 3 dots on the excel action.
Click settings,
Now turn on pagination, and set the threshold to a value you want to return. Let’s say 5000.

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

1 REPLY 1
Jcook
Super User III
Super User III

Hello @sterbella

You will need to increase the threshold.
To do this:
Click the 3 dots on the excel action.
Click settings,
Now turn on pagination, and set the threshold to a value you want to return. Let’s say 5000.

Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,681)