Role Of Microsoft Planner App In Office 365

• SharePoint is a collaboration platform, where people communicate with each other by various ways such as OneNote, Outlook, One Drive in addition to planner and many more.

• As we see in SharePoint Online sites, the users are assigned tasks, scheduled reminders, sharing files; it means they are performing plan for team work. Microsoft provides best collaboration platform is planner to help people stay more active.

• In Office 365, planner plays vital role for each user who planes tasks and assign to new user. Office 365 Planner manage planes creation, add task to plan, add people to your tasks, and sort out tasks.

• An admin is responsible to handle and perform the tasks in Planner to add or remove licenses for the individual users or to disable Planner to all the users.

• Microsoft Planner has connection link with Office 365 Groups and these are the things, which you require when you are creating new plan.It also creates a new Office 365 Group. If you are using Office 365 Groups, each group also has a plan like a Notebook calendar etc.

• In short, at the time of new plan creation, it is also creating a new Office 365 Group.Admin or the user who is going to create plan. Make sure to delete plan will also permanently delete Office 365 Group and each thing belongs to group including conversations, groups One Drive location etc.

• Let’s start to create new plan step by step.

Office 365 Sign In

• Let’s go to navigate URL- https://login.microsoftonline.com/ to login Office 365.
• Enter your provided E-mail address and password to login Office 365.
  
  
  
• After successful login, on Office 365, the dashboard will appear successfully with running apps. Kindly select planner.
  
  

On clicking Planner app, it will navigate to the URL https://tasks.office.com/ to sign in Microsoft Planner.

• Click Sign in option now. Type your E-mail address or use phone number to use with Planner and say Next.
  
  
  
• Planner dashboard will display. Let’s start a new plan by choosing New plan.
  
  
  
• Fill out the entries like Name your plan, choose who can see it public or private and add a plan description. Finally, click Create Plan.

Note

• Private - Only members, which you add can see the plan.
• Public- Everyone in your organization can see the plan.
  
  

Great.Your plan is ready.

• Now, you can add task by clicking plus tab (+).Type a task name, set due data of task. Also, add assignment by typing a name or an E-mail address for the assigned members for this task. Select Add task.
  
  

• Once task is added, assigned members will receive mail notification for new plan and user group creation etc.
  
  
  
• Added task can be look out at under my task.
  
  

• In this way, you can create new plans, add new task in it with assigned and the invited members also perform an action on task status. Simply, using Microsoft Planner, you can lookout multiple planning hub under one roof.

Overview Of Office 365 Structure And Add User Account

Left navigation bar

• You can reach most Office 365 apps by clicking App launcher in the left corner of Office 365 navigation bar.

• Click on a tile to go to the particular app. Apps and admin panel will display and accessible only on users access level permissions.

• The image given below shows various running apps like Mail, Calendar, People, SharePoint, Planner and many more.
  
  

Office 365 Admin Center

When you click Admin tile in the App launcher, it will redirect to Office 365Admin center, where you can manage Office 365 tenant.

Right Navigation bar

• Let's see on the right side of the navigation bar in Office 365 page, where there are some icons, which exhibits own activity.
  
  
• Here, you can find an alert notification icon for receiving alerts for your Office 365 tenant and subscription from Microsoft.

• In Office 365 setting, you can manage your site settings like themes, start page, language and time zone, app settings. Meanwhile you can also change your login password.

• Question mark icon indicates help from Office 365 as tell us what you want to do. Also, you can find Community, legal and privacy links resides in it.

• Lastly by clicking my account name, you will get all information about your account and sign out activity. Also, you can add more information about yourself and your account.

Add user

• To create a new user, you need to be an Office 365 administrator.

• Let’s add user into your Office 365 tenant. On Admin center page, under Active users, click plus (+) button to Add a user. Click it and account wizard will be displayed.
  
  

• Fill out all the details and click Create.
  
  

• The user account has been successfully created with a username and password generation.

• User will get login details by an E-mail to the users specific E-mail address.

• Lastly, you can edit or delete the account by active user’s dashboard.

In this way, you will be in the complete phase of Office 365 building blocks. Now, you can set up Office 365 account. Perform the app launcher. Also, set up new user into Office 365 tenant. Great.

The image given below displays Office 365 basic building blocks.

Introduction of Office 365

• Office 365 is a Cloud based Service. It supports both Cloud and Hybrid environments. Many of the aspects in Office 365 have specific ability and functionality as Exchange Online Service uses EXODS to information hold about the public folders like mail.
• Many Applications run consecutively inside Office 365 like SharePoint Online (SPODS), Skype for Business Online, Azure etc.
• You can setup an Office 365 one month free trial subscription.
• Office 365 is a heart of processing engine known as Central Admin (CA), which helps in handling number of workflows tasks respectively.
• Central Admin has the responsibility for the user’s tasks execution and perform an action on the scheduled tasks.
• Office 365 runs wide array of apps insise it including Outlook, SharePoint Online, One Drive, Sway, Yammer, Office 365 video, Newsfeeds,Power Apps and Admin etc.
  
  
  Image: Office 365 apps

