ForAll and multiple Sort values

(0) Share

Report

Posted on by Markswan20

121

I am using the following code to get the newest distinct value based on Unique GRS

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

What i need to add is another Sort function that will show the oldest record 1st based on the unique values.

Any ideas welcome please

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Markswan20 ,

Please try this:

ForAll( Distinct( LogDataALL, GRS ) As C, Last( Sort(Filter( LogDataALL,GRS=C.Value), 'Log Date', SortOrder.Descending ) ) )

Best regards,
Rimmon

Was this reply helpful? Yes No
Markswan20 121 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response Rimmon, this gives the same results as my code.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I didn't notice that.
I have just modified my formula, or you can replace First with Last in your formula.

Was this reply helpful? Yes No
Markswan20 121 on at

Like
a
(0)

Report
Copy link

Link copied!

That's ok, by replacing First to Last it give me the oldest unique value instead of the newest.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Markswan20 ,

Do you want newest and oldest at the same time?
Please try this:
Ungroup(ForAll( Distinct( LogDataALL, GRS ) As C, Table(Last( Sort(Filter( LogDataALL,GRS=C.Value), 'Log Date', SortOrder.Descending ) ), First( Sort(Filter( LogDataALL,GRS=C.Value), 'Log Date', SortOrder.Descending ))) ),"Value")

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Markswan20 ,

How is the situation now?

Was this reply helpful? Yes No
Markswan20 121 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the suggestion, this seems to have now lost the Unique validation from the GRS field and now hides many of the fields that are powered by the drop down.

I use this in my visible field
HubSelection_1.Selected.Value in ThisItem.ManagerLevel

Was this reply helpful? Yes No