Export to Excel with comments

Hi,

Is it possible to export tickets to Excel with the ticket comments? (only need the first/opening comment)

Regards,

Steve

Hello, Steven.

Unfortunately, standard SharePoint export to Excel will not work for you in this case: it exports only fields of a current list but tickets comments are stored in a separate one and are associated with tickets in their metadata. I suppose the only way you have is using of Microsoft Power Automate.

HelpDesk has own connector for the service. You can use its actions to get ticket properties and comments. Then you can use the retrieved data in the Excel action "Add a row into a table":

image