How to get last row values in an excel using flows

[ranred]

Hi I am trying to get the values in the last row of an excel using flow. I have the last row of an excel using

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

 However it returns a JSON value and i am not sure how to extract the values from the JSOn so that i can use that in an email and below is the JSON

{
  "@odata.etag": "",
  "ItemInternalId": "b7ecb7a1-9f8f-409c-8d84-8f972afb94ba",
  "ID": "10",
  "Start time": "43773.7610069444",
  "Completion time": "43773.7612731481",
  "Email": "test.net",
  "Name": "test",

}

 image

[v-alzhan-msft · Accepted solution]

Hi @ranred ,

Which value are you want to get from the JSON?

For example, you could take a try with expression below to get the ID value:

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

Best regards,

Alice       

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