Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello - I posted within the comments of another post, but my understanding is that it's better to post to the forum instead.
In using a scaled back version of the updated 2022 automation from the previous 2021 where @MattGrayndler pulled together a video, I seem to be hitting some threshold with the Add Rows to Table (batch) block. Is there a max number of rows that can be batched?
The test table I'm using has 3 columns and 190 rows, and when executing the automation the excel table has headers but no values. If I scale back to approximately 25 rows it populates fine. Any known limitations with the Add Rows to Table (batch) block? Row by row is exceptionally slow.
If there is a limitation how best could 100 rows (or max limit) be batched at a time to build the excel table?
Accepted Solutions
Identified the issue. The array for the Add Rows to Table (batch) block cannot handle the characters \ and " (double quote) within the value string which is why the batches were ignored. Regex Replace is needed to replace these characters that will work in the block array.
I'm part of the way on figuring this out via the Loop Batch block; however, a new wrinkle popped up. Two chunks of data are omitted when a batch begins with a null value or \. Assistance on how to work around this would be appreciated and I attached sample docs. I did try forcing the variable format to text but no luck. Thanks in advance!
Identified the issue. The array for the Add Rows to Table (batch) block cannot handle the characters \ and " (double quote) within the value string which is why the batches were ignored. Regex Replace is needed to replace these characters that will work in the block array.
