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,  colu

How to create custom permission level in SharePoint online

In this article we are going to discuss custom permissions in SharePoint online and "How to create custom permission level in SharePoint online".  We will also explore usage of the custom permission and scenarios where custom permissions are useful. SharePoint have some default permission levels like 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. For an example: 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 S ite settings.  2. Click on  Site permissions  and you will redirect to the permission page. 3. Click on the  Permi