Sequencing workflow actions

[Cathal_Noone]

Is there a way to wait for all actions to complete in a workflow rule and then then complete the last action? In my scenario I have an email that will send after the other rules complete. I want the email to reference data created in the prior actions in the workflow.

[Steve]

Workflow actions are performed in the order given, so it’s really just a matter of ordering them as desired.

[Cathal_Noone]

Thanks Steve, it’s displaying all the associated records from the table, except for all of the records that were generated by the prior actions in the workflow

[Steve]

Please post a screenshot of your workflow configuration.

[Cathal_Noone]

Sorry for the delay Steve,
Quick description: it adds monthly timesheets in an “TimeSheet” Table for employees when a new employee is created in an “Employee” table, depending on start dates and current dates, then emails employee and their supervisor to review the employee details and list the available timesheets. The second part doesn’t work for any that are created in the prior part of the workflow, but if I delete an employee, who has existing timesheets and re add them the existing ones are listed fine.

[Steve]

Can you confirm the new rows are, in fact, being added to the other tables?

Please post a screenshot of the configuration of one of those rules, and of the action that rule invokes.

[Cathal_Noone]

Hi Steve,

Yes the rows are being added with no issues and the email is sending fine.

Here is the action:

Here is the Log of the workflow that I run all looks as expected, they have triggered in the correct sequence and all before the email is sent.

Here is the extract from the google sheet email template. The section at the end, Employee Timesheets, only returns the pre-existing timesheets not the add ones

[Steve · Accepted solution]

I would guess the Related Timesheets virtual column’s value has not been updated. In my experience, the Related … virtual columns are kinda flaky, so I prefer to use explicit queries instead. In that <<Start>> tag, replace [Related Timesheets] with the REF_ROWS() expression from the App formula of the Related Timesheets column.

[Cathal_Noone]

Thanks so much, that fixed it beautifully. I really appreciate the help, it would have taken me a long long time to come up with that fix.