Expression to grab latest comment from discussion board

[bman22]

Hello, I'm still trying to grab the latest comment from my discussion board that I've created on AppSheet and thought I got it, but guess I didn't. I tried the following expression: INDEX(SORT(SELECT(commentsSection[Employee],([_THISROW]=[Comment Corner ID])),TRUE),1. However it doesn't work correctly and doesn't grab the most recent Employee. In the commensSection table I also have a Date and a Date/Time column, but don't know how 2 use them in the expression to get the latest entry. Comment Corner ID is the ID to link to the commentsSection table to the Comment Corner table. 

[bman22]

No worries I figured it out using another question on this board, man that's a bit more complicated than I thought that u needed 2 do, but such is the beauty of learning AppSheet

[Marc_Dillon]

LOOKUP( MAXROW() )

https://help.appsheet.com/en/articles/2357309-lookup

https://help.appsheet.com/en/articles/2357310-maxrow