Unanswered

Power Automate Copy Sharepoint to GSheets not copying all SP entires

Like (0) Share

Report

Posted on 31 Jan 2023 23:39:00 by mark1014

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

All responses (2)

Answers (0)

v-jefferni on 02 Feb 2023 at 06:07:03

Like (0)

Report

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 9 on 01 Feb 2023 at 13:25:34

Like (0)

Report

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?