Monday, August 7, 2017

Sri Lanka SharePoint Forum monthly gathering – August

Come join us on 9th, August 2017 for Sri Lanka SharePoint Forum monthly gathering.

I will be speaking on "Build SharePoint Online Workflows and Customize Forms Using Nintex for Office 365"

Event Url: https://www.facebook.com/events/1531294496931216/?ref=46

20663701_10155529431892482_5738861410474645855_n

Updated On: 09th of August 2017

Slides which used for the event.


Some clicks during the event

Suhail Jamaldeen (1)Suhail Jamaldeen (2)Suhail Jamaldeen (3)Suhail Jamaldeen (4)

Friday, August 4, 2017

SharePoint Modern Page Quick links web part missing Layout option?

Introduction

Some of the Microsoft documented features, which are related Office 365 to are not available for some tenants. I noticed that from SharePoint Online modern experiences – some of the features were missing. Here is the conversation I started.

It’s because my tenant is not configured to First Release

First release candidates receives the Office 365 updates immediately.

Problem

According to support.office.com, Quick links web part in SharePoint Modern Pages should show a "layout" option where we can select either Compact or Film Strip. But my development site and client's site doesn't show such options. Any idea?

My developer site is given below.

Capture.JPG

Solution

I added my tenant to “First release for selected users” in Office 365 Admin Center.

Step 01. Go to Admin Center from the Quick Launch

Step 02. Select “Organization profile” under Setting.

imageStep 03. Under Release preferences, select Edit under Actions dropdown

image

Step 04. Selection the option “First release for selected users” and click Next

image

Step 05. Click Yesimage

Step 06. Then you have to add people. I have added people who are managing sites, because they are the people who are going to customize the sites.  

And then Hit Save

image


Conclusion

Once I did the above configuration, I was able to see the First Release features in my Office 365 Tenant. It may take some time.

image


Wednesday, August 2, 2017

How to request for a code review in Visual Studio - Tamil

This is my first YouTube session related to Technology.

I would greatly appreciate it if you kindly give me some feedback and your feedback will definitely help me a lot in future.


Remove the Header area from the Modern SharePoint pages

Introduction

Recently one of clients wants to remove the header area from their SharePoint modern page which consume lot of space.

Till date SharePoint Online doesn’t provide such feature to remove the header.

image

Solution

Step 01. Open the particular page in SharePoint Designer and edit using Advanced Editor 

Step 02. Change Page Layout Type from Article to Home. For that search for <mso:PageLayoutType and change the value as given below.

<mso:PageLayoutType msdt:dt="string">Home</mso:PageLayoutType>

Conclusion

Now the header is gone.

image

Access Denied

If you get “Access Denied” error, follow this link and get resolved.


Saturday, July 22, 2017

Develop SharePoint Framework projects in Visual Studio 2015/2017

Introduction

You will come across so many tutorials on SharePoint Framework (SPFx) which were illustrated using “Visual Studio Code”. But don’t worry you can develop SPFx projects using Visual Studio.

Recently “SPFx Project Template for Visual Studio” was released in GitHub. In this post we are going to see how to install “SPFX Template” and create a new SPFx project after installing the extension.

As of today the extension supports Visual Studio 2015 and Visual Studio 2017.

Steps

Step 01

Go to GitHub Releases page and download the latest .vsix file. Reason for downloading from GitHub is that you may not find the latest in Visual Studio Extension Gallery.

image

Step 02

Double click on the download template and install.

Select the Products and click install.

image


Step 03

Open Visual Studio and add New Project (File –> New –> Project)

Under Templates you will see “SharePoint Framework”. Select it and click OK

image

Step 04

Then you have to Select a framework which you are going to use; Give Component Name and Component Description.

Also you can select the check box if you don’t want to install Dependencies. Usually installing dependencies make our life easier, So keep it as it is.

Click on Generate.

image

Conclusion

It took me around 15 minutes to create a new project. So keep calm when you are trying to create a new project.

