We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Inbound email attached excel to Catalog Request

armanoj
Mega Sage

‎10-14-2024 05:16 AM

Hi,

I requirement is when an inbound email with specific subject , then the attached excel data use to create catalog request for specific item. Need to to create REQ,RITM,SCTASK for the each data.

0 Helpfuls
  • 911 Views
6 REPLIES 6

KSreeVamsi
Tera Contributor

‎10-14-2024 09:07 AM

Hi @armanoj ,

Will the excel sheet contain the data to make the request or should it be just attached to the request once the email is received?

0 Helpfuls

armanoj
Mega Sage
In response to KSreeVamsi

‎10-15-2024 03:43 AM

Hi @KSreeVamsi ,

 

Excel contain corresponding field data.

0 Helpfuls

KSreeVamsi
Tera Contributor
In response to armanoj

‎10-15-2024 07:05 AM

Hi @armanoj,

So each row of the excel sheet will be a separate request by itself right?

0 Helpfuls

vermaamit16
Kilo Patron

‎10-15-2024 04:35 AM

Hi @armanoj 

 

You can create a flow with trigger as Email Received with particular subject line. Inside the flow, make use of Lookup Email Attachments action to get the attachment and create records. Refer https://www.servicenow.com/community/developer-forum/servicenow-flow-read-email-attachment-file-and-...

https://www.servicenow.com/community/developer-forum/flow-designer-for-inbound-emails-with-multiple-...

 

Thanks and Regards

Amit Verma

Thanks and Regards
Amit Verma
0 Helpfuls