Skip to main content

Posts

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 …
Recent posts

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.…

How to add facebook feed to sharepoint online

In this article we are going to get answer for the question "How to add Facebook feed to SharePoint page" or "How to embed Facebook feed on SharePoint page". We can easily embed the Facebook feeds using the embed web part.  
You can embed Facebook public feeds on your site by following this steps:
 First, we need to get embed coed from Facebook page plugin. Now paste the Facebook page URL and and set the height - width.

   3.  Now click on the get code. Select IFrame and copy the code.  4.  Once you get the code, Login on your SharePoint site where you want to add the code and add embed web part.

5.  After adding the web part, paste the embed code and republish the page. If you get error, move to point 6.
6.  Error "Embedding content from this website isn't allowed, but your admin can change this setting. They will need to add 'www.facebook.com' to the list of sites that are allowed." is stating that feed from website facebook is not allowed. To res…

SharePoint URLs to navigate quickly

At some point you want to navigate to other page on SharePoint but you forgot the navigation path, at that time these URLs are very helpful. You can navigate to particular page using these URLs without navigating through site. Change the tenant name and appropriate site URL and paste the it into address bar. These are some useful url's for SharePoint
You can navigate in SharePoint without using site navigation butfor this you must have required permission otherwise you will get “Access denied”.
Some useful URL's for SharePoint Users.
1. URL For SharePoint Admin Center (For this SharePoint Admin Access is required):
To access the More feature page under the SharePoint Admin Center, use the URL mentioned below. You can access the User Profile, Search, Term and SharePoint classic features also.
https://Yourtenant -admin.sharepoint.com/_layouts/online/AdminHome.aspx#/classicFeatures
2. URL To access the SharePoint admin center :
https://YourtenantName -admin.sharepoint.com/_layouts/on…

Add and edit user profile properties in SharePoint

You can manage the user profiles from the Office 365 admin center. if you want to create new user profile properties you can do it from user profile properties. you can update the user profile properties by accessing user profiles from the SharePoint admin center.(Admin level permission required to perform this)

1. Open Microsoft 365 admin center and navigate to SharePoint admin center. 

2. On SharePoint admin center , Click on More features



3. Now click on the open, under the User profiles section.
4. Now you are at manage profile page, Click on Manage User Properties
5. Click on New Property and it will redirect you to another page.
6.   In the Property Settings  section, In the Name box, type the name of property, this name is used        by services, In the Display Name box, type the name, this name will be displayed at user profiles to all users.
In the User Description section, In the Description box, type the description for property, this description will appear on the edit p…

How to register an app in SharePoint

In this article, we are going to learn how to register an app/add-in in SharePoint online. If you have created a Sharepoint provider-hosted add-in or other SharePoint solution and to access the SharePoint site or list using the app/add-in you need to register the add-in on SharePoint and to grant permission.

Register app in SharePoint

1. Login into SharePoint and Navigate to register an app page. Use the URL mentioned below: 

[Sitecollection URL]/_layouts/15/appregnew.aspx

2.  Once you navigate to the Register app page, a form will open.

You need to fill all the fields on the form. Client Id and Client Secret generated when we click on the generate button available next to the fields.  Title: Name of the add-in which you want to give. App Domain: Where your domain is hosted, for the local environment you can place             "www.localhost.com". Do not include HTTP or HTTPS in App Domain. Redirect URL:  Insert the redirect URL, for the local environment put https://localhost.c…

How to check user permissions for site using CSOM in SharePoint Online

In this article, we are going to learn, How to get the user permission on the site using csom or how to get the user permission programmatically, to get the permission of the user on a particular site we use GetUserEffectivePermissions() method in csom. In the SharePoint, user requires permission to perform any operation, when we work with provider-hosted add-ins and in some scenarios, we need to check the permission of user we use the GetUserEffectivePermissions() method and by passing the user name we get its effective permission on the site. 
In this example, We have created a console application to check whether the user have edit person or not on site. 
Pass the context of the site and email of the user into a method to check the permission of the user on the site. You must ensure users on the web before checking permission. 

using System;  
using System.Security;  
 using Microsoft.SharePoint.Client;  
 namespace PracticeCsom  
 {  
class Program   {   static void Main(string[] args)   {   …