web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sort and Filter combin...

Power Apps

Unanswered

Sort and Filter combination not working fine

(0) Share

Report

Report

Posted on by Iantaylor2050

603

I have a powerapps with SharePoint as the backend. Below is my SharePoint list

In my item details page, I have a label named Highest Price where i need to show the highest amount filtered by ID. i.e.

For 1001, the label should show $1000 as this is the highest amount when filtered by ID. I tried using below code, but it doesnt work.

For 1002 item details details page, it should show $2000

Label Text property contains below code

SortByColumns(Filter(DataSource, ID=globvar.ID),Amount,SortOrder.Descending)

Any idea where i am going wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Iantaylor2050

SortByColumns returns a table. If you want to want to display the Amount that corresponds to the first record in the result, the formula would look like this:

First( SortByColumns(Filter(DataSource, ID=globvar.ID), Amount, SortOrder.Descending ) ).Amount

Was this reply helpful? Yes No

Join the conversation