cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rados
Helper I
Helper I

Unable to update Sharepoint list from Excel using Power Automate

Hi all,

 

We have a problem when we want to update a Sharepoint list from a Excel using Power Automate. Location of the Excel is same as location of the Sharepoint list. We have made a flow that reads data from that Excel document, and add every row in the Sharepoint list. After flow was finished, only 256 rows were recorded in Sharepoint list. We were trying to update top count field in the PA, but that didn't help. Number of rows in Excel document can vary from 100 to almost 5000 rows each month, but it is updated every day by about 100/200 rows. At the beginning of the month, content of the Sharepoint list will be deleted, so the data of next month could be recorded. But, this won't work cause the Sharepoint/Power Automate limitiation. Did anyone have the same problem, with this amount of data?

1.png

2.png

3.png

4.png

5.png

   

1 ACCEPTED SOLUTION

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @Rados ,

in the Excel "List rows present in a table" action, you should open the Settings:

MarconettiMarco_0-1659611206804.png

 

and enable the Pagination putting the max rows number you want to grab:

MarconettiMarco_1-1659611243165.png

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

View solution in original post

4 REPLIES 4
MarconettiMarco
Super User
Super User

Hello @Rados ,

in the Excel "List rows present in a table" action, you should open the Settings:

MarconettiMarco_0-1659611206804.png

 

and enable the Pagination putting the max rows number you want to grab:

MarconettiMarco_1-1659611243165.png

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

Rados
Helper I
Helper I

Hi @MarconettiMarco ,

 

Flow ran successfully, but 704 rows are recorded.

2022-08-04 13_31_27-Edit your flow _ Power Automate.png

 

2022-08-04 13_44_07-onlinekataloska - OnlineKataloskaOrderiList - All Items.png

 

@Rados ,

please open the last run and check how many rows got the "List rows present in a table" action.

 

BR,

Marco

Rados
Helper I
Helper I

@MarconettiMarco,

 

I was looking into another table, which contains 704 rows. I've change the table, and it's fine now.

 

Thank you!

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,528)