This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Recipient Expression for Notification not Returning Emails

Posted on 09-27-2022 01:24 PM
Anton_Dickens
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Hi,

I have a bot to send a monthly notification to a group of users with a link to complete a form - nothing fancy.

I'm having some bother getting the following expression to yield email addresses for the "To" field in the process - SELECT(PersonnelList1[Email],AND([Weekly JSA Review Prompt]="TRUE",[Status]="Active")TRUE). The entity table is set to PersonnelList1.

When I run the test on the expression, for a split second it looks like a result shows up (not sure if it is returning the correct result or not), then disappears. Then test running the bot shows that "To" is missing or invalid.

I would love some help on this please! Thank you in advance!

Anton

0 13 380
Topic Labels
0 Likes
13 REPLIES 13
Top Labels in this Space