Problems with _THISROW-n expression

[Luke_H1]

I am trying to send a pdf report in a workflow and connot get this to work. The column name is correct and there is an entry in [_THISROW-6] however it comes up with an error. I have tried this for several columns and no luck. Not just with _THISROW-6 but -1, -2, -3 etc

It gives me error “Unable to find column ‘_THISROW-6’”

Any suggestions

[1minManager]

I think [_ThisRow-x] only works with the Start expression

help.appsheet.com

Template Start Expressions

Using Start expressions in your workflow templates.

Simon@1minManager.com

[Steve]

1minManager:

I think [_ThisRow-x] only works with the Start expression

Nope! It’s now available in any expression!

[Steve]

For reference, click below:

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Back-references within nested queries ([_THISROW-n]) Consider a complex App formula with “nested” SELECT() expressions (SELECT() expressions within SELECT() expressions): SELECT( table[column1], ... SELECT( table[column2], ... SELECT( table[column3], ... ) ... ) ... ) Let’s call the row for which this entire expression is evaluated as its App formula the Origin Row. Within this entire expression, we can refer to column values of the Origin Row by dere…