Your solution will be looking as below and you can start working on the solution.


image


Run the project by clicking “Start” and your first Workbench project will be opened in the browser.

image

By clicking on + You can add SPFx webpart. 

Tuesday, July 18, 2017

Content Search in the Office 365 Security & Compliance Center

Introduction

Content Search in the Office 365 Security & Compliance Center let us to search for emails, documents, Skype for business conversation, Microsoft Teams data and threads, Office 365 groups, SharePoint Online items and more.

Navigate

Go to https://protection.office.com and Select “Content Search” under “Search and investigation”

image


Real world examples

I would like to address some real world example where we can use Content Search and if you come across few more please comment; so that all will know.

  • Get all documents with one or more particular word in documents which are stored in SharePoint Online or OneDrive
  • You notice that data belongs to a particular department is shared with another. So you have to search for all the user’s emails, chat history and other Office 365 services.
  • What confidential information are shared in public folders. You can search by one or more term.
  • Get Search statistics for audit purposes.
  • Want to exports keyword statistics to a local location.
  • Are people discussion on a particular topic in Microsoft Teams.
  • Check whether a client contacted your business team through Skype for Business.

and many more.

New Search

You can click on +, give a name for the search, provide search location.

Also you can give some conditions.

image


Search Results

You can see the Search results from the below image.

image

You can click on Preview search results and navigate to detailed preview and also from there you can navigate to original url and see the original item.

image

Reference

Wednesday, July 12, 2017

Going to delete a Microsoft Teams channel and recreate it – Read this...

Problem Background

I deleted a channel in Microsoft Teams and when I try to recreate the channel there was a error message saying “Another channel already has that name. Try a different one.”

image


So, till date (12th of July 2017) Microsoft Teams don’t allow to create a channel with the same name which was already deleted.

See this thread for more.

Alternative

Let’s say you have to delete a channel and recreate with the same name. What you can do it simply rename the channel and delete it.

Once you delete with the new name you can create with the old name but not the new.

Future

We all hope that Microsoft will provide us a solution to overcome this issue and in future we can use PowerShell to do a hard delete.




Tuesday, July 11, 2017

Start a thread in Microsoft Teams channel via Email

Introduction

You can start a thread in a Microsoft Teams channel by directly sending an email to a Microsoft Team channel, so that the channel members can see, like save and reply to the thread.

Also you can share the channel email address with the third party, so that they can email to the channel using their own email address like gmail, yahoo and others.


Steps

Step 01

Login to https://teams.microsoft.com and go to Team and click on three dots “…” of your channel.

Step 02

Then click on Get email address.

image


Step 03

Once you click you will get a popup with channel email address. Copy the email address and you can start a thread directly by sending email.

image

Conclusion

You can see my two threads started via email. The first one is by using Office 365 email and the second one by my personal Hotmail.

image

Limitation

By today the reply to a thread started via a email can only be seen in Microsoft Teams.

image


Monday, July 10, 2017

How to enable sideloading of apps for Microsoft teams

Introduction

I started building apps for Microsoft teams. Before we start developing we need to enable side loading as a prerequisite.

Solution

Step 01.

Login to your Office 365 portal with admin account

Step 02

Click on Service & add-ins under setting tab

image

Step 03

All your services and add-ins will be shown. Click on Microsoft Teams

image


Step 04

Under Apps  change the state of Allow external apps in Microsoft Teams and Allow sideloading of external apps to on as give below.

image


Thursday, June 29, 2017

Query List and read all items in Nintex Workflow for Office 365

Introduction

Query List in Nintex Workflow for Office 365 used to get list items. You can select all list items or select items when a condition is true.

Here I’m going to illustrate how to select all the items and log into workflow history list.

I have a list and it has three columns. 1. Title 2. Body 3.Subject.

Solution

Step 01

Add “Query List” action into workflow from the left menu and select the list. Select  the Editor Mode; in my case I have selected “Query Builder” and  have checked “Select all list items” radio button.

