SharePoint Excellence

Overview While deployment of apps / add-ins or SPFx solutions to SharePoint Online App Catalog, this solution will be available to all of collections in your tenant as it is centrally deployed. This may lead to a lot of confusion when you are working with a lot of solutions in your Tenant, as all of solutions is available to all site collections as it is deployed centrally in Tenant app catalog. To overcome this problem, Microsoft has introduces Site Collection App Catalog.With the introduction of site collection app catalogs, tenant administrators can enable app catalog on the specific sites. Once enabled, site collection administrators can deploy SharePoint add-ins and SPFx solutions that will be available only in that particular site collection. The following schema illustrates using site collection app catalogs Use below script to Enable / disable site collection app catalog To Enable Site Collection App Catalog $siteUrl = "https://yourdomain-admin.sharepoint...

Overview When we are working with Office 365 in our organization, some time there is requirement to connect on premise AD to get feed and update it. In this article, I’m explaining a case; export data from AD only for specific (custom) attribute and update it in SharePoint user profile. Requirement We are working on Office 365 and in user profile we have created some additional custom attribute. By default, Office 365 supports sync only default properties with AD. To sync additional custom properties, we have to write custom sync engine. Microsoft has released API to sync additional attributes. Solution Microsoft has released Bulk update custom user profile properties for SharePoint Online APIs to direct sync custom attributes from JSON feed file. To achieve solution, below are the steps Create and upload JSON feed file Feed output of step 1, to Microsoft Bulk User Import API Check the status of an import job Create and upload a JSON feed file It’s the im...

Users who are are using Office Mix to create and share interactive online videos based on PowerPoint presentations, got an email last week that Microsoft is retiring the service on May 1, 2018. If you are one of the affected users, please continue with this article. Microsoft will bring the best features of Office Mix directly into PowerPoint, Microsoft Stream, and Microsoft Forms for Office 365 subscribers on Windows PCs without any additional add-in. As the service becomes obsolete, this also means that Microsoft will delete every Office Mix content from their server. In order to avoid losing your data saved into Office Mix workspace, you need to migrate them to Microsoft Stream, or download it into your OneDrive workspace. Everything you need to know about the migration, and the future of these features, are collected into this MS help article: https://support.office.com/en-us/article/Migrate-your-content-from-Office-Mix-c1c04f84-a7bb-4602-9645-258017155258?ui=en-US&rs=en-U...

Symptom : A user at our tenant is not able to share files with external users. This issue is occurring for the Office Group, when the user tries to share a folder from the "Documents", with an external user, the following message appears "Sharing to external users is not supported". However when a colleague shares a document with the same external user account, the sharing is successful. The affected user has created a new Office group and tried to share a document with an external user, however the same message appeared. In the Office Admin Center, Security & Privacy, the tenant has the following settings: Let users add new guests to the organization - on Let users share SharePoint Online and OneDrive for Business content with people outside the organization - on Users can share with - new and existing external users (sign-in required) In the SharePoint Admin center: Allow users to invite and share with authenticated external users Let onl...

Sign in to Office 365 with your tenant administrator account Navigate to Settings > Organization profile Next to Manage custom themes for your organization , click or tap Edit Change the theme elements with below settings Custom logo : Select the McAfee image and upload with a resolution of 200 x 50 pixels, no larger than 10 KB. This appears in the top navigation bar on every page URL for a clickable logo : Enter the URL for the clickable logo, starting with http:// or https://. This is optional Prevent users from overriding theme : Check this box to disable theming at the user level so that everyone in the McAfee sees the same suite bar. Accent colour : set colour code e.g. C01818 Nav bar background colour : Set colour code e.g. C01818 Text and icons : set colour code e.g. FFFFF Click Save Rollback steps Sign in to Office 365 with your tenant administrator account Navigate to Settings > Organization profile Next to Manage custom themes...

As you know that the SharePoint is most popular content Management System, it supports office web apps (All MS Office file types) except Visio files. For Visio files, MS has introduced Visio Web Access web part to show the Visio file to a SharePoint page and this works fantastic. Visio Online  Microsoft has now onboard Visio Online as a part of Office Web Apps (All Office 365 users can test in their environment as this in free of cost with their license) Now It’s time to upgrade your existing solution of Visio file in SharePoint web part to Visio online and it also improve the performance of page load that has vision diagram. Visio Online does not impact Visio Web Access Web Part. If you have SharePoint pages in which VWA Web Part has an embedded Visio diagram, they will continue to work. With Visio Online, you have additional capabilities to do the following: Embed a Visio diagram in "Document" Web Part in Modern team site pages. Build mashup solutions using V...

