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

How to export specific fields from Multiple Child Incidents into a single Excel file?

Not applicable

Hi everyone,
​I’m working on a requirement where I need to generate an Excel file containing data from multiple Child Incidents associated with a parent record.
​Specifically, I need the export to include the following fields from the child records:
​Incident Number
​Short Description
​Subject Person (or 'Requested For' name)
​My Goal:
I want to be able to trigger this export (either via a UI Action or a scheduled process) and ensure it captures the related child incident data accurately, even if the fields are on the User table (like the name of the Subject Person).
​Questions:
​What is the most efficient way to achieve this? (e.g., Export Sets, Data Broker, or a custom Script Include?)
​How can I ensure I am pulling the "Name" string of the Subject Person rather than just the SysID in the Excel output?
​If using a UI Action, is there a way to prompt the download immediately for the user?
​Any scripts, Flow Designer suggestions, or architectural advice would be greatly appreciated!

1 ACCEPTED SOLUTION

@Community Alums 

I think xls is possible but not XLSX

check this link and it has solution for XLS

Exporto MRVS to Excel 

💡 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

View solution in original post

6 REPLIES 6

Not applicable

No, Do we have any option for Excel creation?

@Community Alums 

I think xls is possible but not XLSX

check this link and it has solution for XLS

Exporto MRVS to Excel 

💡 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