Unique values shown as a list

(0) Share

Report

Posted on by Markswan20

121

I have a staff log where each staff member updates regularly.

I'm trying to create a way of seeing how long it has been since each person updated it.

I need a list which shows the unique value based on the staff member which is filtered to show the most recent entry.

It can't be in a drop down but all visible at the same time.

The staff field is the standard created by from sharepoint and the date is saved as RecordDate.

Thanks in advance

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Markswan20 - as I understand it, I think you're trying to create a table of unique values amongst duplicates by the most recent date. Another way to phrase it is that you want to display the latest records in a Gallery amongst duplicates.

If that is correct, you can try applying the below expression in the Items property of a Gallery:

ForAll( GroupBy( 'Your Data', "The field which contains duplicates", "_items" ), First( Sort( _items, Modified, SortOrder.Descending ) ) )

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan
Markswan20 121 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Amik
Markswan20 121 on at

Like
a
(0)

Report
Copy link

Link copied!

I've hit a snag, i want the filter to utilise the default field ThisItem.'Created By'.DisplayName
I have imported this into the galley but the coding kicks up error.

This is the current code

ForAll(GroupBy(Command,"'Created By'.DisplayName","_items"),First(Sort(_items, RecordDate, SortOrder.Descending)))
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Markswan20 ,

GroupBy is not supported on complex field types. Use AddColumns to store the complex field attribute (in this case, the Display Name) as a new "virtual" column.

ForAll( GroupBy( AddColumns( Command, "CreatedDisplayName", 'Created By'.DisplayName ), "CreatedDisplayName", "_items" ), First( Sort( _items, RecordDate, SortOrder.Descending ) ) )

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan