Power Platform Community Forum Thread Details

Using HTML to filter the User with SharePoint email

Hello,
I have a Powerapp, with HTML Table,

The aim of this table, to summaries the open actions that assigned to this user form a SharePoint list called action board, below hereunder the code, but it doesn't show any data at all,
My question is how to assure the right matching happening : 'Action Responsible'.Email = User().FullName

Thanks

Concatenate( 
    // Calculate the total number of actions
    "<table border='1' style='width:100%; border-collapse:collapse;'>",
        "<tr>",
            "<th colspan='2' style='text-align:center; padding: 8px;'>Action(s) Summary </th>",
        "</tr>",
        
        // Calculate and display the In Progress before due date count and percentage
        "<tr>",
            "<td style='padding: 8px;'>",
                "<span style='display:inline-block; width:10px; height:10px; background-color:blue; border-radius:50%; margin-right:5px;'></span>",
                "<strong>In Progress before due date</strong></td>",
            "<td style='padding: 8px;'>", 
                Text(CountRows(Filter('Board Actions','Action Responsible'.Email = User().FullName, ActionsStatus = "In Progress before due date"))), 
                " Action(s) ",
        "</tr>",
        
        // Calculate and display the Past due date count and percentage
        "<tr>",
            "<td style='padding: 8px;'>",
                "<span style='display:inline-block; width:10px; height:10px; background-color:red; border-radius:50%; margin-right:5px;'></span>",
                "<strong>Past due date</strong></td>",
            "<td style='padding: 8px;'>", 
                Text(CountRows(Filter('Board Actions','Action Responsible'.Email = User().FullName, ActionsStatus = "Past due date"))), 
                " Action(s)",
        "</tr>",
        
        // Calculate and display the Completed before due date count and percentage
        "<tr>",
            "<td style='padding: 8px;'>",
                "<span style='display:inline-block; width:10px; height:10px; background-color:green; border-radius:50%; margin-right:5px;'></span>",
                "<strong>Completed before due date</strong></td>",
            "<td style='padding: 8px;'>", 
                Text(CountRows(Filter('Board Actions','Action Responsible'.Email = User().FullName, ActionsStatus = "Completed before due date"))), 
                " Action(s)",
        "</tr>",
        
        // Calculate and display the Completed after due date count and percentage
        "<tr>",
            "<td style='padding: 8px;'>",
                "<span style='display:inline-block; width:10px; height:10px; background-color:orange; border-radius:50%; margin-right:5px;'></span>",
                "<strong>Completed after due date</strong></td>",
            "<td style='padding: 8px;'>", 
                Text(CountRows(Filter('Board Actions','Action Responsible'.Email = User().FullName, ActionsStatus = "Completed after due date"))), 
                " Action(s) ",
        "</tr>",
    "</table>"
)