With the amount of great sessions at Ignite this year, there is no way you could have attended all, and even if they are posted on Channel9 and Youtube, you might want to download them to be able to view them offline! That is why Vlad Catrinescu (SharePoint MVP) created this PowerShell Script so everyone can easily download Microsoft Ignite Videos AND slides whether they were present at Ignite or not! Here are the features: Downloads all the Microsoft Ignite 2016 Sessions and Slides and description in a text file Groups them by folders Makes sure no errors come up due to Illegal File names If you stop the script and restart in the middle, it will start where it left off and not from beginning Filter by keywords in the session title Ability to choose from HD videos, or lower quality How to use: First, make sure to change the $downloadlocation variable. By default it saves it all in C:\Ignite To download all sessions just run the script! (1TB of content in High Defi...

Microsoft has provided an update on a faster and more reliable sync experience so that you always have the latest version of your files accessible from any device.   They will roll out this upgrade over the coming months. The previous sync client will then stop working. If you try to sync your files stored in OneDrive for Business using the old sync client, you will be prompted to install the new sync client.  You can download and set up the Next Generation Sync Client from the following link Download Link

Situation : Using the Skydrive Pro app (Onedrive) to sync the document in SharePoint library. We have around 10,000 documents to upload in SharePoint document library via OneDrive sync app. Sudden, the app has stopped working to sync the document in document library. We have tried to restart the machine but issue still persists. Issue is : Microsoft SkyDrive Pro has stopped working Resolution : We were able to resolve this same issue with the following steps Clear all browsing history on IE Stop syncing all Skydrive Pro folders (have the remaining folders moved away from the original location to avoid duplicate renamed folders) Run IE as administrator and resync the libraries normally If you are facing issue after performing the above mentioned (point 1 to point 3) steps then perform the below other steps Close all your Office processes, such as groove.exe which is SkyDrive Pro,msouc.exe,  msosync.exe,office library sync.  Note : The processes vary based on...

SharePoint search by default crawl all items in list / library and will include default pages (AllItems.aspx, DispForm.aspx etc.).  There is a way to exclude / restrict the default pages from search result. Edit Search result page Edit Search Results WebPart Click " Change query " button under "Search Criteria" In Search query, add IsDocument:"True" and click Test query Click Ok and click Apply and click Stop Editing from ribbon.

Introduction While creating the app in SharePoint we are using JavaScript and Client side object model. In development of app, we would require some basic properties to handle our app, SharePoint provide the few properties with _spPageContextInfo object. _ spPageContextInfo will provide the below properties   webServerRelativeUrl   webAbsoluteUrl siteAbsoluteUrl serverRequestPath layoutsUrl webTitle webTemplate tenantAppVersion isAppWeb webLogoUrl webLanguage currentLanguage currentUICultureName currentCultureName env nid fid clientServerTimeDelta updateFormDigestPageLoaded siteClientTag crossDomainPhotosEnabled webUIVersion webPermMasks pagePersonalizationScope userId userLoginName systemUserKey alertsEnabled siteServerRelativeUrl allowSilverlightPrompt themedCssFolderUrl themedImageFileNames Implementation You can also access this object in JavaScript model as <script type=”text/javascript”> var propertyV...

Microsoft has introduced REST (Representational State Transfer) service along with SharePoint 2013. Now you can use the REST services to access data / information from SharePoint remotely, it means we can perform the CRUD operation with SharePoint data via REST service. Read more about  Get started with the SharePoint 2013 REST service . One Drive for business is a place where you can store, sync and share your work files. SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about  What is OneDrive for Business? Below are the steps to access One Drive data via REST services To access your OneDrive for Business library, you simply click OneDrive in the Office 365 menu bar, as shown Click to "Shared with Everyone" folder  Upload a file to "Shared with Everyone" folder by drag and drop or via click to upload (in our example file name is vivek.docx) To use the REST API to view the information on the uploaded...

Over the last few months, Microsoft has received a lot of great feedback on the Office 365 Autohosted Apps Preview experience. They heard loud and clear that while the goal of a friction-free development experience with the Autohosted Apps Preview was right on track with what developers wanted, the preview experience lacked some critical capabilities that you needed—for example, the ability to access all the features of Microsoft Azure, better insight and transparency into running apps for debugging and monitoring purposes, and more control and options for scaling apps. Microsoft is working closely with the Azure and Visual Studio teams to incorporate developers’ feedback and evolve the autohosted apps model, as well as to deliver a seamless experience for developers by the end of this year. Microsoft announced on dated 16th May 2014 that the Office 365 Autohosted Apps Preview program will end on June 30, 2014. After June 30th, developers will not be able to create new autohosted a...

A good news for all SharePoint developers that needs a CAML Query builder for SharePoint 2013, Office 365 and SharePoint 2010.  The new tool named CAML Designer have a lot of functionalities and good support to Office 365 as well. This tool has been created by  Karine Bosch and Andy Van Steenbergen . You can download it from the downloads tab of the BIWUG site or from  Download link The functionality of this version of the tool is similar to what it offers you for SharePoint 2010 you can build CAML queries for single lists you can build queries that can be executed with SPSiteDataQuery beside the pure CAML queries, you can also get code snippets for the server-side object model, the .NET client-side object model, the JavaScript client-side object model and last but not least code snippets when working with REST. More detailed documentation on CAML and the CAML Designer can be found here . Maximilian Melcher also recorded a video on the ...