Tag Archive: SharePoint Online

If you have company requirements to set some individual user passwords to never expire, you need to use Windows PowerShell. You can’t do this in the Office 365 admin center or interface, but you can do it o Windows PowerShell Microsoft Online Service

Below steps are required once on your computer, not every time you connect. However, you’ll likely need to install newer versions of the software periodically.

Step 1: Install Microsoft Online Services Sign-In Assistant

  1. Install the 64-bit version of the Microsoft Online Services Sign-in Assistant: Microsoft Online Services Sign-in Assistant for IT Professionals RTW.
  2. Install the Microsoft Azure Active Directory Module for Windows PowerShell with these steps:
    • Open an elevated Windows PowerShell command prompt (run Windows PowerShell as an administrator).
    • Run the Install-Module AzureADPreview command.
    • If prompted to install the NuGet provider, type Y and press ENTER.
    • If prompted to install the module from PSGallery, type Y and press ENTER.
Install-Module AzureADPreview

Install-Module AzureADPreview

Step 2: Connect to Azure AD for your Office 365

  1. If you haven’t already, open a Windows PowerShell window on your computer (it doesn’t matter if it’s a normal Windows PowerShell window, or one you opened by selecting Run as administrator).
  2. Run the following command:

    Sign in to connect Microsoft Service Online

    Sign in to connect Microsoft Service Online

  3. In the Sign in to your account page that opens, sign in with your Office 365 admin account
  4. Run the following command to set the password of one user to never expire:
    Set-MsolUser -UserPrincipalName <email_account> -PasswordNeverExpires $true

When you’re successful, the PowerShell prompt appears for the next command. It doesn’t display anything like “done” or “success.”

You can also find out whether a user’s password is set to never expire by following command

Get-MSOLUser -UserPrincipalName <email_account> | Select PasswordNeverExpires

This is a normal case in SharePoint inside Office 365. If you have a new tenancy and you can’t edit the root site collection in SharePoint designer, that’s because editing that root site collection is disabled by default.

Continue reading

If you’re a browser-based user of Office 365 you’ll see some changes. Microsoft has given the online version of their productivity suite a spruce up, refreshing the application launcher and improving the search tool. There’s a also a task-based tool that suggests which tool to use to best complete a particular job

The changes, which are being rolled out progressively o ver the next couple of months, don’t change the apps themselves – that happen quite frequently – but rather how you get to things. It started with a new URL – http://www.office.com

Continue reading

Office 365 users can now get started on the OneDrive experience on SharePoint Document Libraries.. This functionality was  launched into Office 365 libraries last week. The new menus for document are really what users have been seeing for years in their OneDrive and drives uniformity on SharePoint 2016. This new UI has been tested on OneDrive for Business and allows us to get a glimpse of the future plan for SharePoint.

Right now this function is optional to all business subscription, the new document library is actually turned offon  almost every sites automatically. Users can chose to utilize it in their respective groups then decide to revert it back or not after testing it it out. The new Office 365 menu sneak peek is available by clicking the “Check it out” button. Users can press the x to close it or check it out.

Continue reading

This is my presentation on LIFTIT. The topic is focused on: What are BI tools? Which options for Office 365, SharePoint online and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. We will go throught Business intelligence capabilities currently supported in Office 365.
Business Intelligent in Office 365 PresentationBusiness Intelligent in Office 365

Business Intelligent in Office 365_2

Download Business Intelligent (BI) for Office 365 presentation

Hoang Nhut NGUYEN
SharePoint MVP Vietnam
Skype: hoangnhut.nguyen

Last month, I have worked on a requiremnt with public webiste which using Office 365  SharePoint Online and allow anonymous user submit/add data to a specific list.

As your know, When you enable anonymous access to a Web site, you allow anonymous users (and authenticated users who have not been granted access to the site) to browse the entire Web site, including any list, library, folder within a list or library, list item, or document that inherits its permissions from the Web site.

The issue come from Anonymous cannot submit a Contact Form or a Registration form. That mean, in technically, we can not save information to SharePoint for further requirements.

But happy to know that, there is a customized sandbox solution Wsp365.Anonymous.wsp to allow Administration grant Add/Edit permissions to Anonymous user for any custom list.

You can download the solution here, or codeplex, then upload it to https://yourpublicsite.sharepoint.com/_catalogs/solutions/Forms/AllItems.aspx, Active it.

Back to your list, your will see a new ribbon button.


Then you can grant appropriate permission as your expect




Hoang Nhut NGUYEN

SharePoint is growing in VietNam, in 1 month, I met 2 CIO and 1 CEO in banking and reseller business domain. They are planning to build up a collaboration platform for their company. A frequently question but important was placed  – “Should we go with SharePoint on-premise or Office 365?”

In this post, I want to focus some limitations of SharePoint Online that I think they’re important to consider before make decisions

1. Storage


Microsoft offer 3 packages with differences storage capability

– SharePoint Online for Office 365 Small Business
– SharePoint Online for Office 365 Midsize Business
– SharePoint Online for Office 365 Enterprise, Education, and Government

