Unable to create 7000 items in a sharepoint list from excel

[andygp25]

I am trying to create 7000 items in a sharepoint list from an excel file with the 7000 records. The flow just create 256 and stops. in List rows present in a table settings, Changing pagination to 5000 does not work.

What can i do?

[ChristianAbata]

hi @andygp25  you need to follow this post.

https://sharepains.com/2018/10/17/microsoft-flow-read-large-excel-files-within-seconds-without-creat...

[v-alzhan-msft]

Hi @andygp25 ,

The action "List rows present in a table" of Excel (Business) connector have the 256 rows limit in microsoft flow currently.

If you would like the limit of action "List rows present in a table" of Excel (Business) connector would be 7000 rows,

I afraid that there is no way to achieve your needs in Microsoft Flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[abm · Accepted solution]

Hi @andygp25 

I did created an excel sheet which contains 10,000 records. Below is my flow.

For the Excel connector (List Rows Present in a table) settings I did set threshold as 10,000 and set the Pagination On.

The compose expression I am using under the compose is as follows:

length(body('List_rows_present_in_a_table')?['value'])

This expression returns the total number of records returned from List rows step above.

Here are my run result:

Conclusion:

The excel connector is capable of returning 10,000 records when we set the threshold. From the run history 'List rows present in a table' I can see all the records returned as expected.

Thanks

[cyberco01]

I have tried the same. I update you soon.

[cyberco01]

Hi @abm,

The solution is working well. Thanks a lot.

However, I am unable to put the threshold limit to 10000. The maximum is 5000.

Thanks in advance.

[Yi66]

that's my issue too, any solution now?

[Anonymous]

length(body('List_rows_present_in_a_table')?['value']) this line is INCORRECT.

[Anonymous]

terrible answer on the above poster. very very unprofessional. the correct one is 

length(outputs('List_rows_present_in_a_table')?['body/value'])