cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MKT
Regular Visitor

Collecting List Items and Associated Comments to Display in Email

Hello,

I’m using “GET” to capture all list items that have a ‘canceled’ status.  Then adding a “Send HTTP Request to SharePoint” to capture the associated list comments, for those items.  When my FLOW runs, it only outputs the items that actually have comments and ignores the other canceled items.  I wish to send an email containing ALL canceled items with their associated comments and display N/A, if no comments exist.  Can someone please advise what steps I might be missing here and how I need to adjust my FLOW?  I’m very new to Power Automate, so any assistance, especially with screen shots is appreciated. 

 

MKT_0-1631232226253.png

 

MKT_1-1631232226258.png

 

MKT_2-1631232226260.png

 

MKT_3-1631232226262.png

 

Thank you,

MKT

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Super User
Super User

Here is a flow that grabs all comments for a SharePoint List and sends them as an email.

ekarim2020_28-1631313503582.png

The body of the email consists of the SharePoint item ID followed by the comments, if any:

ekarim2020_12-1631310970714.png

Here is the high-level flow:

ekarim2020_27-1631313217401.png

Staring with Get items, and initializing variables:

ekarim2020_15-1631311207747.png

(2) Apply to Each loop -  for each SharePoint list item, get the comments using a SharePoint REST API:

ekarim2020_17-1631311291812.png

Use Send HTTP request to SharePoint to get the list item comments:

ekarim2020_19-1631311499650.png

 

 

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

  "accept": "application/json;odata=verbose",
  "content-type": "application/json;odata=verbose"

 

 

Store the comments in a compose action. Note the comments are returned as an array.

ekarim2020_20-1631311586348.png

 

 

Compose action:
@{outputs('Send_an_HTTP_request_to_SharePoint')?['body/d/results']}

 

 

Now check to see if there are any comments :

ekarim2020_21-1631311773320.png

 

 

length(outputs('Compose_Results'))

 

 

ekarim2020_24-1631312415941.png

Yes, true condition - there are comments:

ekarim2020_26-1631312926825.png

No, false condition - there are NO comments:

ekarim2020_23-1631312355813.png

Finally the send mail action:

ekarim2020_25-1631312541342.png

ekarim2020_12-1631310970714.png

 

Hope this provides some guidance.

Ellis

View solution in original post

8 REPLIES 8
MKT
Regular Visitor

Adding a summary screen shot of entire flow:

MKT_0-1631296989289.png

 

ekarim2020
Super User
Super User

See the following post: Get Microsoft Lists Comments using Flow

https://powerusers.microsoft.com/t5/Building-Flows/Get-Microsoft-Lists-Comments-using-Flow/m-p/78741...

Ellis

MKT
Regular Visitor

Thanks Ellis, I am able to get the comments.  My problem is figuring out how to output items in an email that don't have comments, along with those that do.  

 

Thanks,

MKT

ekarim2020
Super User
Super User

Here is a flow that grabs all comments for a SharePoint List and sends them as an email.

ekarim2020_28-1631313503582.png

The body of the email consists of the SharePoint item ID followed by the comments, if any:

ekarim2020_12-1631310970714.png

Here is the high-level flow:

ekarim2020_27-1631313217401.png

Staring with Get items, and initializing variables:

ekarim2020_15-1631311207747.png

(2) Apply to Each loop -  for each SharePoint list item, get the comments using a SharePoint REST API:

ekarim2020_17-1631311291812.png

Use Send HTTP request to SharePoint to get the list item comments:

ekarim2020_19-1631311499650.png

 

 

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

  "accept": "application/json;odata=verbose",
  "content-type": "application/json;odata=verbose"

 

 

Store the comments in a compose action. Note the comments are returned as an array.

ekarim2020_20-1631311586348.png

 

 

Compose action:
@{outputs('Send_an_HTTP_request_to_SharePoint')?['body/d/results']}

 

 

Now check to see if there are any comments :

ekarim2020_21-1631311773320.png

 

 

length(outputs('Compose_Results'))

 

 

ekarim2020_24-1631312415941.png

Yes, true condition - there are comments:

ekarim2020_26-1631312926825.png

No, false condition - there are NO comments:

ekarim2020_23-1631312355813.png

Finally the send mail action:

ekarim2020_25-1631312541342.png

ekarim2020_12-1631310970714.png

 

Hope this provides some guidance.

Ellis

MKT
Regular Visitor

  • Thanks for all the detail Ellis, this worked perfectly.  Appreciate your help! 

Great solution! I'm running into a problem though: Comments are returned in a massive "blob" (HTML?). I tried to fix it by using a "Convert html to text" action in my flow, but got the same result...

caheynen
Frequent Visitor

When the "@" Mention is used, the comments return with jibberish.

This was sent to @James Shew and it comes back as @mention{0} 

 

 

Thank you! That helped!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,896)