web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Gtmkz9b3gx192MkJjXHTaB
Power Automate - General Discussion
Unanswered

Power Automate Copy Sharepoint to GSheets not copying all SP entires

Like (0) ShareShare
ReportReport
Posted on 31 Jan 2023 23:39:00 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 02 Feb 2023 at 06:07:03
    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 01 Feb 2023 at 13:25:34
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete