Create an email notification for tickets that been open over 1 week

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 eq 'Open'
• 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"