web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / HTTP request to ShareP...
Power Automate
Suggested Answer

HTTP request to SharePoint List Item to retreive comments only works with certain lists

(0) ShareShare
ReportReport
Posted on by 2
Hello, I have a SharePoint site with multiple lists.  I built a simple flow to retrieve list item comments from the lists.  The flow works correctly for all but 1 of the lists - for this list, it runs successfully but only returns null for the comments, even if the list item has comments.  I've checked all the list settings I can think of to see if something is different about this list, and I cannot see any differences.  Does anyone know why this flow would be returning null for only one of my lists?
 
Here's my entire flow:
 
Here's a successful run on a list item from a list that does return the comments:
 
And here's a "successful" run on a list item from the list that only returns null - this list item does have comments posted to it:
Categories:
I have the same question (0)
  • BabyBots Profile Picture
    243 on at
    If you're looking to have this resolved ASAP, My recommendation would be to duplicate one of the successful lists and migrate your comments to this new list. If you're looking to debug out of pure interest, I'd love to better understand the following:
     
    • Did the non-functional list have any adjustments to the column name since being created?
    • How many items are present on this list with comments currently?
    • In comparison to how you'd created the other lists, did you take a different approach to creating this one?

    🚀 Automate. Optimize. Innovate. 🚀

    Helping businesses streamline workflows and maximize efficiency with Microsoft Power Platform. Let’s transform your processes and unlock new possibilities!

    Explore BabyBots.ai
  • JN-10021602-0 Profile Picture
    2 on at
    Thanks for the response, so I would be open to duplicating a successful list and migrating comments, the problem is I don't know of another way to migrate the comments - the only way I know would be to use a flow similar to the one in my initial question, but that's the issue - this flow is not working and will not return the comments.  I've answered your other questions in red below:
    • Did the non-functional list have any adjustments to the column name since being created?  Yes, we have changed a few column names in the list since we created the list.  We have also changed the name of the list itself at some point.

    • How many items are present on this list with comments currently?  1,900

    • In comparison to how you'd created the other lists, did you take a different approach to creating this one?  Not that I know of, but I did not create the list, and the person who did no longer works for the company.  I've checked all the list settings I can think of, and everything looks the same as our other lists.


    •  
  • VS-07022055-0 Profile Picture
    4 on at
    Any updates? I'm having the same issue with lists that were working fine now pulling null comments and no result as of a day or so ago....
     
    UPDATE
     
    ahh found this post and this seemed to fix it
  • Suggested answer
    Ellis Karim Profile Picture
    11,695 Super User 2025 Season 2 on at
    Hi JN-10021602-0,
     
    For some reason, the "comments" property in the URI now needs to be in lowercase:
     
     
    You may also want to handle the @mentions in the comments, as they won't be displayed:
     
    When @mention is used in a comment, the user name is not shown.  Only a place holder is shown.
     
     

    Ellis Karim Ellis Karim
    Blog | LinkedIn | Bluesky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard