Simple integration between CRM 2011 online and SharePoint 2013 online.

Hi,

I was recently working on a POC that required us to show a kind of integration between CRM 2011 online and SharePoint 2013 online. Basically here based on the case record opened in CRM we wanted to show associated information in the SharePoint 2013 website (could be wiki page, documents, web page etc.) within an iframe of the Case form.

So we first created an Office 365 Preview account for SharePoint 2013.

http://www.microsoft.com/office/preview/en/office-365-enterprise

Added few documents to it and created a custom search result page.

Here the nice thing about SharePoint 2013 is the Document Preview feature. Hover over the search results and user will be able to see the preview of the same.

Here the search term is passed in the query parameter k

https://xxx.sharepoint.com/search/Pages/results.aspx?k=product1

So we simply had to use the same URL in the IFrame inside CRM and in the onload, change the url to add our own value for k query parameter to show respective search results within CRM’s form IFrame.

We already had a CRM 2011 online (trial) instance created in Office 365 online, unfortunately it had SharePoint 2010 online in it and here we specifically wanted to showcase the Document Preview feature which is not in SharePoint 2010.

The issue here was that both CRM 2011 online and SharePoint 2013 online were part of different Office 365 instance. So if we are showing the SharePoint 2013 page within CRM 2010 online it would give the “user not authorized” access.

The solution to this was to give the CRM 2011 online user access to the SharePoint 2013 site.

For this we need to follow the below steps

Select the Sharing option for the selected site collection in the SharePoint administration page

Then

Open the site collection à site settings

Select People and Groups

Add the new user (added the email id of the CRM 2011 online user)

An invitation will be sent to the user’s mail box

CRM 2011 online user can now accept this invitation by logging in with his account. And he would have access to the SharePoint 2013 online site based on the Groups he has added by SharePoint admin. Now the Search Results page of SharePoint 2013 online can be shown inside CRM 2011 without any authentication issue as the user is now member of SharePoint site.

Hope this helps!

Similar Posts

https://nishantrana.wordpress.com/2013/06/13/import-user-profile-properties-in-sharepoint-2013-from-crm-2011-using-bcs/

https://nishantrana.wordpress.com/2013/06/13/integrating-crm-2011-and-sharepoint-2013-using-bcs-wcf-service-crud-operation/

https://nishantrana.wordpress.com/2013/05/04/integrating-crm-2011-online-and-sharepoint-2013-online-using-bcs-odata-proxy/


Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

4 thoughts on “Simple integration between CRM 2011 online and SharePoint 2013 online.”

  1. Thank you for another wonderful post. The place else may anybody get that type of information in such an ideal manner of writing?

    I’ve a presentation subsequent week, and I am on the search for such info.

    Like

Share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s