//Give me the list of tasks that are in the current sprint or future sprint
Tasks.Filter([In current sprint?]=true OR [Future sprint?]=TRUE)
//For each of the tasks in that list
.ForEach(
// Add a row in the Log table
AddRow(Log_Step3,
//Task name is the task object/key (current value)
Log_Step3.[Task Name],CurrentValue,
// Points remaining is the "points remaining" unless the task hasn't started yet, then take the points estimated
Log_Step3.[Points remaining],If([Points remaining]>0,[Points remaining] ,[Points Est.] ) ,
// Date stamp is today
Log_Step3.[Date stamp],Today(),
//And give me the active sprint that the task is in, unless it's a future sprint, then give me that sprint.
Log_Step3.Sprint,[Sprint(s)].Filter(Current=true or [Start date]>Today())
)
)