But in generally, let’s make a simple calculation for 10 users which suitable for these 3 packages

  • Team site storage = 10GB + 0.5GB per user
  • Public web site storage = 5GB
  • OneDrive for Business = 10 x 1TB = 10TB (Microsoft just upgrade OneDrive for business from 25GB to 1TB. And please keep in mind that OneDrive will be used for individual people, that mean you can not share it to any team site)
  • Maximum file size you can upload to SharePoint Online can be configured is 2GB per file.

2. Synchronization


OneDrive (SkyDrive old name) can be synced with your desktop version. That mean from your desktop, you can configure to sync your folder with OneDrive as well as a Team Site library. And there are some numbers would be reminded:

  • Can not sync >20,000 items in both SharePoint Online Team Sites + OneDrive
  • Can not sync >5,000 items from SharePoint Onnline Team Sites Library

3. SharePoint Online Site Collection

When you buy a package of SharePoint online as mentioned above, you will get a Site collection with sites/subsites hierarchy. It’s designed numbers of site collection, sites/subsites for your package:

  • Small Business: a single Team Site Collection.
  • Midsize Business plans: limits 20 Team Site Collections.
  • Enterprise, Education, and Government:  limits to 10,000 Team Site Collections.

In all options, just single Public Web Site Collection can be created, 1TB for My sites, 2000 site/subsite per site collection

4. Development Limits


Sandbox Solutions was designed to allow SharePoint developer can customize/develop on Office365/SharePoint Online. Some important limitation you have to consider when go with online solution

  • No access to file/folder. It mean you can not use IO API commands
  • Only be deployed at a site collection level scope (not farm scope)
  • No access to web.config
  • PDF Documents cannot be opened in the browser
  • Restrictions to access security
  • Cannot overuse system resources
  • Limited Server Object model http://msdn.microsoft.com/en-us/library/gg317460(v=office.14)

5. Connection


Most important is the availability and stability of Vietnam connection to Office365.  We have faced with severals of time that we dropped connection by optical cable issues with providers in VietNam. All data will be difficult to reach and very slow connection to download/upload files. If you are decision maker, keep it in mind for the backup connnection solution. Your business in the cloud and make sure it’s always stay in touch.

Hoang Nhut Nguyen
Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen

Just release from last month, Office 365 is opening a new opportunity for your professionals and small businesses Collaboration to everyone. License price is easy to calculate with $6 per person per month, Office 365 is not expensive to bring your business on Cloud and  help you build solutions that leverage SharePoint Online, Exchange Online and Lync Online, Office Web App (Excel, Word, PowerPoint and OneNote)

And a very new release from Microsoft,  Office 365 Developer Training Kit – June 2011 allow you learn how to build collaborative and communication focused cloud solutions that run in Office 365 using Visual Studio 2010 and the .NET Framework

In this post, I would like to introduce my experience to build a solution with Visual Studio 2010 and deploy in Office 365 SharePoint site.

1. First of all, you need to install Visual Studio 2010 SharePoint Power Tools, this extension allow Visual Studio create SharePoint Visual web parts that can be deployed in a sandboxed solution and displays build errors on compile time

2. Create an empty SharePoint 2010 project and provide your local SharePoint 2010 for debugging

3. Add an Visual Webpart for Sandboxed Solution with several asp controls as below

All Lists of this site:
<asp:DropDownList ID=”ddlLists” runat=”server”></asp:DropDownList>
<asp:Button ID=”btnPopularDetails” runat=”server” Text=”Show Details” OnClick=”btnPopularDetails_Click” />
<asp:GridView ID=”gridListsDetails” runat=”server”></asp:GridView></p>

4. Add following code to get all existed list except document library on page load and show details info of selected list to Gridview when clicked on “Show Details” button

 public partial class VisualWebPart1 : System.Web.UI.WebControls.WebParts.WebPart
protected override void OnInit(EventArgs e)
}protected void Page_Load(object sender, EventArgs e)
if (!Page.IsPostBack)
SPWeb web = SPContext.Current.Web;
var listNames = from SPList list in web.Lists
where list.BaseTemplate != SPListTemplateType.DocumentLibrary
select list.Title;
ddlLists.DataSource = listNames;
}protected void btnPopularDetails_Click(object sender, EventArgs e)
SPList sourceList = SPContext.Current.Web.Lists.TryGetList(ddlLists.SelectedValue);
SPQuery qry = new SPQuery();
qry.ViewFieldsOnly = true;
qry.ViewFields = “<FieldRef Name = ‘Title’ /><FieldRef Name = ‘Author’ />”;
qry.RowLimit = 20;
gridListsDetails.DataSource = sourceList.GetItems(qry).GetDataTable();
gridListsDetails.EmptyDataText = string.Format(“List {0} have no data”, ddlLists.SelectedValue);

5. Build project and find Office365.wsp under Debug/Bin folder

6. Login to Office 365 with your account

7. Open  Site Setting and navigate to Solution Galleries

And then, Upload your Solution to this gallery, after that click on Active button to active your solution

8. Finally, Create a new page and insert your webpart to see the result

Related Video resources:

Hoang Nhut Nguyen
Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen
%d bloggers like this: