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
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
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,
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?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2