Skip to main content

Posts

Showing posts from May, 2020

How to create sharepoint list using excel

List is important part of SharePoint. Feature to create list from spreadsheet is very useful. User can create the list using spreadsheet/excel using add list option in site content.

Create a SharePoint List from Excel:
1. Log in to your tenant and move to the site.
2. Now navigate to the Site content and click on the New option and select List.
3. Select the From Excel option and Upload file or you can choose file from site also.

4. File you uploaded, if it's not in the table format, you need to do that.   Click on the link Go to file in this example it is Expense Info.xlsx, present above to the Refresh option. Select the cells and Click on the Format as table. Refresh it.

5. Once you refresh it, Give the name to the list and check the column type, if it's not appropriate you can change this from column type drop down. Now click on Create.

6. Now your list is created.

Note: In this example I used date in one column but when I imported that excel, on SharePoint,  column type is showing …

How to create custom permission in SharePoint Online

In this article we are going to discuss custom permissions in SharePoint and how to create custom permission in SharePoint. We will also explore usage of the custom permission.

SharePoint have some default permission levels. Full control, design, edit, contribute, view, read and view only.




Every permission level defined the accessibility of user on the items. Permission level plays important role in SharePoint security.

In some scenarios you need to assign a permission to user for add and edit the item but you do not want to allow user to delete the item. For such types of scenarios there is no default permission level is available, to fulfill your requirement you need to create custom permission level.


How to create custom permission level in SharePoint:

1 Navigate to Site settings.


 2. Click on Site permissions and you will redirect to the permission page.




3.  Click on the Permission Levels, you will redirect to the permission page. On permission page,   Click on  Add a Permission Level.


4.…