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

[suraj sengar]

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!

[suraj sengar]

No, Do we have any option for Excel creation?

[Ankur Bawiskar · Accepted solution]

@suraj sengar 

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! 🙏