Collecting List Items and Associated Comments to Display in Email

[MKT]

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. 

Thank you,

MKT

[ekarim2020]

We can add three additional actions:

1. Create a HTML Table

 

2. Add some styling for the HTML Table:

Copy the following code:

<style>
table {
  border: 1px solid #1C6EA4;
  background-color: #EEEEEE;
  width: 100%;
  text-align: left;
  border-collapse: collapse;
  table-layout: auto;
}
table td, table th {
  border: 1px solid #AAAAAA;
  padding: 10px;
}
table tbody td {
  font-size: 13px;
}
table thead {
  background: #1C6EA4;
  border-bottom: 2px solid #444444;
}
table thead th {
  font-size: 15px;
  font-weight: bold;
  text-align: left;
  color: #FFFFFF;
  border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
  border-left: none;
}
</style>

 

3. Send Mail using the HTML Table formatting code followed by the HTML Table as shown below:

 

 This is the runtime output of the email:

These are the list comments for item 66:

 

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

[mguzmanBSC_2023]

@ekarim2020 this worked perfectly!  Thank you so much!  I been trying to get this to work for weeks and thanks to you, it finally worked for me.  Kudos to you!

[freshnamehere]

Hi @ekarim2020 ,

i am having this same problem as Christian Dias.

. I tried rebuilding the flow as it was mentioned that it could be a bug, but no luck. Here is the expression I am using: 

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

 Any help would be greatly. appreciated.

[ekarim2020]

Hi @freshnamehere ,

Please see the following for suggestions on how to fix your flow.

The following grabs all the comments for each list item and store them using the Compose action (named Compose Comments): 

Here we store all of the list item comments in the Compose action (named Compose All Comments)

 

You may not need this, but I'm using the Filter Array action to filter out items that don't have any comments:

Next we need another loop to iterate over each list item and their comments:

 

See: How to Extract and Send SharePoint List Item Comments via Email – Ellis Karim's Blog

 

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site