Skip to main content
July 7, 2025
Question

Is this the correct way to send an mail.

  • July 7, 2025
  • 11 replies
  • 0 views

As shown in the above image i have a record table and from this record table i have to retrieve the fields recruiter and candidateID so i can send e-mails to them.

This was my code for retrieving the data from the fields and then sending them automated emails. But, i am not getting any mails. Can anyone please help me about where i went wrong so i can rectify it.

    11 replies

    stefanhelzle0001
    July 7, 2025

    The send email node has a few outputs that provide insights of what email could be sent.

    Receiving an email is a whole different story and heavily depends on external systems (mail servers, DNS, SPAM filters ...) outside of your control.

    July 7, 2025

    But when i choose an user it is sending an email to the user's email.

    stefanhelzle0001
    July 7, 2025

    OK. And the node outputs?

    harshas2775
    July 7, 2025

    your filter code is wrong. 

    field should not have pv!record. It should be just IP Add Details.recruiter , 

    value should have pv!record. So if recruiter columns stores recruiter record then value should be pv!record[IP Add Details.recruiter]. If you understand the code you would want system to filter the rows in record where recruiter field in record matches with provided recruiter value. So value should have pv and field should not! 

    One question I have is the field IP Add Details.recruiter - > what data is in this field? 

    On another note, Is the recruiter id same as recruiter's username in appian? If yes can you replace the lines 5-16 with the below expression and try. 

    toemailaddress(pv!record[IP Add Details.recruiterId])

    July 7, 2025
    One question I have is the field IP Add Details.recruiter - > what data is in this field?

    The recruiter field has the recruiters data like (Recruiter ID, Name, Mail, Phone, DOB)

    harshas2775
    July 7, 2025

    so you mean its a relationship. If thats the case you need to have code like below after correcting the "field" and "value" configurations. 

    toemailaddress(pv!record[IP Add Details.recruiter.mail)

    - please adjust the field name as per exact filed name that you have! 

    shubhama926776
    July 7, 2025

    Have you debug what's the output of queryRecordType?

    Looks like your value part does not represent which value you are trying to filter out(You are passing whole record instead pass recruiter id or some identifier which uniquely identify record.)