Triggered action to send email issues

[NickO]

I am trying to create a triggered action with notifies a group of users in the AuthUsers table when the record meets certain criteria. I use it successfully in other tables but it is choking here for some reason and saying it expects a single value. Any thoughts on why or how to get around that?  I have trimmed down just the relevant code (hopefully) to save space as it has a lot of variables for populating the email message.

 

As a reference, I use something very similar, just without the If/Then in another table and it runs without issue.

[CoopperBackpack]

Hello @NickO,

I believe you may use another approach for this Trigger. It is better to avoid using the If-Then block when you can use the Select statement instead. 

Could you test the Trigger design like this?

So, you may add the Select statement by clicking the Gear icon and select the record from the #inserted table that met the criteria.

If the criteria are met the email for a group of users is send. 

Feel free to update this thread in case you have additional questions. 

[NickO]

Hi @CoopperBackpack, thanks for the suggestion. This does clear the error in the Triggered Actions builder, but I get a much less helpful "Record cannot be saved because an error was encountered in Triggered Actions." I stripped it down to just the email (changing the message to a generic text for testing). I am not sure if it makes a difference because the #inserted should deal only with the record being inserted, but this is a pretty big table the record is being added to. I also tried to add the "Top 1" condition to the select statement at the top and got the same error. Wish it was more descript about what is failing. I also tested it with Marketing Produced set to unchecked/false to see if it would just add that record. I got the same error. 

 

[CoopperBackpack]

Hi @NickO,

I tested the Trigger in my account and it works properly. I received email when I added the new  record where the value is True in the MarketingProduced field. 
As far as I know this error "Record cannot be saved because an error was encountered in Triggered Actions" should be related to the data in the table. 

Do you have Formula field or unique field in the table with the Trigger?

 

[NiceDuck]

such kind of error will normally not occur if you only have an email block inside your trigger. As mentioned by @CoopperBackpack, do yuo happend to have a unique field on table? You may also want to check on other tables where that is being mentioned or referenced by your current trigger.

[NickO]

@CoopperBackpack and @NiceDuck thanks for the replies and sorry for the delayed response. I had to dip out for a few days and am sort of back now. Long story short, no unique fields or formula fields. Nothing out of the ordinary from what I can tell. All that said, I started a new triggered action from scratch, exact same as the others (using the WHERE clause to ID which records to trigger the email alert as CoopperBackback suggested) and it works fine. IDK why the other one was choking, but it's good to go now.

[kpcollier]

For what it's worth, I had this same issue with the same error message on a trigger a few days ago. I couldn't figure out the issue and neither could support. Recreating from scratch fixed it. I think there is just a bug in the trigger designer at the moment. 

[rutherfordschool]

This can be used, for example, to send a confirmation email to the customer

[TellMeWhy]

23 hours ago, rutherfordschool said:

This can be used, for example, to send a confirmation email to the customer

Is this a question? If so, Forms have built in email functionalities you can test out https://howto.caspio.com/automatic-emails/acknowledgement-and-notification-emails/