+ Start a Discussion
St2018St2018 

Flow formula not evaluting correctly and not display value in visualforce email template

I have flow. The conditions the flow should run on is when the picklist field  called status = Completed and the field trackUrl is not blank/null
Then the flow will fire off an email alert. This is my formula in the flow.
 
ISPICKVAL({!$Record.Status},"Completed" ) && NOT(ISBLANK({!$Record.Shipment__r.TrackingUrl}))


When I test it  regardless if a value is present or not in the trackUrl field the flow still send an email. Which i don't want.  It should only work when it has correct status and a value exist in trackUrl field.

Second part  is I would like to display the trackUrl value in the email template. While testing the value is not displaying in the visualforce email template. Can someone help?

What i have in my VF template

{!relatedTo.Shipment__r.TrackingUrl}


 
PriyaPriya (Salesforce Developers) 

Hey,

I checked the condition formula, It is working fine for me. When The status is completed and one custom field is not blank then send email. It is working. 

So you may have to  check if something deleting the value for the field Tracking URL. 

Regards,

Priya Ranjan