SharePoint (2003 thru Online): July 2019

Monday, July 29, 2019

OneDrive Limitations


  • Individual files cannot exceed 2 gigabytes (GB).
  • File upload size up to 15 GB.
  • Up to 20,000 individual files or folders can be synced with the OneDrive client.
  • The file path (site name + site location + folders + filename) must contain fewer than 400 characters for files synced with the OneDrive client (If you exceed that limit, you'll receive an error message).
  • File names beginning with a tilde (~) & (~$) are not supported.
  • These names aren't allowed for files or folders: .lock, CON, PRN, AUX, NUL, COM0 - COM9, LPT0 - LPT9, _vti_, desktop.ini ("forms" isn't supported when the folder is at the root level for a library.)
  • The following characters are not supported in file names: \ / : * ? " < > | # %
  • You can't add a network or mapped drive as your OneDrive sync location. OneDrive doesn't support syncing using symbolic links or junction points. 
  • Thumbnails & PDF previews are not generated for files larger than 100 MB. 
OneDrive Storage space per user (based on License)


2 GB
Office 365 Enterprise F1

1 TB
Office 365 Business Essentials Office 365 Nonprofit Business Essentials
Office 365 Business Office 365 Nonprofit Business Premium
Office 365 Business Premium Office 365 Nonprofit E1
Office 365 ProPlus OneDrive for Business Plan 1
Office 365 Enterprise E1 SharePoint Online Plan 1
Office 365 Government G1

Beyond 1 TB, to unlimited
Office 365 Enterprise E3 Office 365 Nonprofit E3
Office 365 Enterprise E5 Office 365 Nonprofit E5
OneDrive for Business Plan 2 Microsoft 365 Enterprise E3
SharePoint Online Plan 2 Microsoft 365 Enterprise E5
Office 365 Enterprise E3 Microsoft 365 A3
Office 365 Enterprise E5 Microsoft 365 A5
Office 365 A1 Microsoft 365 US Government G3
Office 365 A3 Microsoft 365 US Government G5
Office 365 A5 Microsoft 365 E3 for nonprofit
Office 365 US Government G3 Microsoft 365 E5 for nonprofit
Office 365 US Government G5

1 TB per user for subscriptions with fewer than 5 users. For subscriptions with 5 or more users, Microsoft will initially provide 1 TB per user, which admins can increase to up to 5 TB per user. To request additional storage, admins must contact Microsoft support.

Wednesday, July 17, 2019

SharePoint Online - Change the look for Communication sites


Site footer is a new SharePoint feature. MSFT will begin rolling this feature out soon. This message is associated with Microsoft 365 Roadmap ID 33138

How does this affect me?
SharePoint Communication sites will have an out-of-the box footer control, which can be controlled either using UI elements or by using APIs. MSFT will be gradually rolling this out to customers in mid-July, and the roll out will be completed worldwide by the end of July.

Note: The site footer feature is only available on communication site site pages. They are not available for list pages, library pages, or other pages on your site.

Footer
Go to your site, click Settings >> Change the look >> Footer, select On Footer visibility & Footer name visibility. Upload the Logo and enter the Footer name. Click Save.

The Footer is visible on the Site. To add or change links in the footer, click Edit in footer navigation.


Click on +, Select URL, enter Address and Display name, Click OK and Click Save. You can add one level of up to eight links or labels. Using ... you can Edit, Move up & Move down or Remove the Footer Navigation links. Using +, you can add new links.


The Footer is visible to users as shown below.


Header
Go to your site, click Settings >> Change the look >> Header, select Standard or Compact for Layout. Upload the Site logo and select the Background style. Click Save.



Navigation
Go to your site, click Settings >> Change the look >> Navigation, select Mega menu or Cascading for Menu style. Click Save.



Theme
Go to your site, click Settings >> Change the look >> Theme, select anyone under SharePoint themes, you will see Customize next to it and Click on it to modify Main color and Accent color. Click Save.

Tuesday, July 16, 2019

Datasheet View error with Office 365 Pro Plus

"The list cannot be displayed in Datasheet view for one or more of the following reasons. 
- A datasheet component compatible with Windows SharePoint Services is not installed.
 - Your browser does not support ActiveX controls.
- A component is not properly configured for 32-bit or 64-bit support".
As Office 2007 end of life was Oct 10, 2017, MSFT stopped sharing the links related to Office 2007 and its components like 2007 Office System Drivers: Data Connectivity Components.

Now a days, many users were using Windows 10 with Office 365 Pro Plus, but still have SharePoint 2007 and SharePoint 2010 sites. When they go to any List and click on Datasheet View, it still shows the above error message.

We searched in MSFT downloads and found links for Access Database Engine for Office 2010 and Office 2016. Installed but didn't work.

Finally we found the download for 2007 Office System Drivers: Data Connectivity Components at the below link and installed.


It worked, without restart of laptop.

Note: Make sure the users are aware of clearing Browser cache and Disk Cleanup to clear the temporary files which causes issues most of the times.

Tuesday, July 9, 2019

Enable Microsoft Cloud App Security and connect to Office 365 (SPO, OneDrive & Dynamics 365)

Note: You should be Global Admin to perform this activity.

Go to Office 365 Security and Compliance >> Alerts >> Manage advanced alerts
Check the box Turn on Office 365 Could App Security and click on Go to Office 365 Could App Security. You will be re-directed to or will open new tab for Cloud App Security (change to your tenant name in the below URL).
https://tenantname.portal.cloudappsecurity.com/#/dashboard

