Forum Discussion
Limit and Archive off more than 3 Entries per Unique ID
I have a sharepoint list that is tracking locations as we scan objects. I have a history tab and to ensure thte tablet doesnt slow to a crawl or crash I'd like to limit the entries per unique ID to 3 per and send the rest to archive list i have set up.
For examplete: Item 1 is scanned 5 times but i only want the most recent 3 scans to show and the archive list to show 2 entries.
- *Bump* Is there no one that knows how to limit Sharepoint entries?
You could create a PowerAutomate flow that does the following:
- If a new Item for a UniqueID is created,
- Get all other Items for that ID
- If there are more than three
- Get the oldest one of these Items
- Move that item to another list
But the requirements seem wierd to me, what exactly are you trying to accomplish with that setup?
Couldn't you just enable versioning on the list and then just update the same item with the unique ID every time you scan a new item?
Or group the list view by the unique ID?- I have a list of 243 unique Items. Each one of these is assigned a location, when it is scanned again it records the new location, but keeps a history of the last location. With 243 items each being scanned multple times a week my list will exceed the limit. Not to mention the issue with the app trying to pull through a large data set. If i could limit it to 3 entries per ID it will prevent the aforementioned issues. I know i can limit the app pulling through too much data, so just need my sharepoint list from exceeding the entry limit.
