CSV Template ignores ORDERBY()

Hey everyone.

I’m playing around with the CSV export workflow, but I’ve found that if you have a START expression in your template with an ORDERBY, the orderby is ignored.

I created a sample app showing this in action:
https://www.appsheet.com/samples/OrderBy-is-ignored-in-CSV-template-export?appGuidString=dfe27db2-ec...

Here’s a video showing what I’m talking about:

Solved Solved
0 2 284
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

This:

ORDERBY(Sheet5[_rowNumber], Order)

should be this:

ORDERBY(Sheet5[_rowNumber], [Order])

Note the square brackets. That argument is actually an expression, not a column name.

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4

This:

ORDERBY(Sheet5[_rowNumber], Order)

should be this:

ORDERBY(Sheet5[_rowNumber], [Order])

Note the square brackets. That argument is actually an expression, not a column name.

It’s been awhile since I’ve pulled one of those all night building marathons. There’s a trade off, lol: you get silly minor mistakes like this, but get a ton done in one shot.

Thanks man! Works perfectly.

Top Labels in this Space