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

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
DeevyaAskoolum 23 on at

Like (0)

Report
Copy link

Link copied!

Hi yashag2255,

Thanks for your help.

The suggestion solved my issue !

Was this reply helpful? Yes No