Answered

Show Only Last item created by the user

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello people,

I have this scenario , i want in a gallery just show the last item based on this filter, should show the last item createn by the user and the status should be = "Finalizada" , i have the filter below created but i dont know how can i do for show just the last item.

SortByColumns(Filter(SolicitudDeViajes; EstadoSolViaje="FINALIZADA"; NombresApellidos.Email = User().Email; StartsWith(Title; TextSearchBox1_1.Text)); "Created"; If(SortDescending1;Ascending;Descending))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
you should be able to just surround your filter with either First() or Last(), depending on your sort order.

First(SortByColumns(Filter(SolicitudDeViajes; EstadoSolViaje="FINALIZADA"; NombresApellidos.Email = User().Email; StartsWith(Title; TextSearchBox1_1.Text)); "Created"; If(SortDescending1;Ascending;Descending)))

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Does the 'NombresApellidos' condition make sure you only show the records of that / created by that user? If so, you could always sort the created in descending order and enclose the code in a First() function to only receive the most recently created record:

First( SortByColumns( Filter( SolicitudDeViajes; EstadoSolViaje="FINALIZADA"; NombresApellidos.Email = User().Email; StartsWith(Title; TextSearchBox1_1.Text) ); "Created"; Descending ) )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks that works but i use Last... thank u

Was this reply helpful? Yes No
adedapo 256 on at

Like (1)

Report
Copy link

Link copied!

You should use First and sort by Created in descending mode. This is because First and Last themselves are not delegable to SharePoint in particular. But Sort and SortByColumns are; so the data source will help you sort across the whole data set and then just return the first item (which because of the sorting, it's the last item).

Was this reply helpful? Yes No