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...
*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.
- OK,
but why can't you just keep only 243 items in the list and update every item if the location changes instead of creating a new item?
Then you can access the history of every item through the version history.- To be fair i have only just learnt about the version history so thats fine, however in my app how do i show this? Currently it shows the history by pulling through the last 3 entries, sorted by ID. I cant see any options to show Version history in a data card or gallery