Trial setup of Office 365

Microsoft offers several different Office 365 subscriptions plans and pricing.

• Office 365 Enterprise E3 | E5 | E1.
• Office 365 Enterprise K1 | Premium |ProPlus.
  
  
  
  
• Let’s start with Office-365-Enterproise-e3-business plans for free trial.
• Please kindly refer the links given below to navigate to trial version.
  https://products.office.com/en-in/business/office-365-enterprise-e3-business-software
• Refer the image given below. To start Trial, click Free Trial.
  
  
  
• Fill Out the entries step wise. Click Next arrow to setup step 2 -3. Follow the rest of the steps and make the entries respectively. Finally, click Create my account.
  
  
  
• When the account has been created, click You are ready to go. Now, you can start using Office 365 trial.
  
  Note
  You need to subscribe (purchase plans) Office 365 to continue when the emulation period expires.

• These are the steps, which are needed to follow to try trial version of Office 365 site.

Office 365 Sign In

• Sign into Office 365 and lets go to Office 365 login page.
• Navigate this url: https://login.microsoftonline.com/ to login.
• Enter your provided E-mail address and password to login to Office 365.
  
  

• After successfully signing in, Office 365 home dashboard will open and in this way, you can start using your Office 365 trial.

In the next part, we will see Office 365 inside structure and add new user functionality.

Resolving "CEWP Not Visible In Web Part Gallery" Issue In SharePoint Online / Office 365

On a SharePoint Online site, we have created a Team site collection. Since we need to do a small POC and use the Content Editor WebPart (CEWP), we edit the page and click Add WebPart option. I wondered what would happen since there were only few WebParts to be added, as shown below.

Figure 1: No CEWP

Also, there were no search related Web parts and it seems to be missing other categories as well. My first thought was activating the publishing feature. Hence, I went and activated both the publishing features Site level and Web level but found no luck.

Solution- After searching on Google, I found that this issue is related to a new feature in SharePoint Online called Custom Script. This feature enables or disables the scripting capabilities on the site.

Options from UI for enabling and disabling this feature are available on SharePoint admin center site, as shown below.


Figure 2: SharePoint admin site - option to enable or disable the custom scripting

If we do the setting from SharePoint admin center site, this setting is applied to all the site collections available in the tenant but if on some sites, we don’t want this feature, then we can do this setting on site collection level also.

Also, if we do this setting from SharePoint admin center site, it takes around 24 hrs. to take the effect.

To have an immediate effect, we need to apply the setting at site collection level. At site collection level, we can apply setting, using PowerShell command.

Set-SPOsite is a PowerShell command, which we need to use to set the setting.

Steps to enable the Custom Script feature at site collection level, using PowerShell command:

1. Open the “SharePoint Online Management Shell” and run it as an administrator.
2. Connect to Office 365, using PowerShell command “Connect-SPOService” as

Connect-SPOService -Url https://prasham1-admin.sharepoint.com <SharePoint admin center URL>

This command will prompt for the credentials, as given below.


Figure 3: SharePoint Online Management Shell - Credential prompt for connecting to Office 365

3. Once the credentials are entered, we are ready to run our next command Set-SPOsite as

Set-SPOSite <Site Collection URL for which we need to change the setting> -DenyAddAndCustomizePages 0 (“DenyAddAndCustomizePages” set to Zero means enabling the custom scripting on the given site collection.)

Thus, we used given PowerShell command. We applied the setting for our site collection. We refreshed the page and again tried to add CEWP and we can see the CEWP as well other WebParts also, as given below.


Figure 4: Adding CEWP on page after enabling custom script feature at our site collection level

Not only CEWP but other WebParts like Script Editor, Silverlight Web Part in category “Media and Content” are also visible. WebParts from other categories like Business Data, Content Rollup and Search are also visible.

There are more other features also, which are affected because of Custom Scripts feature. Kindly refer https://support.office.com/en-us/article/Turn-scripting-capabilities-on-or-off-1f2c515f-5d7e-448a-9fd7-835da935584f?ui=en-US&rs=en-US&ad=US , in this article its very detailed explained all the features which are affected.

Making Rest API Call Using AngularJS From Office 365 SharePoint Hosted App To Host Web/Parent Web Application

The name "apps for SharePoint" is changing to "SharePoint Add-ins"

• Get URL’s

HostWebURL and AppWebURL, which can be obtained from the query string, once the add-ins are deployed.

JavaScript code given below is used to get the value from the URL.

