Haaron Gonzalez – Blog in English Rotating Header Image

Office 365

Get the members of specific Office 365 role

Good day, this time I was asked to retrieve who the Company Administrators and SharePoint Service Administrators are from customer tenant.  The following is the steps I’ve used to deliver the requested Info:

  • I downloaded the Microsoft Online Service Sign-In Assistant from the following URL https://go.microsoft.com/fwlink/p/?LinkId=286152, proceeded to install
  • Install the Azure Active Directory for Windows PowerShell Module, as an Administrator loaded the PowerShell console and executed the Install-Module MSOnline command, specified yes, “Y” two times, first for NuGet and then for Untrusted Repository
  • Inside the PowerShell session, executed the following PowerShell commands:
  1. Import-Module MSOnline
  2. Connect-MsolService this command loaded an authentication window, you need to provide credentials
  3. Get-MsolRole, this command will list all the Office 365 roles, make sure you identify the one you need and copy the Object ID value
  4. Get-MsolRoleMember -RoleObjectId “rol ID” this command will display who the members of the role are






Boost companywide communication with Office 365 and SharePoint Online

More than ever before is clear what organizations intent to do with a successful SharePoint implementation. In my experience lots of companies try achieve better collaboration and communication experiences for their users. We use team sites template to create share-spaces or workspaces for people to collaborate with content and information securely and inside the corporate network, in the other hand, we use publishing sites that allows a better and more sophisticated content authoring experience and publishing features that any communication related department can use for share company wide information accessible to everyone in the network.

As everybody know, Office 365 and SharePoint Online are evolving rapidly, innovation happens fast and get deliver so frequented now, instead of us waiting for a new version release of SharePoint every 3 years.

Today Microsoft started the release of Communication sites to Office 365 customers, so what does this mean?

Communication sites are a special type of site that already has a set feature to boost companywide communication, they already support events, news and other content responsive out of the box. So, no need to pay consultant any more to build beautiful and responsive intranet home pages with carousel web parts or content rollups on top of a publishing site.

Plan and use Communication site to:

  • Make your home page and sub-pages look great
  • Continue the discussion in context to ensure reach, retention and engagement
  • Dynamically pull in and display data, documents and information via web part improvements

Instead of me repeating what is already publish by Microsoft, I leave you the link to the official announcement. After reading this announcement ask yourself. Do you need help planning and adapting your existing Office 365 customizations and publishing investments to this new model?

Microsoft Forms, want to give it a try?  Here is a basic demo

Want to give a try to Microsoft Forms? Yesterday I created a Customer Satisfaction Survey demo to see at a glance the main features of this new technology now available for Office 365 commercial users. I was surprise to see how simple and slick the authoring experience is and of course love the final result. I can see so much power for specific set of scenarios. I just hope that Microsoft consider creating an API for allowing developer build forms and quiz programmatically as well as query the results.

I do see myself building risk matrix surveys (Survey Analysis for Evaluating Risks) for some O365 customers

Just use a Office 365 based credential when deploying programatically

So all people happy and kind of impress with Office 365 Pattern & Practices components, especially the ones that are related to Office 365, is so much easier and simpler the provision things up to SharePoint Online. Recently had to deploy some assets into SharePoint Online, I did use Office 365 PnP as our deployment approach. Everything work just fine in our Office 365 Dev environment but as soon I got to customer tenant our deployment console app didn’t work as expected.

First I notice that customer had ADFS set up and the code when trying to authenticate was throwing the following exception:

