Hi all,

I have a list that was created a few months ago, it now have around 25,000 items in it.

While doing a report yesterday, I realized that one of the column is set as Date only instead of Date-Time like other columns.

Even when created, it use Date-Time variable from power automate.

But because there is more than 5,000 items, that is prohibited, because it would put too much work load on the server.

The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

How can I fix my table ?

Thank you

​Hi all,I have a list that was created a few months ago, it now have around 25,000 items in it.While doing a report yesterday, I realized that one of the column is set as Date only instead of Date-Time like other columns.Even when created, it use Date-Time variable from power automate. But because there is more than 5,000 items, that is prohibited, because it would put too much work load on the server. The number of items in this list exceeds the list view threshold, which is 5000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited. How can I fix my table ? Thank you  Read More

​