Iterative Macro: Error - "more than 16 records in the source"

Hi there

I've built an iterative macro which needs to run more than 16 rows of data in one iteration. However, I always get an error saying that "Iteration #... - There are more than 16 records in the source". Is there any way to resolve this?

I know that you may increase the number of iterations, but I don't know how to increase the number of rows that the macro takes in one iteration.

Would be very grateful for any advice.

Kind regards,

Dima

Error Message

Iterative Macro

Accepted answers

Kenda

Hello @Iasnovskii

Do you happen to have an append tool within your macro? If so, check the drop down to allow all appends.

Hope this helps!

All comments

Kenda

Hello @Iasnovskii

Do you happen to have an append tool within your macro? If so, check the drop down to allow all appends.

Hope this helps!

Iasnovskii

Hello Kenda

Thanks so much!! This worked! I completely forgot about this Append tool in the Macro.

Thank you!

Kind regards,

Dima

echuong1

There is no limit on the number of records you can run through an iterative macro.

I'm guessing you have an append fields in the macro. This is automatically set to error if there are more than 16 records, because you could accidentally misconfigure and the workflow would run for awhile and generate a ton of extra rows! If you do need to append more than 16 records, change the setting to either warn or allow all appends.

Hope this helps!

Undertak

I am having a problem that seems similar to this, but does NOT involve explicit use of the Append tool. It DOES involve the macro only working for 16 records.

I have a macro that uses the SharePoint Files Input tool to read specific tabs of specific files. There are 51 tabs across 4 files, so 51 records are being supplied to the tool.

The first 16 records process as expected, but records 17-51 all fail with an error message of "Record #xx: Tool #1: Failed to authenticate." FWIW, records 1-6 are different tabs of the same file, 7-14 are different tabs of the same file, 15-22 are different tabs of the same file, and 23-51 are different tabs of the same file. This is weird that the authentication seems to break in the middle of reading the same file (i.e., records 15 and 16 succeed, yet the other 6 fail).

I initially suspected that maybe I was trying to read SharePoint too quickly and added in throttling, but that didn't appear to have any affect other than make the entire process much slower before it presented me with the errors.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703