Power Platform Community Forum Thread Details

Hi,

I have a helpdesk ticketing system implemented as a SharePoint list, where each ticket is assigned to an IT agent. I am trying to set up an email notification that includes a table listing all open tickets (older than one week) assigned to a specific agent. My goal is to generate a separate table for each agent. I've attempted to accomplish this using Power Automate, but I keep encountering issues.

That's a summarize of the flow Iv'e been trying to do -
Trigger: Recurrence

Frequency: Weekly
Interval: 1

Action: Get items
- Site Address: [Your SharePoint Site Address]
- List Name: [Your Ticket List Name]
- Filter Query: Status ne 'Closed'

Action: Filter array
- From: Value from "Get items"
- Condition: Created is less than or equal to addDays(utcNow(), -7)

Action: Select
- From: Output of "Filter array"
- Map:
  - AssignedTo: AssignedTo.Email
  - TicketInfo: Title and other ticket details

Action: Initialize variable
- Name: agentTickets
- Type: Array
- Value: []

Action: Apply to each (Output of "Filter array")
- Inside this loop, add another "Apply to each" for "AssignedTo"
Apply to each (assigned person)
- Action: Append to array variable
  - Name: agentTickets
  - Value:
```
jsonCopy code{
  "AssignedTo": item()['AssignedTo'],
  "Tickets": concat(item()['Tickets'], ' ', item()['TicketInfo'])
}
```

Action: Apply to each (Output of "agentTickets" variable)
- Action: Create HTML table
  - From: item()['Tickets']
  - Columns: Automatic

Action: Apply to each (Output of "agentTickets" variable)
- Action: Send an email (V2)
  - To: item()['AssignedTo']
  - Subject: Your Weekly Open Tickets
  - Body: Output of "Create HTML table"