SharePoint Online site permissions restore & issue with ten thousand items & page lay out in site

Question

In one of the SharePoint online site, permissions were broken,
how do we restore it?

Since it is online site we don't have content database backup , Please suggest way to restore the permissions?

and one of the list has 10000 items, what are the steps we need to take to fix this issue?
can we do index column? and how does it indexing column fix it? and how do we achieve this step?

and can we modify SharePoint online site page lay out and how do achieve it? please share some relevant articles on how do we work on SharePoint online page lay out issues?

Please help.

Answer 1

Hi @sns ,

Long time no see, I am glad to be able to help you again.

Per my research, this is not possible in SharePoint online to restore permissions, it's necessary to recreate permissions on your site.

For modify SharePoint site page layout, you could refer to the below link:

• How to change the page layout on a modern SharePoint page

Thanks,
Echo Du

==================
Updated Answer ================

Hi @sns ,

You can add indexes on up to 20 columns on a list or library.

Column types that can be Indexed:

• Single line of text
• Choice (single value)
• Number
• Currency
• Date and Time
• Yes/No
• Lookup (Lookup)
• Person or Group (single value) (Lookup)
• Managed Metadata (Lookup)

Column types that cannot be Indexed:

• Multiple lines of text
• Choice (multi-valued)
• Calculated
• Hyperlink or Picture
• Custom Columns
• Person or Group (multi-valued) (Lookup)
• External data

How to create index column for lists or libraries:

1.For SharePoint in Microsoft 365 or SharePoint 2019, select Settings , and then select List settings or Library settings.

2.Scroll down to the Columns section and select Indexed columns

3.On the Indexed Columns page, select Create a new index.

4.Do the following:

• a.To create a simple index, select a column that is not a Lookup column in the Primary Column section, under Primary column for this index.
• b.To create a compound index, select a lookup column as the primary column for this index. Use a different column that is not a Lookup column in the Secondary Column section, under Secondary column for this index.
• c.Select Create.

Thanks,
Echo Du

=======================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi Echo Du,

okay. How about indexing coloumn for large lists? How does indexing column helps to fix large list items?