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
The following is a simple Cartoon house in 3D. The original inspiration came from this video.
In addition to the objects from the video, I have added a few things like trees, snowy mountain, a lamppost, and a couple of building lights.
Please note that the trees and grasses are not in scale with the house.
The following is a mobile version with resolution of 1080px x 1920px.
I’m still working on the desktop version, will post it once done.
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.
Wallpaper Engine is one of those apps which gives a refreshing look to the PC desktop. I always love one of those looping videos and scenes running on the desktop.
So I came up with the below 3D animation “Smooth Animation” which runs at 4K 60FPS. I hope you like them. The concept is not my idea, it’s based on a tutorial.
Grab the wallpaper here.
Sometimes we need to call a React function from HTML tags with parameters or arguments and following is the ES6 based way.
Here a button is calling a function updateName with argument newName to set a state which in turns changes the name being displayed.
import React, { Component } from 'react';
import { render } from 'react-dom';
import './style.css';
class App extends Component {
constructor() {
super();
this.state = {
name: 'Kannan'
};
}
updateName = (newName) =>{
this.setState({
name: newName
})
}
render() {
return (
<div>
<p>My Name is {this.state.name}.</p>
<p>
<button onClick={this.updateName.bind(this,'Kannan Balasubramanian')}>Change the name</button><br/>
<button onClick={()=>this.updateName('Kannan Balasubramanian!')}>Change the name again</button>
</p>
</div>
);
}
}
render(<App />, document.getElementById('root'));Do note that using this.updateName.bind() is the recommended way due to performance and efficiency concerns.
You can try the sample output here.
Spent a little time in music creation after continuos work from home for almost two weeks.
This music is in 80s genre and was mostly inspired by RemixSample’s Synthwave x Chillwave Fail.
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.