cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User
Super User

Re: Importing excel table into SharePoint list

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!





View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Importing excel table into SharePoint list

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!





View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (10,756)