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.

[divyadhanda]

So, you want me to look for the headers instead of from? 

Is there any other way to look for the from address ??

[harishk07]

Yes, use the Email data pill on the trigger instead of Email Record > Headers. It gives you the sender parsed out directly, so you can just compare against the email ID in your screenshot.

I notice that in condition 1 has an email address, which is your instance address, not the sender. And Condition 2 checks State is Processed, but during flow execution the email has not reached that state yet, so this will filter out every real email.

[Ankur Bawiskar]

@divyadhanda 

the To field contains the actual recipient and Recipients contains combination of To and CC

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