Most Recent Record per ID

[Jseo]

I have a SQL server database with data in the format below:

Date	UserID	Status
5/9/2019	1	active
8/5/2020	1	terminated
7/8/2017	2	active
5/6/2019	2	vacation
9/5/2021	2	terminated
10/5/2018	3	active
8/15/2019	3	vacation
4/8/2020	3	terminated
9/5/2021	3	active

I would like to import into my app only the most recent records.

Date	ID	Status
8/5/2020	1	terminated
9/5/2021	2	terminated
9/5/2021	3	active

I was able to do this by creating a View in SQL, but Power Apps does not allow you to edit the data or add another line to the original database. Can someone please help?

[Jseo]

Hi @RandyHayes ,

Sorry for bothering you again, but my need has changed a bit on the query you sent before.

Now I am trying to filter the data first to have "Max(Date_ENG)" per Ticker then filter down. Is that possible?

Thanks again.

SortByColumns(
Search(
ForAll(
GroupBy(Filter(Ideas_1, Date_ENG> DateAdd(Today(),-6, Months),QB = "HO",Location = "QB"),
"Ticker", "_records"
),
With({_top: First(Sort(_records, Date_ENG, Descending))},
{Ticker: Ticker,
Date_ENG: _top.Date_ENG,
Analyst: _top.Analyst,
Location: _top.Location,
QB: _top.QB,
L_S:_top.L_S,
MyID:_top.MyID,
Comment: _top.Comment
}
)
),
TextSearchBox1_1.Text,"Analyst","Ticker"),
"Analyst",Descending,"L_S",Ascending,"Ticker",Ascending,"Date_ENG",Descending)