image

Then under “Columns to select” category select the columns you have to use. Your output should be “Collection type”.

image

image


Step 02

Now you have to add “For Each” action. There you have to select the Collection which we defined in Step 01.

You have to define a workflow variable as Text and select in “Output value”; also you have to select Output Index and it should be an integer.

image

image

Step 3

Then add “Get Item From Collection” action and select “Target Collection”. You can select the collection which we created in the above step.

Select the index and also select the “Output”. Refer the screen.

image

Step 4

Then log the data you want to see.

image

You can see the History log by item by item.

image

Conclusion

I have shared the Nintex workflow file. You can import and have a look.

https://drive.google.com/file/d/0ByEnOE8DAdvhY3F6VEF0SWlRcXc/view?usp=sharing



Tuesday, June 20, 2017

Disable/Hide controls if current logged in user is not a member in SharePoint Group – Nintex Forms for Office 365

Introduction

We had a business requirement where we have to hide some controls, if the current logged in user is not a member of a particular SharePoint group. We were developing the forms using Nintex Forms for Office 365.

Solution

You can use Rules to achieve the requirement.

Step 01

Select the controls which you have to hide and add a Rule.

Step 02

Define the Rule Type as “Formatting”

Step 03

Use this formula

not(fn-IsMemberOfGroup('Your SharePoint Group Name'))

Add your SharePoint group name within brackets. (In my case AERAdmins is the SharePoint group Name)

image

Step 04

Select Disable and Hide from formatting.

Preview

image


Conclusion

You can see the entire form from the below screen shot.

image


You can download the form, you can import and have a look.

https://drive.google.com/file/d/0ByEnOE8DAdvhV1V6WDZOb2w0SFk/view?usp=sharing

Wednesday, May 10, 2017

How to customize Task Forms in Nintex Workflow for Office 365

Introduction

We use workflow tasks and task list in order to “Approve” or “Reject” a workflow.

Same as any SharePoint workflow, in Nintex Workflow for Office 365 we can assign tasks and get outcome of the task. In this post we are going to see how to customize Task form.

Steps

Step 01: Go to configuration page by clicking on “Configure”

image

Step 02: Click on “Edit Task Form” from the Ribbon

image

Conclusion

You can edit the form by using the controls. Once you completed editing, “Save” the form.

When a user click on a task, it will redirect to the Nintex Form which we edited and created.

image

When you edit Task Form, “Comments” field will be added to Task List.

You have to have Nintex Forms for Office 365 installed, else “Edit Task Form” will be disabled as below.

image


Monday, April 17, 2017

“List 'User Information List' does not exist at site with URL” exception for users with member permission

Introduction

I was using SharePoint rest api in order to retrieve all the departments through user information list.

Problem

I was using

_spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('User Information List')/Items?$select=Department";

for the rest query. When I logged in as a site collection administrator, I got expected results.

But when I logged in as a site member I got the below exception.

List 'User Information List' does not exist at site with URL '<site url>'. 

List 'User Information List' does not exist at site with URL

Solution

Instead of using the above I used the below url and I got the expected results for users with the member permission as well.

_spPageContextInfo.webAbsoluteUrl + "_api/web/SiteUserInfoList/items?select=Department"

Wednesday, April 12, 2017

Convert SharePoint Online based SharePoint Hosted Add-in to SharePoint 2013 On premises based one

Introduction

We used SharePoint Online based template in Visual Studio 2015 in order to develop SharePoint hosted add-in.

Problem

Our client’s requirement is to deploy it in the SharePoint 2013 On premise. So we had to convert the solution.

Solution

Step 01:

  • Right click on AppManifest.xml and click on View Code.
  • Then change the SharePointMinVersion to 15.0.0.0

image

Step 02:

  • Double click on on Package.package under Package folder.
  • There you will find SharePoint Product Version. Change it to 15.0.

image

 

Conclusion

Now you can publish the solution and deploy to SharePoint 2013 On premise.