Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Power Automate Copy Sharepoint to GSheets not copying all SP entires

(0) ShareShare
ReportReport
Posted on by 9

I have a flow which copies items from a sharepoint list to google sheets every night. I did this by doing the following. 

 

1. gets the gsheet

2. deletes all previous data

3. Gets the sharepoint entries

4. inserts row in gsheets and copies/pastes values from sharepoint

 

mark1014_0-1675208039382.png

 

It seems to work great. However I just noticed that I only see 100 records being copied, but there are 110. The flows history shows Succeeded status'. I'm new to Power Automate and I'm not sure what to do to ensure all my records are copied.

 

Any thoughts, ideas or suggestions are greatly appreciated. 

 

TYIA,

Mark

  • v-jefferni Profile Picture
    on at
    Re: Power Automate Copy Sharepoint to GSheets not copying all SP entires

    Hi @mark1014 ,

     

    Please do not post same issues in different forums and help other users find solutions easily. The other post has got an answer: Power Automate Copy Sharepoint to GSheets not copy... - Power Platform Community (microsoft.com) 

     

    Best regards,

  • mark1014 Profile Picture
    9 on at
    Re: Power Automate Copy Sharepoint to GSheets not copying all SP entires

    I updated the get items Sharepoint settings and turned Pagination on and set the threshold to 200. That seems to have brought over all records. Is this the best approach?

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 >