RecipientEmails in Send Email function

Jasleenk
Jasleenk Member
in Workflows

Hi, I am using SendEmail function for the first time. I have 2 columns in my Dataset - Email and Email2. I want to send emails to Ids present in both these columns of that row.

I am struggling with the email format to be used in Recipient Email column- I tried the one below in snapshot and it didn't work. Kindly help. Thanks

image.png
Tagged:

Answers

  • JosephMeyers
    JosephMeyers Domo Employee

    You are passing IDs into a field expecting email addresses. Are these IDs user IDs within Domo? If so you will want to convert those IDs into the person type using the DOMO Entity Conversion package and then passing those into the sendEmail function as personRecipients.

  • Jasleenk
    Jasleenk Member

    No, Email and Email2 are column names containing email addresses of external contacts not in DOMO.

  • JosephMeyers
    JosephMeyers Domo Employee

    Are you querying the dataset in this workflow or just trying to put the column names in directly? Can you share more details of exactly what you are doing in your workflow and what specifically isn't working? I feel like I don't have enough information.

  • Jasleenk
    Jasleenk Member

    I am querying the table- please find detailed snapshots below

    1- Test1, Test2 are the Email fields renamed for testing purpose. Result is stored in a list oject- datasetRows.

    image.png

    2- Getting the index to point at one current row from the list object and results are stored in variable- object

    image.png

    3- Using 'Send Email' function to send email to the address in the current row indexed.

    image.png

    Tried using a hardcoded valid email in RecipientEmail field- It works fine. I am trying to use the value present under column Test2 dynamically using object["Test2"].

    Test run results are a success but no email is received

  • JosephMeyers
    JosephMeyers Domo Employee

    Which version of sendEmail are you using. There was a recent bug with one of the versions that has since been fixed.

  • Jasleenk
    Jasleenk Member

    Version 2.1.6

Categories