I am using the Append new rows in bulk export from the Marketplace to write data to an Excel file in a SharePoint location.
I am exporting data from four different sources of an HR application. When checking the results, I have 857 of the 884 expected records. I am not sure why some of my records are not importing so I ran a test limiting to just one of the 27 records that did not write (using a branch filter) and, oddly enough, the single record wrote to the Excel file.
This is strange in that if I run the entire process in bulk, reading from the four different sources, 27 of the records are being left out. But if I run just one of the records left out, then it shows up.
It makes me wonder, could there be an issue with the paging features? I'm not 100% certain, but I thought I counted a total of 27 pages in the export - which could coincide with 27 missing records.
I'm having a hard time determining why these records would fail, but when isolated, could later write to the record as expected.
Any thoughts as to what might be happening here?
Thank you for your time,
-mitchel