I am trying to copy an email from the sys_email table to a new record with a new target, and have the emails appear in the right order in the activity feed of the new record. The use case is we have teams working in different spaces (scoped app and incident space) that need to send records to each other, thus needing the new records activity feed mirror the original.
I am working within flow designer to look up the records on the sys_email table with the target the same as the original record, then copy each of those emails to a new record with the new incident number as the target.
I have everything working as expected, the emails are showing in the activity feed as expected on the incident, however, they are coming in out of order. The order which they copy over is inconsistent.
I tried adjusting this order by field with no luck
We have configured this functionality previously using business rules, but are wanting to move this to a more repeatable sub-flow, hence recreating in Flow Designer. In the business rule, we have the following script which I believe prevents the original record from being updated. I am trying to figure out how apply the same 'autoSysFields(false)' to these fields within Flow Designer.
incemail.sys_created_by = prcemail.sys_created_by;
incemail.sys_updated_on = prcemail.sys_updated_on;
incemail.sys_updated_by = prcemail.sys_updated_by;
incemail.autoSysFields(false);
incemail.update();
I have tried to update the scrip for those fields, but have been unsuccessful in making this work properly.
Has anyone else run into this same issue or know how to script within these data
