I'm trying to use the Power Automate ServiceNow connector to retrieve the last comments for either an incident or request. Connector is working fine to retrieve task details, it is purely comments that isn't working.
Example of my List Records step to retrieve the entries from the sys_journal_field for the specific task record (using its sysid).
Just returns an empty result:
From my perspective, this should just work so not sure what the issue might be. I did have to add in sys_journal_field as a custom value in the Record Type field.
Would love to know if any one else is able to retrieve ticket comments via the connector in Power Automate.
After a little bit of Googling and much trial and error, figured out a workaround to get the comments. I enabled "Display System references" to have the records retrieval bring back the additional comments for the ticket:
Then did some string manipulation to split out into an array. Also filtered any comments created by System. As a note, the separator for comments is \n\n.
After a little bit of Googling and much trial and error, figured out a workaround to get the comments. I enabled "Display System references" to have the records retrieval bring back the additional comments for the ticket:
Then did some string manipulation to split out into an array. Also filtered any comments created by System. As a note, the separator for comments is \n\n.
