Import email attachment data directly from mail attachment to servicenow table

Aakhiil
Tera Expert

‎11-13-2023 09:47 AM - edited ‎11-13-2023 09:48 AM

Hi Experts 
Good Day!
When ever the user sends mail attachment(xlsx) for data load. Actual process is ( "Data Load -> staging table -->Import data --> Transfer map.") This is manual process.
But as per my requirement when I got mail with attachment. That attachment data will directly place into servicenow table  without using data source and transfer map. For that I have created a flow design But some how its not working as expected.
Can someone please help. Please find below screenshots.
Any help will be appreciated.

Thanks in Advance 
Aakhiil

Aakhiil_0-1699897117847.png

Aakhiil_1-1699897153004.png

Aakhiil_2-1699897207588.png

Aakhiil_3-1699897244331.png

Aakhiil_4-1699897281063.png

 

Aakhiil_5-1699897312932.png

 

Aakhiil_6-1699897357488.png

 

Aakhiil_7-1699897393528.png

 

Aakhiil_8-1699897432463.png

 

 

 

Preview file
110 KB
Preview file
29 KB
Preview file
21 KB
Preview file
12 KB
Preview file
26 KB
Preview file
52 KB
Preview file
36 KB
Preview file
37 KB
Preview file
76 KB
0 Helpfuls
  • 653 Views
2 REPLIES 2

Tony Chatfield1
Kilo Patron

‎11-13-2023 11:50 AM

Hi, unfortunately partial screenshots do not clarify exactly what is\isn't working for your configuration.

Perhaps you can update this thread with details of your diagnostics, IE where does your flow fail? Is the new file attached to the data source?

0 Helpfuls

Aakhiil
Tera Expert
In response to Tony Chatfield1

‎11-13-2023 05:52 PM - edited ‎11-13-2023 05:54 PM

Hi @Tony Chatfield1 

Thanks for your response. Actually when I test this flow it was completing 2 activities only.

Remaining activities not yet run.

My first doubt is that my approach is correct?

Where I did mistake I am not sure could you please help ?

0 Helpfuls