Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - General Discussion / Power Automate Copy Sh...
Power Automate - General Discussion
Unanswered

Power Automate Copy Sharepoint to GSheets not copying all SP entires

(0) ShareShare
ReportReport
Posted on by mark1014 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
    v-jefferni 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
    mark1014 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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

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 >

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans