Bits & Pieces – A blog by Kannan Balasubramanian
When importing a table from Microsoft Excel within Power Automate, only 256 rows are imported by default even if the “Top Count” is used.
To overcome this, access the context menu for that particular step as show below and set the “Threshold” under “Pagination” settings.
Do make sure the “Threshold” value is not set too high or greater than 5000
Sometimes as an architect for Microsoft services, we might be queried by the customer to understand the service level agreements by Microsoft.
The following URL provides the document which has SLA details for each online service Microsoft provides.
https://www.microsoftvolumelicensing.com/DocumentSearch.aspx?Mode=3&DocumentTypeId=37
The documents are categorised based on language and each document has the SLA defined for all the services in one single document. All we have to do is search based on the language and view/download the document.
Once inside the document, view the table of contents and click on the appropriate service. Don’t forget to view the general terms, which explains a few important things before visiting the appropriate service.
Microsoft has provided certification paths for Azure, Microsoft 365, Power Platform and Dynamics 365 for the year 2020.
Following image is the screen capture of the poster available at http://aka.ms/TrainCertPoster.
Sometimes it’s necessary to know the status of all the pages before a site is made live. It becomes especially difficult when a team works together on multiple pages and there are number of pages which might have not been published and site owner has to make sure all the pages are published.
We will create a view which can help a site owner to view unpublished pages or draft pages or published pages in SharePoint.
The technique is using the “Version” column to determine the decimal part of the “Version” by subtracting the integer part from the “Version”. So if there is any decimal value in the “Version” then it’s in unpublished or draft state.
Do note that this technique depends upon the “Document Version History” settings being “Create major and minor (draft) versions” for that library.
This involves two steps
=If((Version-INT(Version))<>0,"Draft","Published")
We can either create a new view or modify an existing view to show the “Page Status”. For this all that needs to be done is add the “Page Status” column to the view.
Sometimes in SharePoint there will be a scenario where users shouldn’t download documents, but yet should be able to view the documents. In many of the sites it’s mentioned that this is not possible. But in reality as of March 2020, this is possible.
Generally the permission level “View Only: Can view pages, list items, and documents. Document types with server-side file handlers can be viewed in the browser but not downloaded.” is not available by default. But the site collection feature “SharePoint Server Enterprise Site Collection features” when activated will enable this permissions level.
Note that this will work only for Microsoft Office files like Word, Excel, PowerPoint etc. Still users will be able to download other file type. The reason is SharePoint uses handler for viewing and editing Microsoft Office files which can prevent download.
Perform the following steps to enable the permission level
Recently when I was trying to change the theme of a SharePoint online site collection, it threw an error “There was an error while attempting to get the themes”
The error looks like the one shown below (Taken from Microsoft Tech Community)
To fix this error, the easiest method as of March 2020 is do the following.
Thanks to Rob for providing the work around here.
When a user tries to create new embed codes using the “Publish to Web” feature, he/she/them will get the error “Contact your admin to enable embed code creation”.
The reason behind this issue is, Microsoft changed the default state of “Publish to web” setting in tenant admin settings. Previously it used to be “Allow existing and new codes” and now it’s “Only allow existing codes”
The fix is simple, just change the settings to “Allow existing and new codes” and users should be able to publish to web.
But wait still the security issue exists. Any user can publish to the web and the report data is exposed to any user on the Internet who has access to the report URL. So the best course of action is to enable the additional security settings, which is “Apply to” “Specific security groups”. Once enabled, only users from a specific security group will be able to create embed codes using “Publish to web”.
For more documentation on the settings, please visit Microsoft Docs
One of the necessity of being a Microsoft 365 based architect is knowing the difference between various licenses or plans.
Though Microsoft provides a good deal of information including plan comparisons, it’s not as easy to understand as we think especially when multiple products are involved.
Following is a link which I came across and seems to be a good one to understand what is included and what is not under one single location.
One of the SharePoint Online administrator of the customer I work with wanted to know the space used by a business user’s private OneDrive.
The following PowerShell script helps to know the exact same information.
The script assumes that you have the SharePoint administrator role in your tenant.
To run this script “SharePoint Online Management Shell” PowerShell module should have been installed
Make sure you update the variables $tenantName & $url
Please note that the below scripts use minimal error handling for simplicity and clean code.
Clear-Host $tenantName = "tenant name" $url = "https://unit4-my.sharepoint.com/personal/<user one drive url>" Connect-SPOService -Url "https://$tenantName-admin.sharepoint.com" $sc = Get-SPOSite $url -Detailed -ErrorAction SilentlyContinue | Select-Object url, storageusagecurrent, Owner $usage = [math]::round(($sc.StorageUsageCurrent/1024),2) $owner = $sc.Owner Write-Host "Site: $url" Write-Host "Owner: $owner" Write-Host "Usage: $usage GB" Disconnect-SPOService
The following script helps to do the same for multiple URLs. All you need is a text file with OneDrive URL per line and it will provide output in a csv file.
$inputFileName = "OneDrive-Usage-URLs.txt"
$outputFileName = "OneDrive-Usage-URLs.csv"
Clear-Host
$tenantName = "tenant name"
Connect-SPOService -Url "https://$tenantName-admin.sharepoint.com"
$inputFile = Get-Content -Path .\$inputFileName
Add-Content .\$outputFileName -Value "URL,Owner,Usage (GB)"
foreach ($url in $inputFile) {
$sc = Get-SPOSite $url -Detailed -ErrorAction SilentlyContinue | Select-Object url, storageusagecurrent, Owner
$usage = [math]::round(($sc.StorageUsageCurrent / 1024), 2)
$owner = $sc.Owner
Add-Content .\$outputFileName -Value "$url,$owner,$usage"
Write-Host "Site: $url"
Write-Host "Owner: $owner"
Write-Host "Usage: $usage GB"
Write-Host ""
}
Disconnect-SPOServicehttps://tenant-my.sharepoint.com/personal/user1_tenant_com https://tenant-my.sharepoint.com/personal/user2_tenant_com
URL,Owner,Usage (GB) https://tenant-my.sharepoint.com/personal/user1_tenant_com,user1@tenant.com,123.45 https://unit4-my.sharepoint.com/personal/user2_tenant_com,user2@tenant.com,678.90
At the time of writing this article, Microsoft has already rolled out the modern experience to all the lists and libraries.
In the old classic sites, there was a possibility to change the the title of Wiki pages and now that is almost gone, but still there is a way to change the title.
Follow the steps below to change the wiki page title.
Do please note that for now this works but not sure how long Microsoft will keep this option open.