Power Platform Community Forum Thread Details

Assuming the below things

1. The comments from a list item should be joined by semicolon (;) as delimiter.

I am using Business Process column instead of Resolved Notes field for demo purposes so that you can understand how to retrive the comments for a list item.

Step 1. Retrive all items from list using get items

Step 2: loop through each item from output of get items using apply to each loop

Below steps would be explained for steps done under loop

Step 2.1 use send http request to send http request to retrive the comments associated with a prticular list item which is being iterated

Select the site address in which your list is present.

Use the below endpoint

_api/web/lists/getbytitle('List A1')/items(@{items('Apply_to_each')?['ID']})/Comments

List A1 represents the list name of the list in my case and you can replace it as per your requirement.

@{items('Apply_to_each')?['ID']} represents ID component of list item (dynamic content)

The output of send http request would be a body whose each array component under results property has a text property which would have the comments associated with that list item.

so we need to retrive those comments associated with list item using select action.

Expression for From field: body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']

Expression for Map field: item()?['text']

Now the output of the select action would be array of comments associated with one list item, so we need to join them so to include it in the column , for that we will use below expression in compose action