Extracting a CSV report and send via email

MohammedYaseen
Tera Expert

Hi All,

I have created a RITM report for  a specific catalog item and scheduled to send the report on a particular time,daily. The format of the file is CSV, When the users recieve the file they dont see the display name in the header , instead they can view the backend value of the field.

How to get this fixed. If it can be sent via flow designer. Please share me the steps. Thanks

3 REPLIES 3

annb19
Tera Guru

Hi @MohammedYaseen ,
Please follow the instructions in the link below and you can export CSV file with the label
Export to CSV files shows column names as Header instead of column labels - Support and Troubleshoot...

annb19_0-1790584346609.png

Hope this helps!

Ankur Bawiskar
Tera Patron

@MohammedYaseen 

csv only shows the backend field/variable value and not the label

you can check this KB but it would be impacting entire platform which I won't recommend

Export to CSV files shows column names as Header instead of column labels - Support and Troubleshoot...

Instead why not use Excel format?

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 10x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Aditya_hublikar
Giga Sage

Hello @MohammedYaseen ,

 

As Suggested by @Ankur Bawiskar i have created 2 system properties , it will work but for all csv reports not for particular table .

 

Aditya_hublikar_0-1790587514510.png

 

Aditya_hublikar_1-1790587544396.pngAditya_hublikar_2-1790587583558.png