web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ForAll and Multil leve...

Power Apps

Answered

ForAll and Multil level Sort for unique items

(0) Share

Report

Report

Posted on by Markswan20

121

Hi i'm using the following code to get the unique records for all uses with their GRS number in date order wit the newest log entry to show.

ForAll(GroupBy(Command,"GRS","_items"),First(Sort(_items, 'Log Date',SortOrder.Descending)))

The problem is that it doesn't sort it by the most recent but the last entered.

How can i change this code slightly so that it will further sort it by the 'Log Date'.Descending?

Cheers

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Markswan20, 😊

Currently you are grouping the datasource and only sorting the grouped sub-table. Do you want the full list to adhere to the Log Date sorting order? In this case, you will have to sort the datasource first and only then apply the GroupBy function:

ForAll( GroupBy( Sort( Command, 'Log Date', SortOrder.Descending ), "GRS", "_items" ), First(_items) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Markswan20 121 on at

Like (1)

Report
Copy link

Link copied!

Spot on thank you 🙂

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!

Perfect, glad I was able to help! 😊

Was this reply helpful? Yes No

Join the conversation