Is there any automation we can do in order to not exceed the 5000 item threshold?
Hello Mick! In the modern UI, the issue usually does not occur. But if it does, you need to reduce the number of displayed items. As an option, you can add a custom yes-no field, for example "IsDisplayed" and set the default value to "Yes". In the view settings, set or add a filtration rule to exclude the items with the "IsDisplayed" equal to "No". In a Power Automate flow, you can update the properties of the items under certain condition and set the field to "No" when required.