Error on Export Data Store Entity to Excel - "The custom cell positions and custom cell values arrays must have the same length."

Certified Associate Developer

I have a relatively simple Excel document that I want to generate using the Export Data Store Entity to Excel process node. I want a Title cell at the top left, then column headers in the second row, and then the rows of data below.

I have my custom cell positions set as: {"A1, A2", "B2", "C2", "D2", "E2", "F2", "G2"},

And my custom cell values set as:

{
concat("Person Information for Transfer #", pv!transferId),
"First Name",
"Middle Name",
"Last Name",
"ID Number",
"Date of Birth",
"# of High Value Bags",
"# of Personal Bags"
}

Both arrays have a length of 8, but I'm receiving the error, "The custom cell positions and custom cell values arrays must have the same length." What's causing this error?

  Discussion posts and replies are publicly visible

Top Replies