Hello,
I'm working on creating simple flow to send out an email to a group when a specific SCTask is closed out. The email should pull the New Hire Start Date, (which is in MM-dd-yyyy format) from the SCTask variable field. This is currently not happening, so I tried to use the Date to String transforms to convert it to String format. That also didn't work. See image of part of my flow setup. Could someone review and let me know what I'm doing incorrect here.
Thanks as always.
Hi Koteswara,
I see it's working now after I removed the Custom Format that I had selected in the Date to String transform function.
Hi @RudyS ,
I tried to produce the same use case in my PDI and it worked.
Please refer to the below attached snips:
Flow designer configuration details:
Output: (email log - preview)
I hope this information helped. If it worked, please mark my response as Helpful.
Thanks & Best Regards,
Koteswara Vara Prasad M
Hi Koteswara,
It's still now working for me. This is the full flow I created. Maybe I'm missing something.
Hi @RudyS ,
Could you please check if there are any other SC Tasks with the same Short Description and State = Close Complete? If so, in the first step, it is possible that a different SC Task record (other than the intended one) is being pulled, which does not have the required variable value. As a result, the date field value is missing in the outgoing email.
Please validate this. Alternatively, in the first step of Lookup Catalog Task Record, we can add a filter condition to ensure validation using the SYS_ID.
Other than that I don't see any issue in the snips you attached. I tried to replicate the same but it worked. I am getting the date value in both email subject and body.
Thanks & Best Regards,
Koteswara Vara Prasad M
Hi Koteswara,
I see it's working now after I removed the Custom Format that I had selected in the Date to String transform function.
