Trying to update the STart and due date based on when i start the sprint

[Minaz Fazal]

Hi There

i am trying to create an automation that will update the tasks and the epic for those tasks with the start and end date based on a fixed 2 week sprint.  I am able to use the following automation to get the tasks and stories date updated but can not figure out how to get the dates for the epic updated.  here is the structure of my automations:

Please Help!!

[Michael Wan]

@Minaz Fazal 

This can be accomplished by using a Lookup work items action and two separate branches: one branch for the work items in the sprint, and another branch for their corresponding Epics, as shown below:

There is a limit of 100 work items for the Lookup work items action. 

Hope this helps. 

[Minaz Fazal]

hi @Michael Wan 

so this is still not working for me.  I have also attached the audit log below.  But i did try replacing the first branch with "For Issues in Sprint" instead of the JQL query which did update the start and due dates for the issues in the sprint but the second query for the epics still dont work.  for some reason it looks like the JQL query will not find the items...here is the audit log that i received and the updated automation:

just to clarify, this is the log for JQL query for both the issues and the epic, i tested the "For Issues in Sprint" option separately but have not included the log here.

[Michael Wan]

@Minaz Fazal 

Thanks for your feedback. From the error message and your screenshot, it looks like there might be a missing parenthesis that could be causing the issue (see screenshot below). I had tested the solution on my end and it was working, but it's totally possible that small differences in the code could lead to this. Let me know if fixing that resolves it!