Unhandled Exception: Microsoft.SharePoint.Client.IdcrlException: Unable to get ticket due to unknown error.
at Microsoft.SharePoint.Client.Idcrl.IdcrlAuth.GetServiceToken(String securityXml, String serviceTarget, String servicePolicy)
   at Microsoft.SharePoint.Client.Idcrl.IdcrlAuth.GetServiceToken(String username, String password, String serviceTarget, String servicePolicy)
   at Microsoft.SharePoint.Client.Idcrl.SharePointOnlineAuthenticationProvider.GetAuthenticationCookie(Uri url, String username, SecureString password, Boolean alwaysThrowOnFailure, EventHandler`1 executingWebRequest)
   at Microsoft.SharePoint.Client.SharePointOnlineCredentials.GetAuthenticationCookie(Uri url, Boolean refresh, Boolean alwaysThrowOnFailure)
   at Microsoft.SharePoint.Client.ClientRuntimeContext.SetupRequestCredential(ClientRuntimeContext context, HttpWebRequest request)
   at Microsoft.SharePoint.Client.SPWebRequestExecutor.GetRequestStream()
   at Microsoft.SharePoint.Client.ClientContext.GetFormDigestInfoPrivate()
   at Microsoft.SharePoint.Client.ClientContext.EnsureFormDigest()
   at Microsoft.SharePoint.Client.ClientContext.ExecuteQuery()
   at Microsoft.SharePoint.Client.ClientContextExtensions.ExecuteQueryImplementation(ClientRuntimeContext clientContext,Int32 retryCount, Int32 delay)
   at Microsoft.SharePoint.Client.ClientContextExtensions.ExecuteQueryRetry(ClientRuntimeContext clientContext, Int32 retryCount, Int32 delay)
   at BrandingCAN.Program.Main(String[] args) in projectpath\Program.cs:line 41

Did some research and perform several recommendations, but unfortunately didn’t work at all. So, at this moment I still don’t understand what to do to make my console app to authenticate to O365 with ADFS set up and account. But, I did manage to solve the issue just using an Office 365 based credential instead of an ADFS based credential, and that’s what I wanted to share here.

Whenever you deploying something programmatically to O365, please use O365 based credentials like “accountname@company.onmicrosoft.com” and Office 365 PnP and all SharePoint Client APIs will perform as expected.


Compliant at a viable cost

This week I was able to test #office365 and #SharePoint Online for Records Management:

  • Information Management Policies
  • Send To Connections
  • Content Type Hub
  • Manage Metadata
  • Document Sets
  • Content Organizer Rules
  • Search

Soon the details, “the good” and the “ugly”, but what I can say now is:

Very powerful to have all those features available in the cloud for companies that need to be compliant with regulations and retention schedules now. If that is your case please give #office 365 and SharePoint Online a chance.


Questions important to ask when understanding and designing solutions for enterprise customers

Architecting Solutions and SystemsThis week I had the chance to attend the San Diego SharePoint User Group meeting a.k.a @sanspug at the Microsoft San Diego Office. Good to see people interested in the topic Architecting Solutions and Systems presented by Randy Williams. Randy is a Director of AvePoint Client Services so you can tell the level and weight of the presenter, additional he is a great speaker able to have you totally focus and interested in a given topic for hours. Randy explained his take on the steps to consider for architecting solutions and services, he shares some of the questions that are really important to ask ourselves whenever we need to understand a business need and design a solution approach, also he explained some the base principles and technical consideration you should take:

  • Base Principles
    • Know your requirements
    • Tradeoff considerations
    • Return of Investment
  • Infrastructure Architecture
    • Servers
    • Storage
    • Databases
    • Network
  • Cloud Considerations
  • Tips from Randy

So I wanted to take the time to recommend Randy slides and kind of make the point that you should take a look at the content if you design IT solutions for enterprise customers.

By the way, join the San Diego SharePoint User Group here and keep in touch.

I’ll speak at SharePoint Saturday Mexico City 2016



On February 6, 2016 I am going to participate as speaker at SharePoint Saturday Mexico City. I am thrill to participate as speaker and be able to share experiences around some of my favorite topics like Nintex Workflows, ECM and Office 365 groups with the community.

I will present three sessions in Spanish, so here are the titles:

  • The modern office and the rise of dynamic teams
  • Beyond InfoPath: Forms-Driven Workflow Solutions with Nintex
  • Leverage SharePoint Online and Office 365 for Records Management

So, if you live and Mexico City and work as a SharePoint Administrator, SharePoint Consultant or Solution Architect please come by and join me, my plan is to share applicable and real world experiences around Nintex, ECM and Office 365 groups in Spanish “including demos”, so se you there.

Please register at: http://www.spsevents.org/city/mexicocity/mexicocity2016