Answered

Get all sharepoint items to insert rows in Sql server table - only 100 rows inserted instead of 157 rows

(0) Share

Report

Posted on by DeevyaAskoolum

Hello everyone,

I have a flow that is manually being triggerred to get all items from a SharePoint List and then insert the items as rows in a SQl table.

The flow has run successfully but however some rows are missing in the SQL table. The SharePoint list has 157 items which is 157 rows to be inserted on the SQL table but only 100 rows have been inserted.

Please advise/suggest/help.

kind regards,

Deevya

All responses (2)

Answers (1)

DeevyaAskoolum 23 on at

Like (0)

Report

Re: Get all sharepoint items to insert rows in Sql server table - only 100 rows inserted instead of 157 rows

Hi yashag2255,

Thanks for your help.

The suggestion solved my issue !
Verified answer

yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: Get all sharepoint items to insert rows in Sql server table - only 100 rows inserted instead of 157 rows

Hey @DeevyaAskoolum

The get items action, by default retrieves only 100 items. You need to add the number to the top count to get more items. Please see the screenshot below:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!