[_THISROW] in nested start expression

If I have nested start expressions in a template, does the THISROW expression change to the the row selected in the start expression once it hasnโ€™t reached the END expression or does it always refer to the row that triggered the template?
For example in the below, does the _THISROW in the second start expression refer to โ€œProjectDetailsโ€ row selected or the same row that the _THISROW in the first start statement points?

<<Start: Filter("ProjectDetails", [StartDate] > [_THISROW].[Date])>>
             ........
              
             <<Start: Filter("ProjectActivities", [ProjectID#] = [_THISROW].[Project Name])>>
                     ........
             <<End>>

 <<End>>
Solved Solved
0 6 768
1 ACCEPTED SOLUTION

Hello @Cathal_Noone, first let me show you the best explanation there is for [_THISROW], it applies to both regular expressions and workflows.

By looking at the masterfully explained diagram, we can see that [_THISROW] is always going to refer to the origin row.

View solution in original post

6 REPLIES 6
Top Labels in this Space