question

sns1 avatar image
0 Votes"
sns1 asked EchoDu-MSFT commented

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

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.

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered EchoDu-MSFT edited

Hi @sns1 ,

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:

Thanks,
Echo Du
================== Updated Answer ================

Hi @sns1 ,

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 104067-6.png, and then select List settings or Library settings.

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

104142-7.png

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

104116-8.png

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.

104163-9.png

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.



6.png (1.1 KiB)
7.png (22.1 KiB)
8.png (16.9 KiB)
9.png (23.4 KiB)
· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sns1 avatar image sns1 ·

Hi Echo Du,

Thank you,

How it is possible to restore the same permissions again for thousands of users?
Do we have any other way to restore it like raising service request with MS, and like using restore-sposite e.t.c?

0 Votes 0 ·
EchoDu-MSFT avatar image EchoDu-MSFT sns1 ·

Hi @sns1 ,

There is no other door opened for you to restore the deleted permission except recreating it unless you have back up.

Thanks,
Echo Du

0 Votes 0 ·
sns1 avatar image
0 Votes"
sns1 answered EchoDu-MSFT commented

Hi Echo Du,

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

· 3
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EchoDu-MSFT avatar image EchoDu-MSFT ·

Hi @sns1 ,

I have updated answer under initial My Answer. Hope this can help you to solve issue. Have a nice day!

0 Votes 0 ·
sns1 avatar image sns1 EchoDu-MSFT ·

Yes. But can you please give some insight on this indexing column concept, how does it fix large list?

0 Votes 0 ·
EchoDu-MSFT avatar image EchoDu-MSFT sns1 ·

Hi @sns1 ,

Indexing columns - before the threshold limit is broken - is the most effective way to mitigate View threshold pain.

A View that's over the threshold will generally only display if it's filtered by an indexed column first in the view, and that filter returns no more than 5000 unique values.

For more information, please refer to the "Living Large with Large Lists and Large Libraries".

Thanks,
Echo Du

1 Vote 1 ·