Unanswered

Is there a way to filter a SharePoint List by items with comments?

(0) Share

Report

Posted on by PAJenRed

Using MS Lists I want to add an ability to filter items that have comments. I have no coding experience but any help would be appreciated. I have access to PowerAutomate but would need guidance on how to accomplish this if I need to go that route.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @PAJenRed,

You can use the _CommentCount field in a HTTP request. That field does not seem to be available in normal actions. However, you can workaround that by using the RenderListDataAsStream method.

Below is an example

URI

_api/web/lists/getbytitle('@{variables('ListName')}')/RenderListDataAsStream?View=@{variables('ViewID')}&FilterField1=_CommentCount&FilterOp1=Geq&FilterValue1=1

Body

{"parameters":{"__metadata":{"type":"SP.RenderListDataParameters"},"RenderOptions":1463815,"AddRequiredFields":true,"RequireFolderColoringFields":true}}

Was this reply helpful? Yes No
PAJenRed 4 on at

Like (0)

Report

Is this intended to create a new view that is filtered to only those with comments? My goal is to add a column that we can then filter on, not create a new view.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @PAJenRed,

No, it is using an existing view of my list. In my example the All Items view. I stored the id of that view in a variable.

With the RenderListDataAsStream method it will return the _CommentCount column for that existing view. With the FilterField1, FilterOp1 & FilterValue1 parameters you can filter directly in the query.

Was this reply helpful? Yes No
PAJenRed 4 on at

Like (0)

Report

Here is how I have this built. Does it appear to be correct? Where should I be able to see the counts that we will then be able to filter on within the LISTS UI?

Was this reply helpful? Yes No