Filter to last excel row and paste two columns from that filter to the body of a meeting email

[mjubin]

Hey there!

Is it possible to filter a live sheet excel in in automate and paste two columns from that filter to the body of a meeting request email?

I have up to "filter array" from "list rows in present table" but the filter options for the array do not give me a option to filter by "highest" in the ID column.

ID (the column I am filtering by) is not a value present to filtered within the "list rows in present table" (see below).

[wskinnermctc]

In the step "List rows present in a table" go into the Order By and put ID desc, and then in the Top Count put 1.

Youtube - Orderby and Top Count 

Also in the settings of the step turn on Pagination so that it will go through the whole list.

EDIT NOTE: Sorry I initially said put Top Count as 2 because I thought you said you wanted the last 2 rows. Instead you should put 1 since you only wanted the highest number.

See if that works for you.

[mjubin]

@wskinnermctc 

Unfortunately that ID column that I want to filter by in does not have a filter to grab by. When typing it in as a string value the run fails to grab:

[wskinnermctc · Accepted solution]

I just made an example flow that will help you get the single last row of an excel table based on a column named ID.

Below is my example excel table:

Example Excel Sheet

Below is my example flow with the settings of the List Rows pagination turned on.

Example Flow

Here are the results of my flow that will get the last row of an excel table.

Flow Results with Single Get Item

Can you use this example and see if it works for you. You will not need a Filter Array step if you use the Get Row.