Which column refers "from" in sys_email table?

[divyadhanda]

I am trying to implement inbound email action via flow designer.
I need to trigger the flow and create incident record only when i get an email from particular email address.

Here, i am creating the emails using bg script as we dont have such emails in the dev.

Script:

var emailGr = new GlideRecord('sys_email');

emailGr.initialize();

emailGr.type = 'received';

emailGr.state = 'processed';

emailGr.from = 'posdt-alerts@discounttire.com';

emailGr.setValue('from', 'posdt-alerts@discounttire.com');

emailGr.headers = 'From: posdt-alerts@discounttire.com\nSubject: POSDT Sale GK 1048 08/19/2026 POS 9991 Txn ' + uniqueStamp;

emailGr.body = 'test.';

var emailSysID = emailGr.insert();

gs.print('### Test-Ready Email Created! Sys_ID: ' + emailSysID);

But, if condition is not triggered for this email.

Also, i am wondering there is no from column in sys_email table. Do we have any other column to identify from which email address this email has come from ?

[harishk07]

Hi,

There are two separate issues here.

The "from" column - sys_email does not have one. The sender address is in the headers field (email headers), and after processing it resolves into the user reference field via sys_user lookup. Your emailGr.from and setValue('from', ...) lines are ignored because that column does not exist.

For the flow not triggering - Flow Designer's Inbound Email trigger fires from the email processing pipeline, not from sys_email inserts. Your GlideRecord insert bypasses that pipeline. On top of that, you set state = 'processed', which tells the platform the email is already handled.

Find any existing received email in sys_email, edit its headers to include the From: address you want to test, then use Reprocess Email from the record's context menu. That pushes it back through the inbound pipeline and your flow trigger will evaluate.

For the flow condition, use the trigger's data pill for the sender and not a sys_email column.