1

Need some help figuring out how to go about this!

I have a list, people will add items to it, sometimes with the same title (which is correct).

We then group these items by the column 'title' on the list.

We want people to create new items, rather than editing the old one, so we have a log of the new additions.

For example: The list would have 4 items, 3 with the title 'dog' and 1 with the title 'cat'

We would then group the items with the title dog, and group with the title cat.

However, I also want to have a view where we only see the last added item for each title - so we would only see the latest 'dog' item, and the latest 'cat' item.

I couldn't filter by time/date, because some groups may not have had items added to in a while.

Is there a solution to this?

Any help would be greatly appreciated!

1

To View only latest added items if item already exists (same name), you can modify view, Group by Title:

enter image description here

Then sort by ID in descending order:

enter image description here

Then in item limit section, set Number of items to display to 1, and choose "Limit the total number of items returned to the specified amount", click ok to save the view:

enter image description here

  • This is perfect thank you! Much appreciated! – B43n Nov 29 '19 at 10:53
0

Your question is a little bit confusing if we see it from logic side, but did you try using the versioning feature !

check this : https://support.office.com/en-us/article/enable-and-configure-versioning-for-a-list-or-library-1555d642-23ee-446a-990a-bcab618c7a37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.