Go to Investigate >> Add an app > Click on +, Select Office 365
Click on 'Connect Office 365'
1. Azure AD Users and groups is selected by default. Select the other required components. (Enable file monitoring to select Office 365 files). 2. Click on Connect. Once you see the message Office 365 was successfully connected, Click Close.
Add Microsoft Azure in the same method.
[OneDrive, SharePoint Online & Dynamics 365 are under Office 365]. 

Under Investigate, Click on Activity log, Files & Users and accounts to view updates.
Under Connected apps, both Office 365 and Microsoft Azure are connected.

Under Investigate, Click on Activity log >>APP, Select apps (filter for Microsoft SharePoint Online). You can see the activity log.



Under Investigate, Click on Files >> APP, Select apps (you can filter for Microsoft SharePoint Online). You can see all the files and perform few tasks (as shown below).


Tuesday, July 2, 2019

New Feature: OneDrive & SharePoint integration with Azure AD B2B (Preview)

MC183679, Stay Informed, Published On : June 28, 2019

OneDrive & SharePoint integration with Azure AD B2B is a new Office 365 feature in preview. We'll begin rolling this preview out soon.

This message is associated with Microsoft 365 Roadmap ID 33415.

How does this affect me?
This integration is disabled by default during preview and so this roll out will not affect you unless you choose to opt-in.

This preview integrates external sharing in SharePoint and OneDrive with Azure AD B2B. This includes external sharing of files, folders, list items, document libraries and sites.

With this integration turned on, when a user shares an item in SharePoint or OneDrive with an external user then a Guest account is immediately created for that external user (if one does not already exist). As a result, any sign-in or conditional access policies in place in your organization will take effect on those external users.

We'll be gradually rolling out the ability to opt-in to the preview starting in late June, and the roll out will be completed worldwide by the end of July.

What do I need to do to prepare for this change?
Because this integration is off by default, while in preview, there is nothing you need to do to prepare for this change. However, once it exits preview next year then you will not be able to turn it off. 


Advantages of Azure AD B2B
  • Invited external users are each given an account in the directory and are subject to Azure AD access policies such as multi-factor authentication.
  • Invitations to a SharePoint site use Azure AD B2B and no longer require users to have or create a Microsoft account.
  • If you have configured Google federation in Azure AD, federated users can now access SharePoint and OneDrive resources that you have shared with them.
  • SharePoint and OneDrive sharing is subject to the Azure AD organizational relationships settings, such as Members can invite and Guests can invite.
Opt in to the Azure AD passcode authentication preview
  • Sign in to the Azure portal as an Azure AD global administrator.
  • In the navigation pane, select Azure Active Directory.
  • Under Manage, select Organizational Relationships.
  • Select Settings.
  • Under Enable Email One-Time Passcode for guests (Preview), select Yes.
  • Click Save.


Opt in to the SharePoint and OneDrive integration with Azure AD B2B
Install the latest version of the SharePoint Online Services Module for Windows PowerShell (min version 8924.1200).

Connect to your tenant by using Connect-SPOService.
Run the following cmdlets:
Set-SPOTenant -EnableAzureADB2BIntegration $true 
Set-SPOTenant -SyncAadB2BManagementPolicy $true


Opting out of the preview
You can disable the preview by running 
Set-SPOTenant -EnableAzureADB2BIntegration $false

(You can also opt out of the Azure AD passcode authentication preview.) 
  • Sign in to the Azure portal as an Azure AD global administrator.
  • In the navigation pane, select Azure Active Directory.
  • Under Manage, select Organizational Relationships.
  • Select Settings.
  • Under Enable Email One-Time Passcode for guests (Preview), select No.
  • Click Save.

Content that was shared externally while the preview was enabled will need to be shared again with the specific external users.

Note that after preview, this feature will replace the ad-hoc external sharing experience used in OneDrive and SharePoint today for all tenants and you will not be able to opt out.

New Feature: Bulk Approvals in SharePoint Online

MC184171, Stay Informed, Published On : July 2, 2019

Bulk Approvals in SPO is a new Office 365 feature. We'll begin rolling this feature out soon.

This enhancement is related to Microsoft 365 Roadmap ID 52716.

How does this impact me?
Once available, users can select multiple items and approve or reject them at the same time.

We'll be gradually rolling this out to Targeted Release customers in early July and the roll out will be completed worldwide by the end of September.


To enable the Content Approval, go to Wheel icon >> Library Settings >> Versioning Settings >> Require content Approval for submitted items? YES

Go back to Document Library and you will see two new columns Approval Status and Approver Comments added to the default view. Select multiple documents and right click, go to Advanced >> Approve/Reject, click. 
A dialog box appears as below, select the option, add comments and click OK.

When item is uploaded to a Content Approval enabled Document Library, you will see a notification 'Notify your team'
Click on 'Notify your team', select the approver and click on Notify. Approve will be notified.

Monday, July 1, 2019

New Feature: 360-degree Image Viewer in SharePoint and OneDrive for Business

MC183957, Stay Informed, Published On : July 1, 2019

The 360-degree Image Viewer is a new Office 365 feature. We'll begin rolling this feature out soon.

This message is associated with Microsoft 365 Roadmap ID 49516.

How does this affect me?
With this feature in place, customers will be able to view 360-degree photos in an interactive, panoramic manner, directly within Sharepoint and OneDrive for Business, when the photo is clicked on for detailed viewing.

Any 360-degree photos uploaded after this feature goes live (basically ones marked with a projection type of "Equirectangular") will be detected as such.

Alternatively, users can manually tag their 360-degree photos to end with ".360.jpg" or ".360.jpeg" to force activation of the 360-degree viewer, for those particular photos.

Before the 360 viewer:

 

With the 360 viewer:
 
The roll out will be complete in early July.