1. var hostweburl = decodeURIComponent(getQueryStringParameter('SPHostUrl'));  
2. var appweburl = decodeURIComponent(getQueryStringParameter('SPAppWebUrl'));  
3.   
4. function getQueryStringParameter(urlParameterKey) {  
5.     var params = document.URL.split('?')[1].split('&');  
6.     var strParams = '';  
7.     for (var i = 0; i < params.length; i = i + 1) {  
8.         var singleParam = params[i].split('=');  
9.         if (singleParam[0] == urlParameterKey) return decodeURIComponent(singleParam[1]);  
10.     }  
11. }   

• Load SP.Requestor.js file and execute the function, once the file is loaded and execute CrossDomainRequest.

When we create new SharePoint add-in initially, we will get an error while making AJAX call, using jQuery or $http call, using AngularJS.

403 -Access is denied error.

CROS request error.

Using JavaScript Object model and whole CRUD operation will be possible but using jQuery or AngularJS , consuming list REST API will be useful. In order to do it, we use SP.Requestor.js file, which enables us to make CROS call to SharePoint Office 365 sites.

When we use the cross-domain library, the Webpages in your add-in/app can access the data in add-in domain and the SharePoint domain. The developer site, which is used to develop an app and host SharePoint site, once the add-in is published in an app catalogue.

The cross-domain library is a client-side alternative in the form of a JavaScript file (SP.RequestExecutor.js), which is hosted in SharePoint Website, which can be referenced in add-in. The cross-domain library lets us interact with more than one domain in remote add-in page through a proxy. 

1. var scriptbase = hostweburl + "/_layouts/15/";  
2. $.getScript(scriptbase + "SP.RequestExecutor.js", execCrossDomainRequest);  
3.   
4. function execCrossDomainRequest() {  
5.     var executor = new SP.RequestExecutor(appweburl);  
6.     console.log('url' + appweburl + "/_api/SP.AppContextSite(@target)/web/lists/getbytitle(" + "'" + listName + "'" + ")/Items?@target='" + hostweburl + "'");  
7.     executor.executeAsync({  
8.         url: appweburl + "/_api/SP.AppContextSite(@target)/web/lists/getbytitle(" + "'" + listName + "'" + ")/Items?@target='" + hostweburl + "'",  
9.         method: "GET",  
10.         headers: {  
11.             "Accept": "application/json; odata=verbose"  
12.         },  
13.         success: successHandlerNew,  
14.         error: function errorHandlerNew(error) {  
15.             console.log('List not found' + error.statusText);  
16.         }  
17.     });  
18. }  
19.   
20. function successHandlerNew(data) {  
21.     var jsonObject = JSON.parse(data.body);  
22.     var results = jsonObject.d.results;  
23. }  

How To Add Menu Action On Your Office 365 SharePoint Sites

we will see how to add a menu option in Office 365 SharePoint site. We can add the menu option on the top right corner of the Settings page or as a navigation on the site’s  Setting link.

Let’s see how we can add the menu action using script.

• Open your site
• Go to Edit Page by clicking on the Settings gear in the top-right corner
  
  

• Click on Check Out
  
  
• You will see the Edit page of the site
• Click on “INSERT” under Media and Content and add "Script Editor".
  
  
  
• Open the Script Editor and paste the code given below. 
• 
  
• Code Snippet
  
  1. <script language="javascript" type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>  
  2. <script language="javascript" type="text/javascript">  
  3.     $(document).ready(function() {  
  4.         SP.SOD.executeFunc('sp.js', 'SP.ClientContext', AddSettingsMenuAction);  
  5.     });  
  6.   
  7.     function AddSettingsMenuAction() {  
  8.         //Read the web  
  9.         var clientContext = new SP.ClientContext();  
  10.         var oWeb = clientContext.get_web();  
  11.         //Add the new custom action  
  12.         var collMenuAction = oWeb.get_userCustomActions();  
  13.         var menuAction = collMenuAction.add();  
  14.         menuAction.set_location('Microsoft.SharePoint.StandardMenu');  
  15.         menuAction.set_sequence(101);  
  16.         menuAction.set_group('SiteActions');  
  17.         menuAction.set_title("My Home");  
  18.         menuAction.set_url("https://sharepointworldbymanpreet.wordpress.com/");  
  19.         menuAction.update();  
  20.         //Load the group details and execute  
  21.         clientContext.load(collMenuAction);  
  22.         clientContext.executeQueryAsync(ScriptSuccess, ScriptFailure);  
  23.     }  
  24.     //Log Success Details  
  25.     function ScriptSuccess() {  
  26.         console.log("Menu Added");  
  27.     }  
  28.     //Log Failure Details  
  29.     function ScriptFailure() {  
  30.         console.log(args.get_message());  
  31.     }  
  32. </script>  

• Click on OK.
  
  

• You will see a “My Home” menu button attached to your menu option.

Using this script, you can add the menu items of your choice for all the users who will access the SharePoint sites.