Solved: Struggling with Parent/Child Start: Functions in W... - Page 2

retailpartnerco · 05-20-2020 07:26 PM

Hello! I am having trouble mastering a particular workflow template. I will explain…

I have a start function that gathers many rows from a table. I want these rows to each be shown in a workflow, but I want them grouped by a common column value. For example, If I have 4 rows that have [Store #]=“123”, and 6 rows that have [Store #]=“456”, then I want it to look like this

Store 123
Row 1
Row 2
Row 3
Row 4

Store 456
Row 1
Row 2
Row 3
Row 4
Row 5
Row 6

I cannot figure out how to do this though. I did look at the documentation for a while, and was still left confused. HERE is a link to my template. Scroll down to the second page, this is the new version that I am working on. The area that needs help is highlighted in yellow. Any help would be much appreciated.

Steve

Try this:

<<Start: ORDERBY(FILTER("Previous Weeks Report",AND(([_ROWNUMBER]= MAX(SELECT(Previous Weeks Report[_ROWNUMBER],(LIST([Store #],[Store Name])= LIST([_THISROW-1].[Store #],[_THISROW-1].[Store Name]))))),OR([Company]=”Gonnella",[Reference Company]=”Gonnella”),CONTAINS([_THISROW].[Store Lists To Include In Report],[List]))),[Today])>>

View solution in original post

Struggling with Parent/Child Start: Functions in Workflow