Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Flow failing at email ...
Power Automate - Building Flows
Unanswered

Flow failing at email with most recent data from excel

(0) ShareShare
ReportReport
Posted on by JamieCoop 12

Hi,

 

I have been trying to create a automated email after a form is completed that includes info from the most recently entered row linked to the spreadsheet.

 

Following a guide I’ve got a setup in PA like this:

 

  1. when a new response is submitted [form id]
  2. List rows present in table [linked table]
  3. Compose

used the following code to select the last row - 

 

 

 

last(body('List_rows_present_in_a_table')?['value'])

 

 

 

    4. Send email

 

used the following code to select relevant column names from the last row

 

 

 

outputs('Compose’)?[‘Next’]

 

 

 

 

Unfortunately this is failing the test at the 4th stage with an error

 

 

 

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_notification_(V3)' inputs at line '1' and column '1997': 'The template language expression 'outputs('Compose')?['Next'] ' cannot be evaluated because property 'Next' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.

 

 

 

 

 

Im confused why its saying its not a supported value as I thought that was just a reference for what the column is called? Any help would be much appreciated!

  • JamieCoop Profile Picture
    JamieCoop 12 on at
    Re: Flow failing at email with most recent data from excel

    Ive tried that and still getting the same error unfortunately 😞 

  • v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Flow failing at email with most recent data from excel

    Hi @JamieCoop,

     

    Please combine the two expressions and test them again:

    last(body('List_rows_present_in_a_table')?['value'])['Next']

    Annotation 2019-11-29 163536.png

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • JamieCoop Profile Picture
    JamieCoop 12 on at
    Re: Flow failing at email with most recent data from excel

    output.jpg

     

    This was the body in the output:

     

    {
 "@odata.context": "https://excelonline-we.azconn-we.p.azurewebsites.net/$metadata#drives('b%21iA7ryGZrBEm1VyiHmyeXWxqmnpMRvstPg_x3fBLafdCUQKMQ6bicSI-XG6uMUdxK')/Files('01I4N36F7PCVQ6AAYDOVDYT5YB2TKIKYND')/Tables('%7B00000000-000C-0000-FFFF-FFFF00000000%7D')/items",
 "value": [
 {
 "@odata.etag": "",
 "ItemInternalId": "42848bcb-3653-4078-9a33-bb00020ddba2",
 "ID": "1",
 "Start time": "43789.4668865741",
 "Completion time": "43789.4670023148",
 "Email": "anonymous",
 "Name": "",
 "Overall": "No",
 "Comments": "[REDACTED]",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "97107b78-5078-46f2-85ac-8941e37b433d",
 "ID": "2",
 "Start time": "43789.4737615741",
 "Completion time": "43789.4738773148",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "CDNSFKSJDFNS",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "121751db-8f7f-4f10-870f-5c89222bd8d0",
 "ID": "3",
 "Start time": "43789.4828472222",
 "Completion time": "43789.4828819444",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "fghjk",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "1a8b5f97-0bd2-41a5-b70a-bb3d9de4a583",
 "ID": "4",
 "Start time": "43789.4844791667",
 "Completion time": "43789.4845138889",
 "Email": "anonymous",
 "Name": "",
 "Overall": "No",
 "Comments": "asdfgh",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "c5fcfe2e-f515-4d4a-955b-64b680f84450",
 "ID": "5",
 "Start time": "43789.4857291667",
 "Completion time": "43789.485775463",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "sdfdsf",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "8d0575a2-a2f1-4f2a-996b-13be4414e74d",
 "ID": "6",
 "Start time": "43789.4865162037",
 "Completion time": "43789.4865509259",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "sdfdsfsdfs",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "dfd7d572-97a8-4cd5-b078-e3477d0b3117",
 "ID": "7",
 "Start time": "43789.4931828704",
 "Completion time": "43789.4932291667",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "esrtfyhjkl;",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "f26fa45c-5fe0-4240-88ce-07ec7e70ed9d",
 "ID": "8",
 "Start time": "43789.5098263889",
 "Completion time": "43789.5098726852",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "asdfghjdfs",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "1d41ebea-a950-4ae1-99af-bd5128ef6935",
 "ID": "9",
 "Start time": "43789.5170833333",
 "Completion time": "43789.5172106481",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "2f95fd4a-74cd-4fa9-81d7-0f054927eb29",
 "ID": "10",
 "Start time": "43789.5175462963",
 "Completion time": "43789.5175810185",
 "Email": "anonymous",
 "Name": "",
 "Overall": "Yes",
 "Comments": "",
 "Next": ""
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "3e5a48dc-3eb2-4c12-8d32-be8d8ddd55b1",
 "ID": "11",
 "Start time": "43791.5725347222",
 "Completion time": "43791.5726967593",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was good",
 "Comments": "Test",
 "Next": "Test"
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "df38c534-dcd7-4da3-9303-08c9803996b1",
 "ID": "12",
 "Start time": "43791.5892013889",
 "Completion time": "43791.5893287037",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was good",
 "Comments": "egg",
 "Next": "[REDACTED]"
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "29869b9f-0e23-4c13-ad05-39f66d7cc9be",
 "ID": "13",
 "Start time": "43791.5908796296",
 "Completion time": "43791.5910532407",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was good",
 "Comments": "Testymctestface",
 "Next": "[REDACTED]"
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "a41f5e2a-0709-4977-b171-19219c71eafa",
 "ID": "14",
 "Start time": "43791.6028125",
 "Completion time": "43791.6029050926",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was good",
 "Comments": "Test1234",
 "Next": "[REDACTED]"
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "de727a66-8efc-4499-8b37-8665bb781117",
 "ID": "15",
 "Start time": "43791.6281365741",
 "Completion time": "43791.6285069444",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was good",
 "Comments": "Work",
 "Next": "Please"
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "96897e2c-eeba-4fcc-a8e7-2c766d191b6e",
 "ID": "16",
 "Start time": "43791.6294212963",
 "Completion time": "43791.6297106482",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was bad",
 "Comments": "Isnt Real",
 "Next": "Spoon"
 },
 {
 "@odata.etag": "",
 "ItemInternalId": "c77a7714-9c19-4af2-8ac2-666805733f74",
 "ID": "17",
 "Start time": "43791.647037037",
 "Completion time": "43791.6471643519",
 "Email": "anonymous",
 "Name": "",
 "Overall": "It was good",
 "Comments": "TESTING TESTING",
 "Next": "[REDACTED]"
 }
 ]
}

     

  • v-litu-msft Profile Picture
    v-litu-msft on at
    Re: Flow failing at email with most recent data from excel

    Hi @JamieCoop,

     

    Could you please share the output of 

    last(body('List_rows_present_in_a_table')?['value'])

    Please shield the key information.

    According to the error message"Property selection is not supported on values of type 'String'." , it seems like a string value, right?

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans