"Email validation failed: Table record ID doesn't exist or ACL restricts retrieval" error in flow designer

[Moy1]

Hello experts,

I have created a simple flow that triggers on the updation of a record in a custom table. The flow sends a notification. However, the notification is not getting attached to the target record even though the logs show that the target record is correctly found. Also the flow test execution shows the following error in the 'send email' step:

Email validation failed: Table record ID doesn't exist or ACL restricts retrieval

The flow:

Email log:

[Andrew Albury-D]

Hey Moy,

I've done a fair bit of notification stuff with Flow Designer and I think you might be attacking the problem wrong.

If you are looking to fire a "notification", you probably don't want to use the "Send Email" action in Flow Designer. I've found that Generating an Event record from the flow and firing a notification that way gives you a lot more control over things like "Target" and such.

In flow designer, you can create events by generating a record in the "sysevent" table. You can then pass in the name, state, params and any other details to have them accessible from the Notification. 

You can check the docs on notifications here:
https://docs.servicenow.com/bundle/orlando-servicenow-platform/page/administer/notification/task/t_C...

Let me know how you go!

Andrew

[Moy1]

Andrew, thanks for your response. I tried creating a notification without the flow designer but no luck. The issue remains the same. The emails are sent but they are not tracked in the activity stream of the target record.