Power Platform Community Forum Thread Details

I have been racking my brain with this for a couple of days now and any potential solution does not seem to work. I appreciate any help with this.

I have a flow setup that gets items from a MS List that are pending and 3 or more days older. Then any manager with items in that get items, I want to create a consolidated table and email it to them.

I go through a Select and Compose to get a list of unique manager emails in that list. Then there is an Apply to Each which has a filter array.

All of that works fine. As does the send an email. The issue comes with the Create the HTML table in between the Filter Array and the Send an email. I am certain it has to do with the value(s) trying to be pulled, but I cannot figure it out.

I want the HTML table that would be in the body of an email being sent to the manager that has the Display Name of the person that created the request and the PTO dates. The Filter array fields are Author.DisplayName and PTODate_x0028_s_x0029

As you can see in the create HTML table, I am reading from the filter array. But I cannot figure out what values to put in for the Requested by and the PTO Dates to NOT get an error. When I try to read the get items data, it creates a for each loop and sends each item separately in an email.

Here is the output from the filter array when I test the flow without the Create HTML table in it. The Filter array data I want to put in the html table are Author.DisplayName and PTODate_x0028_s_x0029 . I have highlighted them in yellow.

{
    "body": [
        {
            "@odata.etag": "\"14\"",
            "ItemInternalId": "67",
            "ID": 67,
            "Location": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Outer Banks Blue"
            },
            "Location#Id": 0,
            "Author": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|dave@outerbanksblue.com",
                "DisplayName": "Dave Roberts",
                "Email": "dave@outerbanksblue.com",
                "Picture": "https://obblue.sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=dave@outerbanksblue.com",
                "Department": "Operations",
                "JobTitle": "VP of Operations & Strategy Deployment"
            },
            "Author#Claims": "i:0#.f|membership|dave@outerbanksblue.com",
            "RequestDate": "2025-12-04",
            "Status": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Pending"
            },
            "Status#Id": 0,
            "PTO_Type": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Regular"
            },
            "PTO_Type#Id": 0,
            "PTODate_x0028_s_x0029_": "Dec 10",
            "NumberofPTOHours_x003a_": 8,
            "LastMinuteRequest_x003a_": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "No"
            },
            "LastMinuteRequest_x003a_#Id": 0,
            "LastMinuteReason": "N/A",
            "Whowillcoverresponsibilitieswhil": "Self",
            "Notes_x002f_Comments_x003a_": "Test for Location in Email.",
            "Supervisor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|dave@outerbanksblue.com",
                "DisplayName": "Dave Roberts",
                "Email": "dave@outerbanksblue.com",
                "Picture": "https://obblue.sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=dave@outerbanksblue.com",
                "Department": "Operations",
                "JobTitle": "VP of Operations & Strategy Deployment"
            },
            "Supervisor#Claims": "i:0#.f|membership|dave@outerbanksblue.com",
            "SupervisorDateofApproval": "2025-12-12",
            "ApprovalHistory": "2025-12-12",
            "ProcessorEmail": "dave@outerbanksblue.com",
            "HRUseOnly": [],
            "HRUseOnly@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
            "HRUseOnly#Id": [],
            "HRUseOnly#Id@odata.type": "#Collection(Int64)",
            "OData__ApprovalAssignedTo": [],
            "OData__ApprovalAssignedTo@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
            "OData__ApprovalAssignedTo#Claims": [],
            "OData__ApprovalAssignedTo#Claims@odata.type": "#Collection(String)",
            "OData__ApprovalRespondedBy": [],
            "OData__ApprovalRespondedBy@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
            "OData__ApprovalRespondedBy#Claims": [],
            "OData__ApprovalRespondedBy#Claims@odata.type": "#Collection(String)",
            "Modified": "2025-12-12T13:29:14Z",
            "Created": "2025-12-10T11:50:40Z",
            "Editor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|dave@outerbanksblue.com",
                "DisplayName": "Dave Roberts",
                "Email": "dave@outerbanksblue.com",
                "Picture": "https://obblue.sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=dave@outerbanksblue.com",
                "Department": "Operations",
                "JobTitle": "VP of Operations & Strategy Deployment"
            },
            "Editor#Claims": "i:0#.f|membership|dave@outerbanksblue.com",
            "{Identifier}": "Lists%252fPTO%252f67_.000",
            "{IsFolder}": false,
            "{Thumbnail}": {
                "Large": null,
                "Medium": null,
                "Small": null
            },
            "{Link}": "https://obblue.sharepoint.com/_layouts/15/listform.aspx?PageType=4&ListId=41de8262%2Dc72b%2D4620%2Da744%2D41fa2783f58e&ID=67&ContentTypeID=0x0100A994ECFE91110C46AEE0EC735817E79F00C7DFF3CBC8B39F4EA9026D3116E08026",
            "{Name}": "",
            "{FilenameWithExtension}": "",
            "{Path}": "Lists/PTO/",
            "{FullPath}": "Lists/PTO/67_.000",
            "{ContentType}": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
                "Id": "0x0100A994ECFE91110C46AEE0EC735817E79F00C7DFF3CBC8B39F4EA9026D3116E08026",
                "Name": "Item"
            },
            "{ContentType}#Id": "0x0100A994ECFE91110C46AEE0EC735817E79F00C7DFF3CBC8B39F4EA9026D3116E08026",
            "{HasAttachments}": false,
            "{VersionNumber}": "14.0",
            "{ApprovalStatus}": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedApprovalStatus",
                "Value": 0,
                "Label": "Not submitted"
            },
            "{ApprovalStatus}#Value": 0
        },
        {
            "@odata.etag": "\"2\"",
            "ItemInternalId": "70",
            "ID": 70,
            "Location": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Outer Banks Blue"
            },
            "Location#Id": 0,
            "Author": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|sophie@outerbanksblue.com",
                "DisplayName": "Sophie Vermillion",
                "Email": "sophie@outerbanksblue.com",
                "Picture": "https://obblue.sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=sophie@outerbanksblue.com",
                "Department": "Operations",
                "JobTitle": "Warehouse Coordinator"
            },
            "Author#Claims": "i:0#.f|membership|sophie@outerbanksblue.com",
            "RequestDate": "2025-12-07",
            "Status": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Pending"
            },
            "Status#Id": 0,
            "PTO_Type": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "Regular"
            },
            "PTO_Type#Id": 0,
            "PTODate_x0028_s_x0029_": "12/13/2025",
            "NumberofPTOHours_x003a_": 4,
            "LastMinuteRequest_x003a_": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 1,
                "Value": "Yes"
            },
            "LastMinuteRequest_x003a_#Id": 1,
            "LastMinuteReason": "N/A",
            "Whowillcoverresponsibilitieswhil": "Patrick",
            "Supervisor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|dave@outerbanksblue.com",
                "DisplayName": "Dave Roberts",
                "Email": "dave@outerbanksblue.com",
                "Picture": "https://obblue.sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=dave@outerbanksblue.com",
                "Department": "Operations",
                "JobTitle": "VP of Operations & Strategy Deployment"
            },
            "Supervisor#Claims": "i:0#.f|membership|dave@outerbanksblue.com",
            "HRUseOnly": [],
            "HRUseOnly@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
            "HRUseOnly#Id": [],
            "HRUseOnly#Id@odata.type": "#Collection(Int64)",
            "OData__ApprovalAssignedTo": [],
            "OData__ApprovalAssignedTo@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
            "OData__ApprovalAssignedTo#Claims": [],
            "OData__ApprovalAssignedTo#Claims@odata.type": "#Collection(String)",
            "OData__ApprovalRespondedBy": [],
            "OData__ApprovalRespondedBy@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
            "OData__ApprovalRespondedBy#Claims": [],
            "OData__ApprovalRespondedBy#Claims@odata.type": "#Collection(String)",
            "Modified": "2025-12-12T14:15:58Z",
            "Created": "2025-12-12T13:48:21Z",
            "Editor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|dave@outerbanksblue.com",
                "DisplayName": "Dave Roberts",
                "Email": "dave@outerbanksblue.com",
                "Picture": "https://obblue.sharepoint.com/_layouts/15/UserPhoto.aspx?Size=L&AccountName=dave@outerbanksblue.com",
                "Department": "Operations",
                "JobTitle": "VP of Operations & Strategy Deployment"
            },
            "Editor#Claims": "i:0#.f|membership|dave@outerbanksblue.com",
            "{Identifier}": "Lists%252fPTO%252f70_.000",
            "{IsFolder}": false,
            "{Thumbnail}": {
                "Large": null,
                "Medium": null,
                "Small": null
            },
            "{Link}": "https://obblue.sharepoint.com/_layouts/15/listform.aspx?PageType=4&ListId=41de8262%2Dc72b%2D4620%2Da744%2D41fa2783f58e&ID=70&ContentTypeID=0x0100A994ECFE91110C46AEE0EC735817E79F00C7DFF3CBC8B39F4EA9026D3116E08026",
            "{Name}": "",
            "{FilenameWithExtension}": "",
            "{Path}": "Lists/PTO/",
            "{FullPath}": "Lists/PTO/70_.000",
            "{ContentType}": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
                "Id": "0x0100A994ECFE91110C46AEE0EC735817E79F00C7DFF3CBC8B39F4EA9026D3116E08026",
                "Name": "Item"
            },
            "{ContentType}#Id": "0x0100A994ECFE91110C46AEE0EC735817E79F00C7DFF3CBC8B39F4EA9026D3116E08026",
            "{HasAttachments}": false,
            "{VersionNumber}": "2.0",
            "{ApprovalStatus}": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedApprovalStatus",
                "Value": 0,
                "Label": "Not submitted"
            },
            "{ApprovalStatus}#Value": 0
        }
    ]
}