Filter ascendente

(1) Share

Report

Posted on by IS-12031616-0

115

Como puedo mandar a llamar de forma ascendente que me muestre los resultados mas recientes en automatico

Filter(Tickets; ID_Usuarios.Value=User().Email)
 
Con esta formula me muestra los resultados pero de mas antiguos
 
~
 
How can I automatically sort the results in ascending order to show the most recent ones?
Filter(Tickets; ID_Usuarios.Value=User().Email)
This formula shows me the oldest results.

Categories:

Building Power Apps

Microsoft Dataverse with Power Apps

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Dear @IS-12031616-0,

Can you please share what you are using as a data source? The exact syntax depend on that.

In general you will need to use a Sort() function:

Sort( Filter(Tickets; ID_Usuarios.Value=User().Email), <CreationDateTimeColumnName>, SortOrder.Descending )

Just insert the name of the colum that has the creation date/time in it and it should work.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
IS-12031616-0 115 on at

Like
a
(1)

Report
Copy link

Link copied!

Uso SharePoint ¿A eso te refieres con la fuente de datos?

Caracteres inesperados. Se usan caracteres en la fórmula de forma inesperada.

Normalmente agrego el dato con el field_2

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@IS-12031616-0,

This seems to be a duplicate of this thread of yours - I have responded over there.

Also @BCBuizer is correct - you just need to add your field name (without the <> brackets).

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @IS-12031616-0,

You can sort your results by the Created column to show the latest records first like this:

Sort(Filter(Tickets; ID_Usuarios.Value = User().Email ); Created; Descending ) // 'Created' – if this column name is different, please replace it with the correct column name you want to use for sorting.

This way, it filters the tickets for the current user and displays the newest ones at the top.
Note: Just replace Created with the column you track for creation date if it’s named differently in your list.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Suggested answer

DP_Prabh 381 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @IS-12031616-0,

To show the most recent results first, you need to combine filter with Sort or SortByColumns in Power Apps.

Sort based on created date

Sort( Filter(Tickets, ID_Usuarios.Value = User().Email), "Created", SortOrder.Descending )

Sorting by ID

Sort( Filter(Tickets, ID_Usuarios.Value = User().Email), "ID", SortOrder.Descending )

And other thing you asked, if you need to replace <CreatedDateTimeCreationName> replace it with your field name from the datasource.

I hope this works for you!

Was this reply helpful? Yes No
Suggested answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IS-12031616-0,

As mentioned, you need to replace <CreationDateTimeColumnName> with the name of the column. If the name of the column is "Fecha", use:

Sort( Filter(Tickets; ID_Usuarios.Value=User().Email), Fecha, SortOrder.Descending )

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Thanks for posting @Kalathiya, @DP_Prabh, we appreciate your desire to help the Community!

I think your reply might be an AI-assisted post, but I do not see any tools or sources cited. Can you update the post to include your sources, or confirm this was not produced using AI?

Please refer to the Use AI responsibly section of Writing effective responses in the community:

Do not

Copy and paste AI-generated answers into the forum without verification. While AI is a valuable tool, it is not always correct, and can provide detailed answers that look correct, but are not.

Conceal the use of AI. If your answer was written in concert with AI, be forthright about it to ensure that others have an opportunity to review or vet your response for accuracy.

Thank you!

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @BCBuizer,

Thanks for your feedback. My response is based completely on my understanding of the issue. I may sometimes use tools to refine wording for clarity, but the explanation itself is my own. I encourage you to review the full post and comments for proper context. I hope this makes sense. thanks!

Was this reply helpful? Yes No